pinochio Posted October 9, 2009 Share Posted October 9, 2009 I am trying to transfer $_SESSION variables into MySQL. However there is an error in my MySQL statements. Could somebody let me know what excaclty is wrong? Thank you <?php session_start(); if (empty($_SESSION['FirstName']) || empty($_SESSION['LastName']) || empty($_SESSION['HomeAddress']) || empty($_SESSION['HomeCity']) || empty($_SESSION['HomeState']) || empty($_SESSION['HomeZip']) || empty($_SESSION['HomePhone']) || empty($_SESSION['HomeEmail'])|| empty($_SESSION['company'])|| empty($_SESSION['caddress'])|| empty($_SESSION['ccity'])|| empty($_SESSION['czip'])|| empty($_SESSION['cphone'])|| ( !isset($_SESSION['HTML5_camp'])&& !isset($_SESSION['phyton_camp'])&& !isset($_SESSION['perl_camp'])&& !isset($_SESSION['glassfish_camp']) )) header("location:AtendeeReview.php"); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html> <head> <title>Conference</title> </head> <body> <h1>Conference Registration</h1> <?php $DBConnect = @mysqli_connect("localhost", "root", "")//MYSQl connection Or die("<p>Unable to connect to the database server.</p>" . "<p>Error code " . mysqli_connect_errno() . ": " . mysqli_connect_error()) . "</p>"; $DBName = "conference"; //create database if (!@mysqli_select_db($DBConnect, $DBName)) { $SQLstring = "CREATE DATABASE $DBName"; $QueryResult = @mysqli_query($DBConnect, $SQLstring) Or die("<p>Unable to execute the query.</p>" . "<p>Error code " . mysqli_errno($DBConnect) . ": " . mysqli_error($DBConnect)) . "</p>"; echo "<p>Successfully created the database.</p>"; mysqli_select_db($DBConnect, $DBName); } $TableName = "attendees";//create table $SQLstring = "SELECT * FROM $TableName"; $QueryResult = @mysqli_query($DBConnect, $SQLstring); if (!$QueryResult) { $SQLstring = "CREATE TABLE $TableName (attendeeID SMALLINT NOT NULL AUTO_INCREMENT PRIMARY KEY, firstName VARCHAR(40), lastName VARCHAR(40), homeaddress VARCHAR(40), homecity VARCHAR(40), homestate VARCHAR(2), homezip VARCHAR(10), homephone VARCHAR(40), homeemail VARCHAR(40), comapny VARCHAR(50), companyaddress VARCHAR(40), companystate VARCHAR(2), comapnyzip VARCHAR (10), companyphone VARCHAR(40), trainingsessions VARCHAR(40))"; $QueryResult = @mysqli_query($DBConnect, $SQLstring) Or die("<p>Unable to create the $TableName table.</p>" . "<p>Error code " . mysqli_errno($DBConnect) . ": " . mysqli_error($DBConnect)) . "</p>"; echo "<p>Successfully created the $TableName table.</p>"; } $SQLstring = "SELECT * FROM $TableName WHERE firstName='{$_SESSION['FirstName']}' && lastName='{$_SESSION['LastName']}'"; $QueryResult = @mysqli_query($DBConnect, $SQLstring) Or die("<p>Unable to execute the query igor.</p>" . "<p>Error code " . mysqli_errno($DBConnect) . ": " . mysqli_error($DBConnect)) . "</p>"; $NumRows = mysqli_num_rows($QueryResult); if ($NumRows > 0) exit("<p>Your name is already registered for the conference!</p> <form action='PersonalInfo.php' method='post'> <p><input type='submit' value='Back' /></p> </form>"); $FirstName = addslashes($_SESSION['FirstName']); $LastName = addslashes($_SESSION['LastName']); $HAddress = addslashes($_SESSION['HomeAddress']); $HCity = addslashes($_SESSION['HomeCity']); $HState = addslashes($_SESSION['HomeState']); $HZip = addslashes($_SESSION['HomeZip']); $HPhone = addslashes($_SESSION['HomePhone']); $HEmail = addslashes($_SESSION['HomeEmail']); $Company = addslashes($_SESSION['company']); $CAddress = addslashes($_SESSION['caddress']); $CCity = addslashes($_SESSION['ccity']); $CState = addslashes($_SESSION['cstate']); $CZip = addslashes($_SESSION['czip']); $CPhone = addslashes($_SESSION['cphone']); $CEmail = addslashes($_SESSION['cemail']); $HTML5Conf = addslashes($_SESSION['HTML5_camp']); $PhytonConf = addslashes($_SESSION['phyton_camp']); $RubyConf = addslashes($_SESSION['ruby_camp']); $PerlConf = addslashes($_SESSION['perl_camp']); $GlassFishConf = addslashes($_SESSION['glassfish_camp']); $SQLstring = "INSERT INTO $TableName VALUES(NULL, '$FirstName', '$LastName', '$HAddress', '$HCity', '$HState', '$HZip', '$HPhone', '$HEmail', '$Company', '$CAddress', '$CCity', '$CState', '$CZip', '$CPhone', '$CEmail', '$HTML5Conf', '$PhytonConf', '$RubyConf', '$GlassFishConf')"; $QueryResult = @mysqli_query($DBConnect, $SQLstring) Or die("<p>Unable to execute the query.</p>" . "<p>Error code " . mysqli_errno($DBConnect) . ": " . mysqli_error($DBConnect)) . "</p>"; mysqli_close($DBConnect); session_destroy(); ?> Quote Link to comment https://forums.phpfreaks.com/topic/177134-mysql-error/ Share on other sites More sharing options...
Daniel0 Posted October 9, 2009 Share Posted October 9, 2009 Maybe if you posted the generated query along with the error message, people could better help you. Quote Link to comment https://forums.phpfreaks.com/topic/177134-mysql-error/#findComment-934008 Share on other sites More sharing options...
pinochio Posted October 11, 2009 Author Share Posted October 11, 2009 This is the error that I receive: Unable to execute the query. Error code 1136: Column count doesn't match value count at row 1 Quote Link to comment https://forums.phpfreaks.com/topic/177134-mysql-error/#findComment-934700 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.