$_SESSION &amp; DATABASE INSERTS

$_SESSION & DATABASE INSERTS

padanaram

I have a couple scripts. One script is used to display a form to the page using x template.

I also have an html page that is called with that script and has a form action tag that goes out to a script that does database inserts and updates.

Here is the error message I get in the browser.

Fatal error: Call to undefined function: showerrors() in /home/httpd/vhosts/turquoisepueblo.com/httpdocs/eControl/forms/pagesFormSubmit.php on line 366

Here is some sample code in my script. I am using PHP4.2.2.

if (($id == 1) || ($id == 3) || ($id >= 5) && ($id <= $cat))
{
// insert required fields
if (!($result = @ mysql_query ("INSERT INTO pages VALUES ({$pageid},
'{$SESSION["pageFormVars"]["pgtitle"]}',
'{$SESSION["pageFormVars"]["pgdesc"]}',
'{$SESSION["pageFormVars"]["kywd1"]}',
'{$SESSION["pageFormVars"]["kywd2"]}',
'{$SESSION["pageFormVars"]["kywd3"]}',
'{$SESSION["pageFormVars"]["kywd4"]}',
'{$SESSION["pageFormVars"]["kywd5"]}',
'{$SESSION["pageFormVars"]["kywd6"]}',
'{$SESSION["pageFormVars"]["kywd7"]}',
'{$SESSION["pageFormVars"]["kywd8"]}',
'{$SESSION["pageFormVars"]["kywd9"]}',
'{$SESSION["pageFormVars"]["kywd10"]}',
'{$SESSION["pageFormVars"]["kywd11"]}',
'{$SESSION["pageFormVars"]["kywd12"]}',
'{$SESSION["pageFormVars"]["heading"]}',
'{$SESSION["pageFormVars"]["subheading"]}',
'{$SESSION["pageFormVars"]["paragraph1"]}',
'{$SESSION["pageFormVars"]["paragraph2"]}',
'{$SESSION["pageFormVars"]["paragraph3"]}',
'{$SESSION["pageFormVars"]["paragraph4"]}',
'{$SESSION["pageFormVars"]["picturetext1"]}',
'{$SESSION["pageFormVars"]["picturetext2"]}')", $connection)))

showerrors(); // line 366

padanaram

This is me again. I am not using $_SESSION in my script that uses xtemplate. Here is how I parse the data from the database to the html form.

<?php

include "../xtemplate/xtemplate.class.php";
include "../include/include.inc";
include "../include/error.inc";



$id = (int) isSet($_GET['id']) ? $_GET['id'] : 0;
$cat = 22;

set_error_handler("errorHandler");

function errorMessage()
{
	session_register("mesage");

	$message = "Incorrect paramater sent to pagesForm.php";

	// Redirect the browser to the calling page
	header("Location: $HTTP_REFERER");
	exit;
}

if ((empty($id)) || ($id > $cat))
	errorMessage();

$id = clean($id, 5);

// Create a new XTemplate
// notice the directory structure
if (($id >= 5) && ($id <= $cat) || ($id == 1) || ($id == 3))
	$xtpl = new XTemplate ("templates/pagesForm.htm");
elseif ($id == 2)
	$xtpl = new XTemplate ("templates/contactForm.htm");
elseif ($id == 4)
	$xtpl = new XTemplate ("templates/missionForm.htm");
else
	errorMessage();


// Open a connection to the database
if (!($connection = @ mysql_pconnect($hostName,
									$username,
									$password)))
	die("Could not connect to the database");

if (!mysql_select_db($databaseName, $connection))
	showerror();

// Set the pageid	
$pageid = $id + 99;

// Run the query and get the result
if ($id == 2)
{
	if (!($result = @ mysql_query ("SELECT *
			  							FROM pgcontact
			  							WHERE pageid = $pageid", $connection)))
	showerror();
}
elseif (($id >= 3) || ($id == 1))
{
	if (!($result = @ mysql_query ("SELECT *
			  							FROM pages
			  							WHERE pageid = $pageid", $connection)))
	showerror();
}
else
	errorMessage();
// There is only one matching row
$row = @ mysql_fetch_array($result);

// Assign the page data to the template
// This assignment assigns the database table rows to the database table
// XTemplate is case sensitive so the word pages needs to be in the same case as the page call
// In the HTML page the word pages shows like {tablename.tablecolumn} OR {pages.pageid}
$xtpl->assign("pages", $row);

// make row equal to id
$row = array($id);

// assign id to row
$xtpl->assign("id", $row);

// parse id
$xtpl->parse("main.form.id");

// Parse the template data
$xtpl->parse("main.form");

// Parse the whole document
$xtpl->parse("main");

// Output the information to the page
$xtpl->out("main");

thorpe

in your first post... where do you define the function showerrors() ?

and do you have a question in regard to your second post? what?

padanaram

I debugged the showerrors(); error. It should have said showerror(); i still have some problems with my showerror(); function which is in an include file.

I also fixed some syntax in my update queries query. Although right now I am dealign with the insert query, although the problem might just be in my error function..

Here is the new error I am getting from my showerror(); function.

I don't have a problem with the script in my second post. It works.

Fatal error: MySQL error: 1136 : Column count doesn't match value count at row 1 in /home/httpd/vhosts/turquoisepueblo.com/httpdocs/include/error.inc on line 12

Here is my error.inc file.

<?php
// Trigger an error condition
function showerror()
{
if (mysql_errno() || mysql_error())
trigger_error("MySQL error: " .
mysql_errno() .
" : " mysql_error(),
E_USER_ERROR);
else
trigger_error("Could not connect to DBMS",
E_USER_ERROR);
}
// Abort on error. Deletes session varibles to leave
// us in a clean state
function errorHandler($errno, $errstr,
$errfile, $errline)
{
switch ($errno)
{
case E_USER_NOTICE:
case E_USER_WARNING:
case E_WARNING:
case E_NOTICE:
case E_CORE_WARNING:
case E_CORE_NOTICE:
case E_COMPILE_WARNING:
break;
case E_USER_ERROR:
case E_ERROR:
case E_PARSE:
case E_CORE_ERROR:
case E_COMPILE_ERROR:
session_start();

      if (session_is_registered("message"))
         session_unregister("message");

      if (session_is_registered("order_id"))
         session_unregister("order_id");

      $errorString = 
   "Turquoise Pueblo system error: $errstr (# $errno).<br>\n" .
   "Please report the following to the administrator:<br>\n" . "Error in line $errline of
  file $errfile.<br>\n";

              // Send the error to the administrator by email
              error_log($errorString, 1, "greg");

<h2>Turquoise Pueblo is temporarily unavailable</h2>
The following has been reported to the administrator:
<br><b><font color="red"><?=$errorString;?></b></font>
<?php
// Stop the system
die() ;
default:
break;
}
}
?>

Weedpacket

padanaram wrote:
Fatal error: MySQL error: 1136 : Column count doesn't match value count at row 1 in /home/httpd/vhosts/turquoisepueblo.com/httpdocs/include/error.inc on line 12

I guess the number of columns in your query doesn't match the number of colums in the table.

padanaram

I am having problems with a form that submits information using php 4.2.2. Here is what happens. When I submit a post through the form, the from should post the info to the php script and then the php script should insert it inot the database. The pageid for the page that it is updating info for is calculated from the id that is passed through the browser. When I try to query the database the only thing that is inserted in the database is the pageid. Also, images are not submitting to the database? Can anyone help?

Here is part of the script.

<?php
include "../../xtemplate/xtemplate.class.php";
include "../../include/error.inc";
include "../../include/include.inc";

// Initialize an error string
$errorString = "";

$id = (int) isSet($_GET['id']) ? $_GET['id'] : 0;
$pageid = $id + 99;
$picid = $id + 99;
$cat = 22;

            // A fucntion to determine the type of the images
function picture1($type, $picture1, $ext, $connection)
{
	//get info about the image being uploaded
	list($type, $ext) = getimagesize($picture1);

	switch ($type) 
	{
		case 1:
  			$ext = ".gif";
  			break;
		case 2:
		$ext = ".jpg";
		break;
		case 3:
  			$ext = ".swf";
		break;
		default:
  			echo "Sorry, but the file you uploaded was not a GIF, JPG, or " .
     			"SWF file.<br>";
  			echo "Please hit your browser's 'back' button and try again.";
	}
}


// Clear and register an error array
$_SESSION["pageErrors"] = array();

// Set up the pageForm array for the POST variables
$_SESSION["pageFormVars"] = array();

// Clean and trim the POSTed values MAY not need this or may have to do this another way
foreach($_POST as $varname => $value)
	$_SESSION["pageFormVars"]["{$varname}"] = trim(clean($_POST, $varname, $value, 50, $connection));

// Validate the home, about, and native anmerican categories apges
if (($id == 1) || ($id == 3) || ($id >= 5) && ($id <= $cat))
{

                            // Validate a form field
	if (empty($_SESSION["pageFormVars"]["pgtitle"]))
		// The pgtitle for the home page cannot be NULL
		$errorString .= "\n<br>The pgtitle field cannot be blank.";


}
// Now the script has finished validation,
// Check if there were any errors
if (count($_SESSION["pageErrors"]) > 0)
{
	// Redirect the browser to the calling page
	header("Location: $HTTP_REFERER");
	exit;
}

// If we made it here, then the data is valid
if (!($connection = @ mysql_pconnect($hostName,
										$username,
										$password)))
	die("Could not connect to the database");

if (!mysql_select_db($databaseName, $connection))
	showerror();

// Check to see if the pageid is in the database
if ($result = @ mysql_query ("SELECT pageid FROM pages, pgcontact, pgmission
								WHERE pageid = $pageid", $connection)) 			
{
	if (($id == 1) || ($id == 3) || ($id >= 5) && ($id <= $cat))
	{
		// update required fields
	if (!($result = @ mysql_query ("UPDATE pages SET
									pgtitle = '{$_SESSION["pageFormVars"]["pgtitle"]}',
									pgdesc = '{$_SESSION["pageFormVars"]["pgdesc"]}',
									kywd1 = '{$_SESSION["pageFormVars"]["kywd1"]}',
									kywd2 = '{$_SESSION["pageFormVars"]["kywd2"]}',
									kywd3 = '{$_SESSION["pageFormVars"]["kywd3"]}',
									kywd4 = '{$_SESSION["pageFormVars"]["kywd4"]}',
									kywd5 = '{$_SESSION["pageFormVars"]["kywd5"]}',
									kywd6 = '{$_SESSION["pageFormVars"]["kywd6"]}',
									kywd7 = '{$_SESSION["pageFormVars"]["kywd7"]}',
									kywd8 = '{$_SESSION["pageFormVars"]["kywd8"]}',
									kywd9 = '{$_SESSION["pageFormVars"]["kywd9"]}',
									kywd10 = '{$_SESSION["pageFormVars"]["kywd10"]}',
									kywd11 = '{$_SESSION["pageFormVars"]["kywd11"]}',
									kywd12 = '{$_SESSION["pageFormVars"]["kywd12"]}',
									heading = '{$_SESSION["pageFormVars"]["heading"]}',
								subheading = '{$_SESSION["pageFormVars"]["subheading"]}',
								paragraph1 = '{$_SESSION["pageFormVars"]["paragraph1"]}',
								paragraph2 = '{$_SESSION["pageFormVars"]["paragraph2"]}',
								paragraph3 = '{$_SESSION["pageFormVars"]["paragraph3"]}',
								paragraph4 = '{$_SESSION["pageFormVars"]["paragraph4"]}',
								picturetext1 = '{$_SESSION["pageFormVars"]["picturetext1"]}',
								picturetext2 = '{$_SESSION["pageFormVars"]["picturetext2"]}',
								WHERE pageid = {$pageid}", $connection)))
showerror();






		// update picture 1
		if (is_uploaded_file($_FILES["picture1"]["pic1"]))
		{
			picture1($type, $picture1, $ext, $connection);
			if (!($result = @ mysql_query ("UPDATE picture set 
											picture1 = '{$_FILE["pageFormVars"]["picture1"]}'
											WHERE picid = {$pageid}", $connection)))
				showerror();
		}






elseif (!($result = @ mysql_query ("SELECT pageid FROM pages, pgcontact, pgmission
									WHERE pageid = $pageid", $connection)))
{
	if (($id == 1) || ($id == 3) || ($id >= 5) && ($id <= $cat))
	{
		// insert required fields
		if (!($result = @ mysql_query ("INSERT INTO pages VALUES ({$pageid},
										'{$_SESSION["pageFormVars"]["pgtitle"]}',
										'{$_SESSION["pageFormVars"]["pgdesc"]}',
										'{$_SESSION["pageFormVars"]["pgname"]}',
										'{$_SESSION["pageFormVars"]["kywd1"]}',
										'{$_SESSION["pageFormVars"]["kywd2"]}',
										'{$_SESSION["pageFormVars"]["kywd3"]}',
										'{$_SESSION["pageFormVars"]["kywd4"]}',
										'{$_SESSION["pageFormVars"]["kywd5"]}',
										'{$_SESSION["pageFormVars"]["kywd6"]}',
										'{$_SESSION["pageFormVars"]["kywd7"]}',
										'{$_SESSION["pageFormVars"]["kywd8"]}',
										'{$_SESSION["pageFormVars"]["kywd9"]}',
										'{$_SESSION["pageFormVars"]["kywd10"]}',
										'{$_SESSION["pageFormVars"]["kywd11"]}',
										'{$_SESSION["pageFormVars"]["kywd12"]}',
										'{$_SESSION["pageFormVars"]["heading"]}',
										'{$_SESSION["pageFormVars"]["subheading"]}',
										'{$_SESSION["pageFormVars"]["paragraph1"]}',
										'{$_SESSION["pageFormVars"]["paragraph2"]}',
										'{$_SESSION["pageFormVars"]["paragraph3"]}',
										'{$_SESSION["pageFormVars"]["paragraph4"]}',
										'{$_SESSION["pageFormVars"]["picturetext1"]}',
										'{$_SESSION["pageFormVars"]["picturetext2"]}')", $connection)))
				showerror();							





		// insert picture 1 & picture 2
		if ((is_uploaded_file($_FILES["picture1"]["pic1"])) && (is_uploaded_file($_FILES["picture2"]["pic2"])))
		{
			picture1($type, $picture1, $ext, $connection);
			picture2($type, $picture1, $ext, $connection);
			if (!($result = @ mysql_query ("INSERT INTO picture VALUES ({$picid}, {$pageid},
											'{$_FILE["pageFormVars"]["picture1"]}',
											'{$_FILE["pageFormVars"]["picture2"]}')", $connection)))
				showerror();
		}
	}








		if (count($_SESSION["pageErrors"]) > 0)
		{
			// There are errors. Relocate back to the client form
			header("Location: $HTTP_REFERER");
			exit;
		}
	}
}
else
{
	if (count($_SESSION["pageErrors"]) > 0)
	{
		// There are errors. Relocate back to the client form
		header("Location: $HTTP_REFERER");
		exit;
	}
}

// Now show the confirmation page
// header("Location: confirmation.php");

thorpe

sorry, what is the question again? please be more specific. and if you have a new question, let us know if the old problem is fixed. right now it seems your bouncing all over the place.

ps: on a side note, it helps us lots if you use [ php ] [ /php ] tags, makes your code much easier to read.

Weedpacket

What debugging techniques have you tried? What were the results?

padanaram

I have been debugging the script in the browser. So far I have now added session_start(); to the script. session_start(); doesn't work though. For some reason I get this error in the browser when I added session_start() to the script.

Warning: Cannot send session cookie - headers already sent by (output started at /home/httpd/vhosts/turquoisepueblo.com/httpdocs/include/error.inc:67) in /home/httpd/vhosts/turquoisepueblo.com/httpdocs/eControl/forms/pagesFormSubmit.php on line 60

Here is what line 60 looks like.

<PHP>session_start();</PHP>

I also am now having problems connecting to the database since I added session_start to the script. i am also wondering about differences between PHP4.2.2 code and PHP 5 code. I am hoping I have all my syntax and functions written for PHP 4.2.2.

My error that states that it cant connect to the database looks like this.

Warning: Cannot send session cache limiter - headers already sent (output started at /home/httpd/vhosts/turquoisepueblo.com/httpdocs/include/error.inc:67) in /home/httpd/vhosts/turquoisepueblo.com/httpdocs/eControl/forms/pagesFormSubmit.php on line 60
Could not connect to the database

Here is where the first line that says could not connect to the database is in the script. Before I added session_start(); I had no problems connecting to the database.

<PHP> we made it here, then the data is valid
if (!($connection = @ mysql_pconnect($hostName,
$username,
$password)))
die("Could not connect to the database");</PHP>

wempy

Warning: Cannot send session cache limiter - headers already sent (output started at /home/httpd/vhosts/turquoisepueblo.com/httpdocs/include/error.inc:67)

This warning message from php is telling you everything that you need to know, so long as you understand how http works! If, in your scripts, php encounters anything that isn't part of a script it will shove it out to the browser so if you have blank lines or even just a single space before the 1st <?PHP tag then php will construct a header and start sending data to the browser.

The warning above states that output to the browser started at line 67 in the file error.inc so, you could start with that file and look there.

padanaram

I moved the session_start(); up to the top of the script and all my error messages went away except that the script wont connect to the database. I can connect to the database if I comment out session_start(); I read that there is a problem with PHP 4.2.2 and sessions. Maybe there is another way for me to accomplish what I am doing or a way to use sessions that will work correctly.

Can anyone help?