Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
11-16-2012, 12:32 AM #1
- Join Date
- Oct 2012
- Thanked 0 Times in 0 Posts
PHP/form insert statement to mysql
I'm trying to insert this form data into mysql database but I keep getting a server error what am I doing wrong?
<html> <head> <title>Incidence Reporting</title> </head> <body> <h2>Incidence Reporting</h2> <?php $db_s = "localhost"; $db_u = "bs_72"; $db_p = "tmmd2f"; $db_n = "bs_72"; $co = mysqli_connect($db_s,$db_u,$db_p) or die('Error connecting to MySQL server.'); mysqli_select_db($co, $db_n); $first_name = $_POST['firstname']; $last_name = $_POST['lastname']; $e_mail = $_POST['email']; $when_it_happened = $_POST['whenithappened']; $phone_number = $_POST['phonenumber']; $i_description = $_POST['idescription']; $query = “INSERT INTO las_cruces (first_name, last_name, e_mail, when_it_happened, “ . “phone_number, i_description) “ . “VALUES (‘$first_name’, ‘$last_name’,‘$e_mail’, ‘$when_it_happened’ , ‘$phone_number’, “ . “’$i_description’)”; $result = mysqli_query($co, $query); or die('Error querying database.'); mysqli_close($co); echo 'Hello, ' . $first_name . ' ' . $last_name . '<br />'; echo 'Thanks for submitting the form.<br />'; echo 'Your email is ' . $e_mail . '<br />'; echo 'Your phone number? ' . $phone_number . '<br />'; echo 'The date of the incidence was ' . $when_it_happened . '<br />'; echo 'What Happened: ' . $i_description . '<br />'; ?> </body> </html> <form method="post" action="report.php">
11-16-2012, 04:48 AM #2
- Join Date
- Jan 2011
- The Pleiades
- Thanked 29 Times in 29 Posts
I think it might be your query, I've never seen any query written like that in php only in mysql but I might be wrong. Maybe someone could clarify??
Also I noticed you got your
<form>after the closing
Also, what error message are you getting?