Transferring session variables into MySQL
Posted on
16th Feb 2014 07:03 pm by
admin
I am trying to transfer $_SESSION variables into MySQL. However there is an error in my MySQL statements.
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
Could somebody let me know what exactly is wrong?
Code: <?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();
?>
No comments posted yet
Your Answer:
Login to answer
287 
7 
Other forums
Feed Maker
Hi all.
First of all I must say I am not a php developer so I am afraid I don't know much about i
retrieving policy name inside the function called by this particular policy
Hi there,
I've playing around with dbms_rls package, trying to set up some security repo
Cursor statement failed with errors
Following statement failed with the errors.
cursor proj_cursor1 is (select projectID from
MS Exchange 2007 integration with ECC 6.0
Hello Experts,
We have ECC 6.0 and MS Exchange 2007. We need to integrate ECC 6 and MS Excha
Hotlinking Picasa as the image folder of a website
Hi there PHP freaks, I would like to create a private album in Picasa to use it as the image folder
Something like an INI editor or a DelimitedText-Editor
Hi all,
Am very, very, very new to PHP and not sure if I should be posting this to a Javascri
Modal Popup Help
Hi guys, I have a modal popup with an iframe. How can i send data from a label or textbox to the ifr
help with mysql_error()
Hi,
I am trying to insert data into a table, but I am not able to insert it. I wanted to see
Get dump of MySQL DB from Live Site
I'm after an easy, but secure way of generating and importing a MySQL dump from a remote server.
CHECH A STRING FOR ' " ' (DOUBLE QUOTES)
I am checking for delimiter (.!?) and if there is a " after a sentence then it should neglect a
