CodingForums.com

CodingForums.com (http://www.codingforums.com/index.php)
-   PHP (http://www.codingforums.com/forumdisplay.php?f=6)
-   -   PHP/form insert statement to mysql (http://www.codingforums.com/showthread.php?t=282306)

b721991 11-16-2012 12:32 AM

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?



Code:

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


LearningCoder 11-16-2012 04:48 AM

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 </html>

Also, what error message are you getting?

Kind regards,

LC.


All times are GMT +1. The time now is 05:20 AM.

Powered by vBulletin®
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.