PHP Form Help

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Greeting,
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 generate 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 in case 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>



<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" onfiltered="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>

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

}

?>

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux