forms to mysql

Afterburn25 · #1 (**permalink**) 09-23-04, 02:07 AM

I despertly need help im trying to have a form that adds the entries into MYSQL
and i cant get it to work. the form works fine it gets submitted with no errors but it doesnt get put in the database

this is what i have in my form.php

PHP Code:


			
require 'config.php';

$date = date("F d, Y" );

$dbcnx = dbopen();



// Insert Form data into database





$Prefix           = $_POST['Prefix'];

$First_Name       = $_POST['First_Name'];

$Last_Name        = $_POST['Last_Name'];

$Street_Address   = $_POST['Street_Address'];

$Address_Cont     = $_POST['Address_Cont'];

$City             = $_POST['City'];

$State            = $_POST['State'];

$Zip_Code         = $_POST['Zip_Code'];

$Home_Phone       = $_POST['Home_Phone'];

$Cell_Phone       = $_POST['Cell_Phone'];

$Email            = $_POST['Email'];

$Description      = $_POST['Description'];

$Referal          = $_POST['Referal'];

$Technician       = $_POST['Technician'];



$query = "INSERT INTO `Customer Info` SET

          Prefix           = '$Prefix',

          First_Name       = '$First_Name',

          Last_Name        = '$Last_Name',

          Street_Address   = '$Street_Address',

          Address_Cont     = '$Address_Cont',

          City             = '$City',

          State            = '$State'

          Zip_Code         = '$Zip_Code',

          Home_Phone       = '$Home_Phone',

          Cell_Phone       = '$Cell_Phone',

          Email            = '$Email',

          Description      = '$Description',

          Referal          = '$Referal',

          Technician       = '$Technician'";



mysql_query($query) or die(mysql_error());

my config.php is

PHP Code:


			
// Database conection setings

$dbhost = "dbhost ";

$dbuser = "dbuser";

$dbpass = "dbpass";

$dbname = "dbname";



// makes the conection to the db

function dbopen($dbname = "" ){

global $dbuser,$dbpass,$dbhost,$dbname;



//Made the connection

$startconnection = @mysql_connect($dbhost, $dbuser, $dbpass) or print "Unable to connect to the Database.";

@mysql_select_db($dbname, $startconnection) or print "Unable to select database";

return $startconnection;

}





?>

the other problem i am having im getting a mysql syntax error when i try to create my tables this is what i have.

Code:

CREATE TABLE CUSTOMER Info (
  Customer_Number int(10) unsigned NOT NULL auto_increment,
  Prefix varchar(15) NOT NULL default ,
  FIRST_NAME varchar(15) NOT NULL default ,
  Last_Name varchar(15) NOT NULL default ,
  Street_address varchar(30) NOT NULL default ,
  Address_Cont varchar(30) NOT NULL default ,
  City varchar(15) NOT NULL default ,
  State varchar(2) NOT NULL default ,
  Zip_Code varchar(5) NOT NULL default ,
  Home_Phone varchar(12) NOT NULL default ,
  Cell_Phone varchar(12) NOT NULL default ,
  Email varchar(30) NOT NULL default ,
  Description varchar(30) NOT NULL default ,
  Referal varchar(30) NOT NULL default ,
  Technician varchar(30) NOT NULL default ,
  source varchar(30) NOT NULL default ,
  UNIQUE KEY customer_number (customer_number)
)TYPE=MyISAM COMMENT=PC Diagnostics Customer Info;

Please someone help.

mikaelf · #2 (**permalink**) 09-23-04, 02:33 AM

your insert statement is wrong (the same with this thread: http://www.programmingtalk.com/showthread.php?t=12906):

PHP Code:


			
$query = "INSERT INTO `Customer Info` SET 

          Prefix           = '$Prefix', 

          First_Name       = '$First_Name', 

          Last_Name        = '$Last_Name', 

          Street_Address   = '$Street_Address', 

          Address_Cont     = '$Address_Cont', 

          City             = '$City', 

          State            = '$State' 

          Zip_Code         = '$Zip_Code', 

          Home_Phone       = '$Home_Phone', 

          Cell_Phone       = '$Cell_Phone', 

          Email            = '$Email', 

          Description      = '$Description', 

          Referal          = '$Referal', 

          Technician       = '$Technician'";

please refer to mysql manual on how to insert data to a table:
http://dev.mysql.com/doc/mysql/en/INSERT.html

Your sql statement is wrong since you declare default value but never assign it.
It should be (assigning empty string into default field value):

Code:

CREATE TABLE CUSTOMER Info (
  Customer_Number int(10) unsigned NOT NULL auto_increment,
  Prefix varchar(15) NOT NULL default '',
  FIRST_NAME varchar(15) NOT NULL default '',
  Last_Name varchar(15) NOT NULL default '',
  Street_address varchar(30) NOT NULL default '',
  Address_Cont varchar(30) NOT NULL default '',
  City varchar(15) NOT NULL default '',
  State varchar(2) NOT NULL default '',
  Zip_Code varchar(5) NOT NULL default '',
  Home_Phone varchar(12) NOT NULL default '',
  Cell_Phone varchar(12) NOT NULL default '',
  Email varchar(30) NOT NULL default '',
  Description varchar(30) NOT NULL default '',
  Referal varchar(30) NOT NULL default '',
  Technician varchar(30) NOT NULL default '',
  source varchar(30) NOT NULL default '',
  UNIQUE KEY customer_number (customer_number)
)TYPE=MyISAM COMMENT=PC Diagnostics Customer Info;

Bobbi · #3 (**permalink**) 09-23-04, 02:50 AM

I don't mean to frighten you ... but IMMEDIATELY REMOVE YOUR PASSWORD FROM THIS POST if you don't plan on getting into serious troubles.

PHP Code:


			
// Database conection setings 

$dbhost = "mysql2.ixwebhosting.com"; 

$dbuser = "*removed*"; 

$dbpass = "*removed*"; 

$dbname = "pdupuis_Propchelp";

Afterburn25 · #4 (**permalink**) 09-23-04, 02:53 AM

thanks man im so tired i didnt even think of that I guess now im gonna have to change it