help with form post

chele98 · August 15, 2011

I need help with this form everytime I submit a new name to be added to the data base it refreshes the page and clears the form I think my problem is on the mysql hope some one can help.

<?php

session_start();

if (!isset($_SESSION["manager"])) {

header("location: admin_login.php");

exit();

}

// Be sure to check that this manager SESSION value is in fact in the database

// $managerID = preg_replace('#[^0-9]#i', '', $_SESSION["id"]); // filter everything but numbers and letters

// $manager = preg_replace('#[^A-Za-z0-9]#i', '', $_SESSION["manager"]); // filter everything but numbers and letters

// $password = preg_replace('#[^A-Za-z0-9]#i', '', $_SESSION["password"]); // filter everything but numbers and letters

// Run mySQL query to be sure that this person is an admin and that their password session var equals the database information

// Connect to the MySQL database

include "../storescripts/connect_to_mysql2.php";

// $sql = mysql_query("SELECT * FROM admin WHERE id='$managerID' AND username='$manager' AND password='$password' LIMIT 1"); // query the person

// ------- MAKE SURE PERSON EXISTS IN DATABASE ---------

// $existCount = mysql_num_rows($sql); // count the row nums

// if ($existCount == 0) { // evaluate the count

// echo "Your login session data is not on record in the database.";

// exit();

// }

// Error Reporting

error_reporting(E_ALL);

ini_set('display_errors', '1');

?>

<?php

// Parse the form data and add customer to the system

if (isset($_POST['customer_name']) && isset($_POST['address']) && isset($_POST['city'])&& isset($_POST['state'])&& isset($_POST['zip_code']) && isset($_POST['phone_number']) && isset($_POST['email'])&& isset($_POST['order_number'])&& isset($_POST['order_date'])&& isset($_POST['medication'])&& isset($_POST['comment_box'])&& isset($_POST['extra'])){

$customer_name= mysql_real_escape_string($_POST['customer_name']);

$address = mysql_real_escape_string($_POST['address']);

$city = mysql_real_escape_string($_POST['city']);

$state = mysql_real_escape_string($_POST['state']);

$zip_code = mysql_real_escape_string($_POST['zip_code']);

$phone_number = mysql_real_escape_string($_POST['phone_number']);

$email = mysql_real_escape_string($_POST['email']);

$order_number = mysql_real_escape_string($_POST['order_number']);

$order_date = mysql_real_escape_string($_POST['order_date']);

$medication = mysql_real_escape_string($_POST['medication']);

$comment_box = mysql_real_escape_string($_POST['comment_box']);

$extra = mysql_real_escape_string($_POST['extra']);

//See if that customer name is an identical match to another customer in the system

$sql = mysql_query("SELECT customer_name, COUNT(customer_name) AS NumOccurrences FROM cpanel GROUP BY customer_name HAVING ( COUNT(customer_name) > 1 )");

$customerMatch = mysql_num_rows($sql); // count the output amount

if ($customerMatch > 0) {

echo 'Sorry you tried to place a duplicate "Customer Name" into the system, <a href="customer_list.php">Click Here</a>';

exit();

}

// Add new customer into the database now

$sql = mysql_query("INSERT INTO cpanel (customer_name, address, city, state, zip_code, phone_number, email, order_number, order_date, medication, comment_box, extra, date_added)

VALUES('$customer_name','$address','$city','$state','$zip_code','$phone_number','$email',$order_number','$order_date','$medication','$comment_box','$extra',now())") or die (mysql_error());

//$cid = mysql_insert_id();

header("location: customer_list.php");

exit();

}

?>

<?php

// This block grabs the whole list for viewing

$customer_list ="";

$sql = mysql_query("SELECT * FROM `cpanel` ORDER BY `customer_name` DESC LIMIT 0, 30");

$customerCount = mysql_num_rows($sql); // count the output amount

if ($customerCount > 1) {

while($row = mysql_fetch_array($sql)){

$id = $row["id"];

$customer_name = $row["customer_name"];

$address = $row["address"];

$city = $row["city"];

$state = $row["state"];

$zip_code = $row["zip code"];

$phone_number = $row["phone number"];

$email = $row["email"];

$order_number = $row["order number"];

$order_date = $row["order date"];

$medication = $row["medication"];

$comment_box = $row["comment box"];

$extra = $row["extra"];

$customer_list .= "customer ID: $id - $customer_name - $medication - $phone_number - $order_date <br />";

}

} else {

$customer_list = "You have no customer yet";

}

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Customer List</title>

</head>

<body>

<div align="left"><strong><a href="logout.php" class="style3">Logout</a></strong><span class="style1">

</p>

<div align="right" style="margin-right:32px;"><a href="customer_list.php#customerForm">+ Add New customer </div>

<h2 align="center"><strong>Customer List</strong></h2>

<?php echo $customer_list; ?>

</div>

<hr />

↓ Add New Customer ↓

</h3>

<tr>

<td width="20%" align="right">Customer Name</td>

</label></td>

</tr>

<tr>

<td align="right">Address</td>

<td>

</td>

</tr>

<tr>

<td>

</td>

</tr>

<tr>

<td align="right">State</td>

</select></td>

</tr>

<tr>

<td>

</td>

</tr>

<tr>

<td align="right">Phone Number</td>

<td>

</td>

</tr>

<tr>

<td align="right">Email</td>

<td>

</td>

</tr>

<tr>

<td align="right">Order Number</td>

<td>

</td>

</tr><tr>

<td align="right">Order Date</td>

class="hideDropDown moduleDrop"><option value="1">Jan</option>

<option value="-1000" selected="selected">Month</option></select>

</label></td>

</tr>

<tr>

<td align="right">Medication</td>

</label></td>

</tr>

<tr>

<td align="right">Comment Box</td>

</label></td>

</tr>

<tr>

<td align="right">Extra</td>

</label></td>

</tr><br />

<br />

</label></td>

</tr>

</table>

</form>

<br />

</div>

</body>

</html>

AyKay47 · August 15, 2011

without even looking at your code I can tell you that that is what a form is supposed to do.. does the data get added into your database?

chele98 · August 15, 2011

No the form is not posting to my table it only refresh the page and clears the form but it does show what I have all-ready on the table.

AyKay47 · August 15, 2011

no errors received?

are you using mysql_error to debug all of your queries?

chele98 · August 15, 2011

yes and I don't get any error at all just the form not posting on the database I have try to change things around but still don't work I don't know if I m missing something or have something extra

xyph · August 15, 2011

Make sure your If statement is coming through as true. I'm assuming there's nothing wrong with this code block because

if (isset($_POST['customer_name']) && isset($_POST['address']) && isset($_POST['city'])&& isset($_POST['state'])&& isset($_POST['zip_code']) && isset($_POST['phone_number']) && isset($_POST['email'])&& isset($_POST['order_number'])&& isset($_POST['order_date'])&& isset($_POST['medication'])&& isset($_POST['comment_box'])&& isset($_POST['extra'])){

This line never gets executed

header("location: customer_list.php");

chele98 · August 17, 2011

I still need help with this my error must be on the insert to statement no values are stored in my database

this is how my table is structure please help I need to finish this so I can start with my next project I have try changing different things around but no luck and no errors thanks for all your help

id

customer_name

address

city

state

zip code

phone number

email

order number

order date

medication

comment box

extra

darkfreaks · August 17, 2011

your missing a single quote before $order_number

MjM8082 · August 17, 2011

This works fine for me...

 <?php
  
  {

  $customer_name= mysql_real_escape_string($_POST['customer_name']);
   $address = mysql_real_escape_string($_POST['address']);
   $city = mysql_real_escape_string($_POST['city']);
   $state = mysql_real_escape_string($_POST['state']);
   $zip_code = mysql_real_escape_string($_POST['zip_code']);
   $phone_number = mysql_real_escape_string($_POST['phone_number']);
   $email = mysql_real_escape_string($_POST['email']);
   $order_number = mysql_real_escape_string($_POST['order_number']);
   $order_date = mysql_real_escape_string($_POST['order_date']);
   $medication = mysql_real_escape_string($_POST['medication']);
   $comment_box = mysql_real_escape_string($_POST['comment_box']);
   $extra = mysql_real_escape_string($_POST['extra']);




$sql = "INSERT INTO users (customer_name, address, city, state, zip_code, phone_number, email, order_number, order_date, medication, comment_box, extra, date_added) VALUES ('$customer_name','$address','$city','$state','$zip_code','$phone_number','$email',$order_number','$order_date','$medication','$comment_box','$extra');"; 

$db->exec($sql);

}
?>

Sign In

help with form post

Recommended Posts

chele98

Link to comment

Share on other sites

AyKay47

Link to comment

Share on other sites

chele98

Link to comment

Share on other sites

AyKay47

Link to comment

Share on other sites

chele98

Link to comment

Share on other sites

xyph

Link to comment

Share on other sites

chele98

Link to comment

Share on other sites

darkfreaks

Link to comment

Share on other sites

MjM8082

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information