Jump to content

Archived

This topic is now archived and is closed to further replies.

jprangi

From Helo

Recommended Posts

Dear Freaks..
I hope this is the right place for this. If not please guide me.
I am having problem with my form. Code is below. I want to generat an error message if the required fields are not filled. If they are filled then I want to add them to the database and display the form again to make another entry. Database part is working fine. But when it exist with an error for blank entry, it wipe out all the values the user has entered, how can I save user input incase user does not have to enter all the values again.
Thank you for help.



<?php
include "db.php";


echo "Title is " . $_POST['title'];
//logincheck();
session_start();
echo "You are logged in $user";

if (isset($message))
{
echo "<font color=\"red\">{$message} </font><br>";
echo "You are logged in $user";

?>
<html>
<body>


<table border=0 width=80% height=100% align=center border=0 cellspacing=0 cellpadding=0
STYLE="color: <? echo($fontcol); ?>;" bgcolor=<? echo($BOXCOLOR); ?>>
<tr width=100% background="./images/bg.jpg">
<td width=100% background="./images/bg.jpg" align="center">
<div style="border: 2px groove #888888; border-left: 0px; border-right: 0px;"><br>

<br><br></div>
</td></tr>



<tr width=100% >
<td width=100% align="center">

<div align="center">
<form name=sds action="<?php echo $_SERVER['PHP_SELF']; ?>" METHOD="POST" onsubmit="return check()">
<table cellpadding=4 cellspacing=0 border=0>
<tr><td><font color=<? echo($FONTCOLOR); ?>><i>Title: * </i></font></td><td><input type="text" name="title" size=40 value="<?=$_POST['title']?>" ></td></tr>
<tr><td><font color=<? echo($FONTCOLOR); ?>><i>Location : </i></font></td><td><input type="text" name="location" size=40 ></td></tr>
<tr><td><font color=<? echo($FONTCOLOR); ?>><i>City: * </i></font></td><td><input type="text" name="City" size=15></td></tr>

<tr><td><font color=<? echo($FONTCOLOR); ?>><i>Email: * </i></font></td><td><input type="text" name="Email" size=40 value="<? echo($user); ?>"></td></tr>
<tr><td><font color=<? echo($FONTCOLOR); ?>><i>Phone: * </i></font></td><td><input type="text" name="Phone" size=40></td></tr>

<tr><td><font color=<? echo($FONTCOLOR); ?>><i>Main Keywords for this search: * </i></font></td><td><input type="text" name="Keywords" size=60></td></tr>

<td></td>
<tr><td colspan=2><font color=<? echo($FONTCOLOR);?> ><b>Article Details: * </b></font><br>
<textarea name="Details" rows=13 cols=55 wrap=physical></textarea>
</td></tr>


<tr><td colspan=2 align=center><input type="submit" value="NEXT"></td></tr>
</table>
</form>
</div>
</td>
</tr>

</table>
</body>
</html>

<?php

}else
{


if (empty($title) || empty($Email) || empty($Phone) || empty($Details) || empty($Keywords) || empty($City))
{
$message = "Please fill all the required fields.";
// Now, redirect the browser to the current page
session_start();
header("Location: form.php?message=" . urlencode($message));

}
else
{
// Connect to the MySQL DBMS - credentials are in the file db.php
if (!($connection = @ mysql_pconnect($hostName, $username, $password)))
showerror();

// Use the User database
if (!mysql_select_db($databaseName, $connection))
showerror();

// Create a query to find The Company ID
$query = "SELECT ID
FROM table
WHERE email = \"$user\"";

// Run the query through the connection

if (!($result = @ mysql_query($query, $connection)))
showerror();

// Were there any matching rows?
if (mysql_num_rows($result) == 0)
{
// No. So insert the new username and password into the table
$message = "The user account -<b>$user</b>- does not have ID.";

// Now, redirect the browser to the current page
header("Location: form.php?message=" . urlencode($message));
exit;
}
$row = @ mysql_fetch_array($result);
$ID = (rand()%9999);
$CID = $row["CompID"];

$jquery = "INSERT INTO table (Title,Email,Phone,Details,Keywords,Location,City,) Values('$title','$Email','$Phone','$Details','$Keywords','$location','$City')";


if (!($result = @ mysql_query($query, $connection)))
showerror();

$message = "Your Article has been posted. Fill in the form to post more Articles";

// Now, redirect the browser to the current page
header("Location: form.php?message=" . urlencode($message));
exit;
}

}

?>

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.