From Helo

jprangi · April 5, 2006

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;
}

}

?>

Sign In

From Helo

Recommended Posts

jprangi

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information