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("Unable to connect to the database server."
. "Error code " . mysqli_connect_errno()
. ": " . mysqli_connect_error()) . "";
$DBName = "conference"; //create database
if (!@mysqli_select_db($DBConnect, $DBName)) {
$SQLstring = "CREATE DATABASE $DBName";
$QueryResult = @mysqli_query($DBConnect, $SQLstring)
Or die("Unable to execute the query."
. "Error code " . mysqli_errno($DBConnect)
. ": " . mysqli_error($DBConnect)) . "";
echo "Successfully created the database.";
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("Unable to create the $TableName table."
. "Error code " . mysqli_errno($DBConnect)
. ": " . mysqli_error($DBConnect)) . "";
echo "Successfully created the $TableName table.";
}
$SQLstring = "SELECT * FROM $TableName WHERE firstName='{$_SESSION['FirstName']}' && lastName='{$_SESSION['LastName']}'";
$QueryResult = @mysqli_query($DBConnect, $SQLstring)
Or die("Unable to execute the query igor."
. "Error code " . mysqli_errno($DBConnect)
. ": " . mysqli_error($DBConnect)) . "";
$NumRows = mysqli_num_rows($QueryResult);
if ($NumRows > 0)
exit("Your name is already registered for the conference!
<form action='PersonalInfo.php' method='post'>
<input type='submit' value='Back' />
</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("Unable to execute the query."
. "Error code " . mysqli_errno($DBConnect)
. ": " . mysqli_error($DBConnect)) . "";

mysqli_close($DBConnect);
session_destroy();
?>

No comments posted yet

Your Answer:

287

Other forums

Check before inserting in DB ???
This is my code
---------------
if ( $_POST ['Submit'])
{{
$username = $_POST ['usernm

Script not running properly
Hello Everyone
This is a basic script for posting to a database. I'm not sure why it doesn't work

Pagination
Okay here is the page in question: http://blenderteachings.000a.biz/tutorials.hamishhill.php

PHP Upload issue
Hi guys,

I have stumble across an interesting issue with my script and is doing my head in.

Combining refCursors and Summing
Given the following DDL:

CREATE TABLE FOODSALESTEST ("WEEKNBR" NUMBER, "ST

Linking with Foreign Keys
I have been getting an erro when I try and link:

create table Faculty_Specialty (I_Name v

Text Not Displaying Correctly With PHP:GD
I recently moved servers and since then I have noticed that one line of text is showing weirdly.

Gerenate tabel in Php
I whant to generate a tabel takeing data from database like this one so the results to be display on

Array to string conversion
Can anyone help me with this?

Notice: Array to string conversion in /home/..../index.php on l

Indyaspeak

Transferring session variables into MySQL

Your Answer:

Other forums

Follow Us