help insert problems[solved]

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
nexus6
Forum Newbie
Posts: 20
Joined: Fri Jun 17, 2005 3:50 am
Location: Denmark

help insert problems[solved]

Post by nexus6 »

When i try to add a new item it returns as it should, except
that it doesent insert the item into the table

my insert.php:

Code: Select all

<?php
	function errHandler($errno, $errstr, $errfile, $errline) {
		echo "Error: <b>[$errno at line $errline] $errstr</b><br />\n";
	}

	set_error_handler("errHandler");

$db = "c:/server/sqlite/selection.db";
$handle = sqlite_open($db) or die("Could not open database");
$query  = "";

if (isset($_GET["tableName"])) {
$table = sqlite_escape_string($_GET["tableName"]);

	if (!empty($_POST['title'])
	 && !empty($_POST['info_dk'])
	 && !empty($_POST['info_uk'])
	 && !empty($_POST['land'])
	 && !empty($_POST['vol'])
         && !empty($_POST['size'])
	 && !empty($_POST['price'])) {

$id = md5(mktime());
$title	= sqlite_escape_string($_POST['title']);
$info_dk = sqlite_escape_string($_POST['info_dk']);
$info_uk = sqlite_escape_string($_POST['info_uk']);
$land = sqlite_escape_string($_POST['land']);
$vol = sqlite_escape_string($_POST['vol']);
$size = sqlite_escape_string($_POST['size']);
$price = sqlite_escape_string($_POST['price']);

$query = "INSERT INTO $table (item_id, title, info_dk, info_uk, land, vol, size, price) VALUES('$id',
	      '$title',
	      '$info_dk',
	      '$info_uk',
	      '$land',
	      '$vol',
              '$size',
	      '$price')" or die("Error in query: ".sqlite_error_string(sqlite_last_error($handle)));
 
}
echo "Record added.";

}
echo "Returning to main.";
	header ("Location: ../index2.php");
  exit;
?>
there is no errors - what can be wrong?te;;
}

set_error_handler("errHandler&quote;);

$db = &quote;c:/server/sqlite/selection.db&quote;;
$handle = sqlite_open($db) or die(&quote;Could not open database&quote;);
$query = &quote;&quote;;

if (isset($_GETї&quote;tableName&quote;])) {
$table = sqlite_escape_string($_GETї&quote;tableName&quote;]);

if (!empty($_POSTї'title'])
&amp;&amp; !empty($_POSTї'info_dk'])
&amp;&amp; !empty($_POSTї'info_uk'])
&amp;&amp; !empty($_POSTї'land'])
&amp;&amp; !empty($_POSTї'vol'])
&&amp; !empty($_POSTї'size'])
&amp;&amp; !empty($_POSTї'price'])) {

$id = md5(mktime());
$title = sqlite_escape_string($_POSTї'title']);
$info_dk = sqlite_escape_string($_POSTї'info_dk']);
$info_uk = sqlite_escape_string($_POSTї'info_uk']);
$land = sqlite_escape_string($_POSTї'land']);
$vol = sqlite_escape_string($_POSTї'vol']);
$size = sqlite_escape_string($_POSTї'size']);
$price = sqlite_escape_string($_POSTї'price']);

$query = &quote;INSERT INTO $table (item_id, title, info_dk, info_uk, land, vol, size, price) VALUES('$id',
'$title',
'$info_dk',
'$info_uk',
'$land',
'$vol',
'$size',
'$price')&quote; or die(&quote;Error in query: &quote;.sqlite_error_string(sqlite_last_error($handle)));

}
echo &quote;Record added.&quote;;

}
echo &quote;Returning to main.&quote;;
header ("Location: ../index2.php&quote;);
exit;
?&gt;

there is no errors - what can be wrong?ite_escape_string($_POST['info_uk']);
$land = sqlite_escape_string($_POST['land']);
$vol = sqlite_escape_string($_POST['vol']);
$size = sqlite_escape_string($_POST['size']);
$price = sqlite_escape_string($_POST['price']);

$query = "INSERT INTO $table (item_id, title, info_dk, info_uk, land, vol, size, price) VALUES('$id',
'$title',
'$info_dk',
'$info_uk',
'$land',
'$vol',
'$size',
'$price')&quote; or die(&quote;Error in query: &quote;.sqlite_error_string(sqlite_last_error($handle)));

}
echo &quote;Record added.&quote;;

}
echo &quote;Returning to main.&quote;;
header (&quote;Location: ../index2.php&quote;);
exit;
?>

there is no errors - what can be wrong? function errHandler($errno, $errstr, $errfile, $errline) {
echo "Error: <b>[$errno at line $errline] $errstr</b><br />\n&quote;;
}

set_error_handler(&quote;errHandler&quote;);

$db = &quote;c:/server/sqlite/selection.db&quote;;
$handle = sqlite_open($db) or die(&quote;Could not open database&quote;);
$query = &quote;&quote;;

if (isset($_GETї&quote;tableName&quote;])) {
$table = sqlite_escape_string($_GETї&quote;tableName&quote;]);

if (!empty($_POSTї'title'])
&amp;&amp; !empty($_POSTї'info_dk'])
&amp;&amp; !empty($_POSTї'info_uk'])
&amp;&amp; !empty($_POSTї'land'])
&amp;&amp; !empty($_POSTї'vol'])
&amp;&amp; !empty($_POSTї'size'])
&amp;&amp; !empty($_POSTї'price'])) {

$id = md5(mktime());
$title = sqlite_escape_string($_POSTї'title']);
$info_dk = sqlite_escape_string($_POSTї'info_dk']);
$info_uk = sqlite_escape_string($_POSTї'info_uk']);
$land = sqlite_escape_string($_POSTї'land']);
$vol = sqlite_escape_string($_POSTї'vol']);
$size = sqlite_escape_string($_POSTї'size']);
$price = sqlite_escape_string($_POSTї'price']);

$query = &quote;INSERT INTO $table (item_id, title, info_dk, info_uk, land, vol, size, price) VALUES('$id',
'$title',
'$info_dk',
'$info_uk',
'$land',
'$vol',
'$size',
'$price')&quote; or die(&quote;Error in query: &quote;.sqlite_error_string(sqlite_last_error($handle)));

}
echo &quote;Record added.&quote;;

}
echo &quote;Returning to main.&quote;;
header (&quote;Location: ../index2.php&quote;);
exit;
?&gt;

there p;amp;lt;br />\n";
}

set_error_handler("errHandler");

$db = "c:/server/sqlite/selection.db";
$handle = sqlite_open($db) or die("Could not open database");
$query = "";

if (isset($_GET["tableName"])) {
$table = sqlite_escape_string($_GET["tableName"]);

if (!empty($_POSTї'title'])
&amp;&amp; !empty($_POSTї'info_dk'])
&amp;&amp; !empty($_POSTї'info_uk'])
&amp;&amp; !empty($_POSTї'land'])
&amp;&amp; !empty($_POSTї'vol'])
&amp;&amp; !empty($_POSTї'size'])
&amp;&amp; !empty($_POSTї'price'])) {

$id = md5(mktime());
$title = sqlite_escape_string($_POSTї'title']);
$info_dk = sqlite_escape_string($_POSTї'info_dk']);
$info_uk = sqlite_escape_string($_POSTї'info_uk']);
$land = sqlite_escape_string($_POSTї'land']);
$vol = sqlite_escape_string($_POSTї'vol']);
$size = sqlite_escape_string($_POSTї'size']);
$price = sqlite_escape_string($_POSTї'price']);

$query = &quote;INSERT INTO $table (item_id, title, info_dk, info_uk, land, vol, size, price) VALUES('$id',
'$title',
'$info_dk',
'$info_uk',
'$land',
'$vol',
'$size',
'$price')&quote

$db = "c:/server/sqlite/selection.db";
$handle = sqlite_open($db) or die("Could not open database");
$query = "";

if (isset($_GET["tableName"])) {
$table = sqlite_escape_string($_GET["tableName"]);

if (!empty($_POST['title'])
&& !empty($_POST['info_dk'])
&& !empty($_POST['info_uk'])
&amp;&amp; !empty($_POSTї'land'])
&amp;&amp; !empty($_POSTї'vol'])
&amp;&amp; !empty($_POSTї'size'])
&amp;&amp; !empty($_POSTї'price'])) {

$id = md5(mktime());
$title = sqlite_escape_string($_POSTї'title']);
$info_dk = sqlite_escape_string($_POSTї'info_dk']);
$info_uk = sqlite_escape_string($_ the item into the table

my insert.php:

Code: Select all

<?php
	function errHandler($errno, $errstr, $errfile, $errline) {
		echo &quote;Error: <b>[$errno at line $errline] $errstr&lt;/b&gt;&lt;br /&gt;\n&quote;;
	}

	set_error_handler(&quote;errHandler&quote;);

$db = &quote;c:/server/sqlite/selection.db&quote;;
$handle = sqlite_open($db) or die(&quote;Could not open database&quote;);
$query  = &quote;&quote;;

if (isset($_GET&#1111;&quote;tableName&quote;])) {
$table = sqlite_escape_string($_GET&#1111;&quote;tableName&quote;]);

	if (!empty($_POST&#1111;'title'])
	 &amp;&amp; !empty($_POST&#1111;'info_dk'])
	 &amp;&amp; !empty($_POST&#1111;'info_uk'])
	 &amp;&amp; !empty($_POST&#1111;'land'])
	 &amp;&amp; !empty($_POST&#1111;'vol'])
         &amp;&amp; !empty($_POST&#1111;'size'])
	 &amp;&amp; !empty($_POST&#1111;'price'])) {

$id = md5(mktime());
$title	= sqlite_escape_string($_POST&#1111;'title']);
$info_dk = sqlite_escape_string($_POST&#1111;'info_dk']);
$info_uk = sqlite_escape_string($_POST&#1111;'info_uk']);
$land = sqlite_escape_string($_POST&#1111;'land']);
$vol = sqlite_escape_string($_POST&#1111;'vol']);
$size = sqlite_escape_string($_POST&#1111;'size']);
$price = sqlite_escape_string($_POST&#1111;'price']);

$query = &quote;INSERT INTO $table (item_id, title, info_dk, info_uk, land, vol, size, price) VALUES('$id',
	      '$title',
	      '$info_dk',
	      '$info_uk',
	      '$land',
	      '$vol',
              '$size',
	      '$price')&quote; or die(&quote;Error in query: a new item it returns as it should, except 
that it doesent insert the item into the table

my insert.php:

Code: Select all

<?php
	function errHandler($errno, $errstr, $errfile, $errline) {
		echo "Error: <b>[$errno at line $errline] $errstr</b><br />\n";
	}

	set_error_handler("errHandler");

$db = "c:/server/sqlite/selection.db";
$handle = sqlite_open($db) or die("Could not open database");
$query  = "";

if (isset($_GET["tableName"])) {
$table = sqlite_escape_string($_GET["tableName"]);

	if (!empty($_POST['title'])
	 && !empty($_POST['info_dk'])
	 && !empty($_POST['info_uk'])
	 && !empty($_POST['land'])
	 && !empty($_POST['vol'])
         && !empty($_POST['size'])
	 && !empty($_POST['price'])) {

$id = me645e]
<?php
	function errHandler($errno, $errstr, $errfile, $errline) {
		echo &quote;Error: &lt;b&gt;&#1111;$errno at line $errline] $errstr</b><br />\n";
	}

	set_error_handler("errHandler");

$db = "c:/server/sqlite/selection.db";
$handle = sqlite_open($db) or die(&quote;Could not open database&quote;);
$query  = &quote;&quote;;

if (isset($_GET&#1111;&quote;tableName&quote;])) {
$table = sqlite_escape_string($_GET&#1111;&quote;tableName&quote;]);

	if (!empty($_POST&#1111;'title'])
	 &amp;&amp; !empty($_POST&#1111;'info_dk'])
	 &amp;&amp; !empty($_POST&#1111;'info_uk'])
	 &amp;&amp; !empty($_POST&#1111;'land'])
	 &amp;&amp; !empty($_POST&#1111;'vol'])
         &amp;&amp; !empty($_POST&#1111;'size'])
	 &amp;&amp; !empty($_POST&#1111;'price'])) {

$id = md5(mktime());
$title	= sqlite_escape_string($_POST&#1111;'title']);
$info_dk = sqlite_escape_string($_POST&#1111;'info_dk']);
$info_uk = sqlite_escape_string($_POST&#1111;'info_uk']);
$land = sqlite_escape_string($_POST&#1111;'land']);
$vol = sqlite_escape_string($_POST&#1111;'vol']);
$size = sqlite_escape_string($_POST&#1111;'size']);
$price = sqlite_escape_string($_POST&#1111;'price']);

$query = &quote;INSERT INTO $table (item_id, title, info_dk, info_uk, land, vol, size, price) VALUES('$id',
	      '$title',
	      '$info_dk',
	      '$info_uk',
	      '$land',
	      '$vol',
              '$size',
	      '$price')&quote; or die(&quote;Error in query: &quote;.sqlite_errecho "Error: &lt;b&gt;&#1111;$errno at line $errline] $errstr&lt;/b&gt;<br /&gt;\n&quote;;
	}

	set_error_handler(&quote;errHandler&quote;);

$db = &quote;c:/server/sqlite/selection.db&quote;;
$handle = sqlite_open($db) or die(&quote;Could not open database&quote;);
$query  = &quote;&quote;;

if (isset($_GET&#1111;&quote;tableName&quote;])) {
$table = sqlite_escape_string($_GET&#1111;&quote;tableName&quote;]);

	if (!empty($_POST&#1111;'title'])
	 &amp;&amp; !empty($_POST&#1111;'info_dk'])
	 &amp;&amp; !empty($_POST&#1111;'info_uk'])
	 &amp;&amp; !empty($_POST&#1111;'land'])
	 &amp;&amp; !empty($_POST&#1111;'vol'])
         &amp;&amp; !empty($_POST&#1111;'size'])
	 &amp;&amp; !empty($_POST&#1111;'price'])) {

$id = md5(mktime());
$title	= sqlite_escape_string($_POST&#1111;'title']);
$info_dk = sqlite_escape_string($_POST&#1111;'info_dk']);
$info_uk = sqlite_escape_string($_POST&#1111;'info_uk']);
$land = sqlite_escape_string($_POST&#1111;'land']);
$vol = sqlite_escape_string($_POST&#1111;'vol']);
$size = sqlite_escape_string($_POST&#1111;'size']);
$price = sqlite_escape_string($_POST&#1111;'price']);

$query = &quote;INSERT INTO $table (item_id, title, info_dk, info_uk, land, vol, size, price) VALUES('$id',
	      '$title',
	      '$info_dk',
	      '$info_uk',
	      '$land',
	      '$vol',
              '$size',
	      '$price')&quote; or die(&quote;Error in query: &quote;.sqlite_error_string(sqlite_last_error($handle)));
 
}
echo &quote;1]
<?php
	function errHandler($errno, $errstr, $errfile, $errline) {
		echo &quote;Error: &lt;b&gt;&#1111;$errno at line $errline] $errstr&lt;/b&gt;&lt;br /&gt;\n&quote;;
	}

	set_error_handler(&quote;errHandler&quote;);

$db = &quote;c:/server/sqlite/selection.db&quote;;
$handle = sqlite_open($db) or die("Could not open database");
$query  = "";

if (isset($_GET["tableName"])) {
$table = sqlite_escape_string($_GET["tableName"]);

	if (!empty($_POST['title'])
	 && !empty($_POST&#1111;'info_dk'])
	 &amp;&amp; !empty($_POST&#1111;'info_uk'])
	 &amp;&amp; !empty($_POST&#1111;'land'])
	 &amp;&amp; !empty($_POST&#1111;'vol'])
         &amp;&amp; !empty($_POST&#1111;'size'])
	 &amp;&amp; !empty($_POST&#1111;'price'])) {

$id = md5(mktime());
$title	= sqlite_escape_string($_POST&#1111;'title']);
$info_dk = sqlite_escape_string($_POST&#1111;'info_dk']);
$info_uk = sqlite_escape_string($_POST&#1111;'info_uk']);
$land = sqlite_escape_string($_POST&#1111;'land']);
$vol = sqlite_escape_string($_POST&#1111;'vol']);
$size = sqli0de645e]
<?php
	function errHandler($errno, $errstr, $errfile, $errline) {
		echo "Error: <b>[$errno at line $errline] $errstr</b><br />\n";
	}

	set_error_handler("errHandler");

$db = "c:/server/sqlite/selection.db";
$handle = sqlite_open($db) or die("Could not open database&quote;);
$query  = &quote;&quote;;

if (isset($_GET&#1111;&quote;tableName&quote;])) {
$table = sqlite_escape_string($_GET&#1111;&quote;tableName&quote;]);

	if (!empty($_POST&#1111;'title'])
	 &amp;&amp; !empty($_POST&#1111;'info_dk'])
	 &amp;&amp; !empty($_POST&#1111;'info_uk'])
	 &amp;&amp; !empty($_POST&#1111;'land'])
	 &amp;&amp; !empty($_POST&#1111;'vol'])
         &amp;&amp; !empty($_POST&#1111;'size'])
	 &amp;&amp; !empty($_POST&#1111;'price'])) {

$id = md5(mktime());
$title	= sqlite_escape_string($_POST&#1111;'title']);
$info_dk = sqlite_escape_string($_POST&#1111;'info_dk']);
$info_uk = sqlite_escape_string($_POST&#1111;'info_uk']);
$land = sqlite_escape_string($_POST&#1111;'land']);
$vol = sqlite_escape_string($_POST&#1111;'vol']);
$size = sqlite_escape_string($_POST&#1111;'size']);
$price = sqlite_escape_string($_POST&#1111;'price']);

$query = &quote;INSERT INTO $table (item_id, title, info_dk, info_uk, land, vol, size, price) VALUES('$id',
	      '$title',
	      '$info_dk',
	      '$info_uk',
	      '$land',
	      '$vol',
              '$size',
	      '$price')&quote; or die(&quote;Error in query: &quote;.sqlite_error_string(sqlite_last_error($handle)));
 
}
echo &quote;Record added.&quote;;

}
echo &quote;Returning to main.&quote;mp;quote;);

$db = "c:/server/sqlite/selection.db";
$handle = sqlite_open($db) or die("Could not open database");
$query  = "";

if (isset($_GET["tableName"])) {
$table = sqlite_escape_string($_GET["tableName"]);

	if (!empty($_POST['title'])
	 && !empty($_POST['info_dk'])
	 && !empty($_POST['info_uk'])
	 && !empty($_POST['land'])
	 && !empty($_POST['vol'])
         && !empty($_POST['size'])
	 && !empty($_POST['price'])) {

$id = md5(mktime());
$title	= sqlite_escape_string($_POST['title']);
$info_dk = sqlite_escape_string($_POST['info_dk']);
$info_uk = sqlite_escape_string($_POST['info_uk']);
$land = sqlite_escape_string($_POST['land']);
$vol = sqlite_escape_string($_POST['vol']);
$size = sqlite_escape_string($_POST['size']);
$price = sqlite_escape_string($_POST['price']);

$query = "INSERT INTO $table (item_id, title, info_dk, info_uk, land, vol, size, price) VALUES('$id',
	      '$title',
	      '$info_dk',
	      '$info_uk',
	      '$land',
	      '$vol',
              '$size',
	      '$price')" or die("Error in query: ".sqlite_error_string(sqlite_last_error($handle)));
 
}
echo "Record added.";

}
echo "Returning to main.";
	header ("Location: ../index2.php");
  exit;
?>
there is no errors - what can be wrong?not open database");
$query = "";

if (isset($_GET["tableName"])) {
$table = sqlite_escape_string($_GET["tableName"]);

if (!empty($_POST['title'])
&& !empty($_POST['info_dk'])
&& !empty($_POST['info_uk'])
&& !empty($_POST['land'])
&& !empty($_POST['vol'])
&&amp; !empty($_POSTї'size'])
&amp;&amp; !empty($_POSTї'price'])) {

$id = md5(mktime());
$title = sqlite_escape_string($_POST['title']);
$info_dk = sqlite_escape_string($_POST['info_dk']);
$info_uk = sqlite_escape_string($_POST['info_uk']);
$land = sqlite_escape_string($_POST['land']);
$vol = sqlite_escape_string($_POST['vol']);
$size = sqlite_escape_string($_POST['size']);
$price = sqlite_escape_string($_POST['price']);

$query = "INSERT INTO $table (item_id, title, info_dk, info_uk, land, vol, size, pr
my insert.php:

Code: Select all

<?php
	function errHandler($errno, $errstr, $errfile, $errline) {
		echo "Error: <b>[$errno at line $errline] $errstr</b><br />\n";
	}

	set_error_handler("errHandler");

$db = "c:/server/sqlite/selection.db";
$handle = sqlite_open($db) or die("Could not open database&quote;);
$query  = &quote;&quote;;

if (isset($_GET&#1111;&quote;tableName"])) {
$table = sqlite_escape_string($_GET["tableName"]);

	if (!empty($_POST['title'])
	 && !empty($_POST&#1111;'info_dk'])
	 &amp;&amp; !empty($_POST&#1111;'info_uk'])
	 &amp;&amp; !empty($_POST&#1111;'land'])
	 &amp;&amp; !empty($_POST&#1111;'vol'])
         &amp;&amp; !empty($_POST&#1111;'size'])
	 &amp;&amp; !empty($_POST&#1111;'price'])) {

$id = md5(mktime());
$title	= sqlite_escape_string($_POST&#1111;'title']);
$info_dk = sqlite_escape_string($_POST&#1111;'info_dk']);
$info_uk = sqlite_escape_string($_POST&#1111;'info_uk']);
$land = sqlite_escap
that it doesent insert the item into the table

my insert.php:

Code: Select all

&lt;?php
	function errHandler($errno, $errstr, $errfile, $errline) {
		echo "Error: <b>[$errno at line $errline] $errstr</b><br />\n";
	}

	set_error_handler("errHandler");

$db = "c:/server/sqlite/selection.db";
$handle = sqlite_open($db) or die("Could not open database");
$query  = "";

if (isset($_GET["tableName"])) {
$table = sqlite_escape_string($_GET["tableName"]);

	if (!empty($_POST['title'])
	 && !empty($_POST['info_dk'])
	 && !empty($_POST['info_uk'])
	 && !empty($_POST&#1111;'land'])
	 &amp;&amp; !empty($_POST&#1111;'vol'])
         &amp;&amp; !empty($_POST&#1111;'size'])
	 &amp;&amp; !empty($_POST&#1111;'price'])) {

$id = md5(mktime());
$title	= sqlite_escape_string($_POST&#1111;'title']);
$info_dk = sqlite_escape_string($_POST&#1111;'info_dk']);
$info_uk = sqlite_escape_string($_POST&#1111;'info_uk']);
$land = sqlite_errHandler($errno, $errstr, $errfile, $errline) {
		echo "Error: <b>[$errno at line $errline] $errstr</b>&lt;br /&gt;\n&quote;;
	}

	set_error_handler(&quote;errHandler&quote;);

$db = &quote;c:/server/sqlite/selection.db&quote;;
$handle = sqlite_open($db) or die(&quote;Could not open database&quote;);
$query  = &quote;&quote;;

if (isset($_GET&#1111;&quote;tableName&quote;])) {
$table = sqlite_escape_string($_GET&#1111;&quote;tableName&quote;]);

	if (!empty($_POST&#1111;'title'])
	 &amp;&amp; !empty($_POST&#1111;'info_dk'])
	 &amp;&amp; !empty($_POST&#1111;'info_uk'])
	 &amp;&amp; !empty($_POST&#1111;'land'])
	 &amp;&amp; !empty($_POST&#1111;'vol'])
         &amp;&amp; !empty($_POST&#1111;'size'])
	 &amp;&amp; !empty($_POST&#1111;'price'])) {

$id = md5(mktime());
$title	= sqlite_escape_string($_POST&#1111;'title']);
$info_dk = sqlite_escape_string($_POST&#1111;'info_dk']);
$info_uk = sqlite_escape_string($_POST&#1111;'info_uk']);
$land = sqlite_escape_string($_POST&#1111;'land']);
$vol = sqlite_escape_string($_POST&#1111;'vol']);
$size = sqlite_escape_string($_POST&#1111;'size']);
$price = sqlite_escape_string($_POST&#1111;'price']);

$query = &quote;INSERT INTO $table (item_id, title, info_dk, info_uk, land, vol, size, price) VALUES('$id',
	      '$title',
	      '$info_dk',
	      '$info_uk',
	      '$land',
	      '$vol',
              '$size',
	      '$price')&quote; or die(&quote;Error in query: &quote;.sqlite_error_string(sqlite_last_error($handle)));
 
}
echo &quote;Record added.&quote;;

}
echo &quote;Returning to main.&quote;;
	header (&quote;Location: ../index2.php&quote;);
  exit;
?&gt;
$errstr</b><br />\n&quote;;
}

set_error_handler(&quote;errHandler");

$db = "c:/server/sqlite/selection.db";
$handle = sqlite_open($db) or die("Could not open database");
$query = "";

if (isset($_GET["tableName"])) {
$table = sqlite_escape_string($_GET["tableName"]);

if (!empty($_POST['title'])
&amp;&amp; !empty($_POSTї'info_dk'])
&amp;&amp; !empty($_POSTї'info_uk'])
&amp;&amp; !empty($_POSTї'land'])
&amp;&amp; !empty($_POSTї'vol'])
&amp;&amp; !empty($_POSTї'size'])
&amp;&amp; !empty($_POSTї'price'])) {

$id = md5(mktime());
$title = sqlite_escape_string($_POSTї'title']);
$info_dk = sqlite_escape_string($_POSTї'info_dk']);
$info_uk = sqlite_escape_string($_POSTї'info_uk']);
$land = sqlite_escape_string($_POSTї'land']);
$vol = sqlite_escape_string($_POSTї'vol']);
$size = sqlite_escape_string($_POSTї'size']);
$price = sqlite_escape_string($_POSTї'price']);

$query = &quote;INSERT INTO $table (item_id, title, info_dk, info_uk, land, vol, size, price) VALUES('$id',
'$title',
'$info_dk',
'$info_uk',
'$land',
'$vol',
'$size',
'$price')&quote; or die(&quote;Error in query: &quote;.sqlite_error_string(sqlite_last_error($handle)));

}
echo &quote;Record added.&quote;;

}
echo &quote;Returning to main.&quote;;
header (&quote;Location: ../index2.php&_escape_string($_GET["tableName"]);

if (!empty($_POST['title'])
&& !empty($_POST['info_dk'])
&&amp; !empty($_POSTї'info_uk'])
&amp;&amp; !empty($_POSTї'land'])
&amp;&amp; !empty($_POSTї'vol'])
&amp;&amp; !empty($_POSTї'size'])
&amp;&amp; !empty($_POSTї'price'])) {

$id = md5(mktime());
$title = sqlite_escape_string($_POSTї'title']);
$info_dk = sqlite_escape_string($_POSTї'info_dk']);
$info_uk = sqlite_escape_string($_POSTї'info_uk']);
$land = sqlite_escape_string($_POSTї'land']);
$vol = sqlite_escape_string($_POSTї'vol']);
$size = sqlite_escape_string($_POSTї'size']);
$price = sqlite_escape_string($_POSTї'price']);

$query = &quote;INSERT INTO $table (item_id, titlt;<br />\n";
}

set_error_handler("errHandler");

$db = "c:/server/sqlite/selection.db";
$handle = sqlite_open($db) or die(&quote;Could not open database&quote;);
$query = &quote;&quote;;

if (isset($_GETї&quote;tableName&quote;])) {
$table = sqlite_escape_string($_GETї&quote;tableName&quote;]);

if (!empty($_POSTї'title'])
&amp;&amp; !empty($_POSTї'info_dk'])
&amp;&amp; !empty($_POSTї'info_uk'])
&amp;&amp; !empty($_POSTї'land'])
&amp;&amp; !empty($_POSTї'vol'])
&amp;&amp; !empty($_POSTї'size'])
&amp;&amp; !empty($_POSTї'price'])) {

$id = md5(mktime());
$title = sqlite_escape_string($_POSTї'title']);
$info_dk = sqlite_escape_string($_POSTї'info_dk']);
$info_uk = sqlite_escape_string($_POSTї'info_uk']);
$land = sqlite_escape_string($_POSTї'land']);
$vol = sqlite_escape_string($_POSTї'vol']);
$size = sqlite_escape_string($_POSTї'size']);
$price = sqlite_escape_string($_POSTї'price']);

$query = &quote;INSERT INTO $table (item_id, title, info_dk, info_uk, land, vol, size, price) VALUES('$id',
'$title',
'$info_dept
that it doesent insert the item into the table

my insert.php:

Code: Select all

<?php
	function errHandler($errno, $errstr, $errfile, $errline) {
		echo "Error: <b>[$errno at line $errline] $errstr</b><br />\n";
	}

	set_error_handler("errHandler");

$db = "c:/server/sqlite/selection.db";
$handle = sqlite_open($db) or die("Could not open database");
$query  = "";

if (isset($_GET["tableName"])) {
$table = sqlite_escape_string($_GET["tableName"]);

	if (!empty($_POST['title'])
	 && !empty($_POST['info_dk'])
	 && !empty($_POST['info_uk'])
	 && !empty($_POST['land'])
	 && !empty($_POST['vol'])
         && !empty($_POST['size'])
	 && !empty($_POST['price'])) {

$id = md5(mktime());
$title	= sqlite_escape_string($_POST['title']);
$info_dk = sqlite_escape_string($_POST['info_dk']);
$info_uk = sqlite_escape_string($_POST['info_uk']);
$land = sqlite_escape_string($_POST['land']);
$vol = sqlite_escape_string($_POST['vol']);
$size = sqlite_escape_string($_POST['size']);
$price = sqlite_escape_string($_POST['price']);

$query = "INSERT INTO $table (item_id, title, info_dk, info_uk, land, vol, size, price) VALUES('$id',
	      '$title',
	      '$info_dk',
	      '$info_uk',
	      '$land',
	      '$vol',
              '$size',
	      '$price')" or die("Error in query: ".sqlite_error_string(sqlite_last_error($handle)));
 
}
echo "Record added.";

}
echo "R;amp;lt;b>[$errno at line $errline] $errstr</b><br />\n";
	}

	set_error_handler("errHandler");

$db = "c:/server/sqlite/selection.db";
$handle = sqlite_open($db) or die("Could not open database");
$query  = "";

if (isset($_GET["tableName"])) {
$table = sqlite_escape_string($_GET["tableName"]);

	if (!empty($_POST['title'])
	 && !empty($_POST['info_dk'])
	 && !empty($_POST['info_uk'])
	 && !empty($_POST['land'])
	 && !empty($_POST['vol'])
         && !empty($_POST['size'])
	 && !empty($_POST['price'])) {

$id = md5(mktime());
$title	= sqlite_escape_string($_POST['title']);
$info_dk = sqlite_escape_string($_POST['info_dk']);
$info_uk = sqlite_escape_string($_POST['info_uk']);
$land = sqlite_escape_string($_POST['land']);
$vol = sqlite_escape_string($_POST['vol']);
$size = sqlite_escape_string($_POST['size']);
$price = sqlite_escape_string($_POST['price']);

$query = "INSERT INTO $table (item_id, title, info_dk, info_uk, land, vol, size, price) VALUES('$id',
	      '$title',
	      '$info_dk',
	      '$info_uk',
	      '$land',
	      '$vol',
              '$size',
	      '$price')" or die("Error in query: ".sqlite_error_string(sqlite_last_error($handle)));
 
o "Error: <b>[$errno at line $errline] $errstr</b><br />\n";
	}

	set_error_handler("errHandler");

$db = "c:/server/sqlite/selection.db";
$handle = sqlite_open($db) or die("Could not open database");
$query  = "";

if (isset($_GET["tableName"])) {
$table = sqlite_escape_string($_GET["tableName"]);

	if (!empty($_POST['title'])
	 && !empty($_POST['info_dk'])
	 && !empty($_POST['info_uk'])
	 && !empty($_POST['land'])
	 && !empty($_POST['vol'])
         && !empty($_POST['size'])
	 && !empty($_POST['price'])) {

$id = md5(mktime());
$title	= sqlite_escape_string($_POST['title']);
$info_dk = sqlite_escape_string($_POST['info_dk']);
$info_uk = sqlite_escape_string($_POST['info_uk']);
$land = sqlite_escape_string($_POST['land']);
$vol = sqlite_escape_string($_POST['vol']);
$size = sqlite_escape_string($_POST['size']);
$price = sqlite_escape_string($_POST['price']);

$query = "INSERT INTO $table (item_id, title, info_dk, info_uk, land, vol, size, price) VALUES('$id',
	      '$title',
	      '$info_dk',
	      '$info_uk',
	      '$land',
	      '$vol',
              '$size',
	      '$price')" or die("Error in query: ".sqlite_error_string(sqlite_last_error($handle)));
 
}
echo "Record added.";

}
echo "Returning to main.";
	header ("Locati"tableName"]);

	if (!empty($_POST['title'])
	 && !empty($_POST['info_dk'])
	 && !empty($_POST['info_uk'])
	 && !empty($_POST['land'])
	 && !empty($_POST['vol'])
         && !empty($_POST['size'])
	 && !empty($_POST['price'])) {

$id = md5(mktime());
$title	= sqlite_escape_string($_POST['title']);
$info_dk = sqlite_escape_string($_POST['info_dk']);
$info_uk = sqlite_escape_string($_POST['info_uk']);
$land = sqlite_escape_string($_POST['land']);
$vol = sqlite_escape_string($_POST['vol']);
$size = sqlite_escape_ery  = "";

if (isset($_GET["tableName"])) {
$table = sqlite_escape_string($_GET["tableName"]);

	if (!empty($_POST['title'])
	 && !empty($_POST['info_dk'])
	 && !empty($_POST['info_uk'])
	 && !empty($_POST['land'])
	 && !empty($_POST['vol'])
         && !empty($_POST['size'])
	 && !empty($_POST['price'])) {

$id = md5(mktime());
$title	= sqlite_escape_string($_POST['title']);
$info_dk = sqlite_escape_string($_POST['info_dk']);
$info_uk = sqlite_escape_string($_POST['info_uk']);
$land = sqlite_escape_string($_POST['land']);
$vol = sqlite_escape_string($_POST['vol']);
$size = sqlite_escape_string($_POST['size']);
$price = sqlite_escape_string($_POST['price']);

$query = "INSERT INTO $table (item_id, title, info_dk, info_uk, land, vol, size, price) VALUES('$id',
	      '$title',
	      '$info_dk',
	      '$info_uk',
	      '$land',
	      '$vol',
              '$size',
	      '$price')" or die("Error in query: ".sqlite_error_string(sqlite_last_error($handle)));
 
}
echo "Record added.";

}
echo "Returning to main.";
	header ("Location: ../index2.php");
  exit;
?>
[/php:1:06d0de6
	function errHandler($errno, $errstr, $errfile, $errline) {
		echo &quote;Error: &lt;b&gt;&#1111;$errno at line $errline] $errstr&lt;/b&gt;&lt;br /&gt;\n&quote;;
	}

	set_error_handler(&quote;errHandler&quote;);

$db = &quote;c:/server/sqlite/selection.db&quote;;
$handle = sqlite_open($db) or die(&quote;Could not open database&quote;);
$query  = &quote;&quote;;

if (isset($_GET&#1111;&quote;tableName&quote;])) {
$table = sqlite_escape_string($_GET&#1111;&quote;tableName&quote;]);

	if (!empty($_POST&#1111;'title'])
	 &amp;&amp; !empty($_POST&#1111;'info_dk'])
	 &amp;&amp; !empty($_POST&#1111;'info_uk'])
	 &amp;&amp; !empty($_POST&#1111;'land'])
	 &amp;&amp; !empty($_POST&#1111;'vol'])
         &amp;&amp; !empty($_POST&#1111;'size'])
	 &amp;&amp; !empty($_POST&#1111;'price'])) {

$id = md5(mktime());
$title	= sqlite_escape_string($_POST&#1111;'title']);
$info_dk = sqlite_escape_string($_POST&#1111;'info_dk']);
$info_uk = sqlite_escape_string($_POST&#1111;'info_uk']);
$land = sqlite_escape_string($_POST&#1111;'land']);
$vol = sqlite_escape_string($_POST&#1111;'vol']);
$size = sqlite_escape_string($_POST&#1111;'size']);
$price = sqlite_escape_string($_POST&#1111;'price']);

$query = &quote;INSERT INTO $table (item_id, title, info_dk, info_uk, land, vol, size, price) VALUES('$id',
	      '$title',
	      '$info_dk',
	      '$info_uk',
	      '$land',
	      '$vol',
              '$size',
	      '$price')&quote; or die(&quote;Error in query: &quote;.sqlite_error_string(sqlite_last_error($handle)));
 
}
echo &quote;Record added.&qurns as it should, except 
that it doesent insert the item into the table

my insert.php:

Code: Select all

&lt;?php
	function errHandler($errno, $errstr, $errfile, $errline) {
		echo &quote;Error: &lt;b&gt;[$errno at line $errline] $errstr</b><br />\n";
	}

	set_error_handler("errHandler");

$db = "c:/server/sqlite/selection.db";
$handle = sqlite_open($db) or die("Could not open database");
$query  = "";

if (isset($_GET["tableName"])) {
$table = sqlite_escape_string($_GET["tableName"]);

	if (!empty($_POST['title'])
	 && !empty($_POST['info_dk'])
	 && !empty($_POST['info_uk'])
	 && !empty($_POST['land'])
	 && !empty($_POST['vol'])
         && !empty($_POST['size'])
	 && !empty($_POST['price'])) {

$id = md5(mktime());
$title	= sqlite_escape_string($_POST&#1111;'title']);: <b>[$errno at line $errline] $errstr</b><br />\n";
	}

	set_error_handler("errHandler");

$db = "c:/server/sqlite/selection.db";
$handle = sqlite_open($db) or die("Could not open database");
$query  = "";

if (isset($_GET["tableName"])) {
$table = sqlite_escape_string($_GET["tableName"]);

	if (!empty($_POST['title'])
	 && !empty($_POST['info_dk'])
	 &&amp; !empty($_POST&#1111;'info_uk'])
	 &amp;&amp; !empty($_POST&#1111;'land'])
	 &amp;&amp; !empty($_POST&#1111;'vol'])
         &amp;&amp; !empty($_POST&#1111;'size'])
	 &amp;&amp; !empty($_POST&#1111;'price'])) {

$id = md5(mktime());
$title	= sqlite_escape_string($_POST&#1111;'title']);
$info_dk = sqlite_escape_string($_POST&#1111;'info_dk']);
$info_uk = sqlite_escape_string($_POST&#111
that it doesent insert the item into the table

my insert.php:

Code: Select all

<?php
	function errHandler($errno, $errstr, $errfile, $errline) {
		echo &quote;Error: &lt;b&gt;&#1111;$errno at line $errline] $errstr&lt;/b><br />\n";
	}

	set_error_handler("errHandler");

$db = "c:/server/sqlite/selection.db";
$handle = sqlite_open($db) or die("Could not open database");
$query  = "";

if (isset($_GET["tableName"])) {
$table = sqlite_escape_string($_GET["tableName"]);

	if (!empty($_POST['title'])
	 && !empty($_POST['info_dk'])
	 && !empty($_POST['info_uk'])
	 && !empty($_POST['land'])
	 && !empty($_POST['vol'])
         && !empty($_POST['size'])
	 && !empty($_POST['price'])) {

$id = md5ept 
that it doesent insert the item into the table

my insert.php:

Code: Select all

&lt;?php
	function errHandler($errno, $errstr, $errfile, $errline) {
		echo &quote;Error: &lt;b&gt;&#1111;$errno at line $errline] $errstr&lt;/b&gt;&lt;br /&gt;\n&quote;;
	}

	set_error_handler(&quote;errHandler&quote;);

$db = &quote;c:/server/sqlite/selection.db&quote;;
$handle = sqlite_open($db) or die("Could not open database");
$query  = "&quote;;

if (isset($_GET&#1111;&quote;tableName&quote;])) {
$table = sqlite_escape_string($_GET&#1111;&quote;tableName&quote;]);

	if (!empty($_POST&#1111;'title'])
	 &amp;&amp; !empty($_POST&#1111;'info_dk'])
	 &amp;&amp; !empty($_POST&#1111;'info_uk'])
	 &amp;&amp; !empty($_POST&#1111;'land'])
	 &amp;&amp; !empty($_POST&#1111;'vol'])
         &amp;&amp; !empty($_POST&#1111;'size'])
	 &amp;&amp; !empty($_POST&#1111;'price'])) {

$id = md5(mktime());
$title	= sqlite_escape_string($_POST&#1111;'title']);
$info_dk = sqlite_escape_string($_POST&#1111;'info_dk']);
$info_uk = sqlite_escape_string($_POST&#1111;'info_uk']);
$land = sqlite_escape_string($_POST&#1111;'land']);
$vol = sqlite_escape_string($_POST&#1111;'vol']);
$size = sqlite_escape_string($_POST&#1111;'size']);
$price = sqlite_escape_string($_POST&#1111;'price']);

$query = &quturns as it should, except 
that it doesent insert the item into the table

my insert.php:

Code: Select all

&lt;?php
	function errHandler($errno, $errstr, $errfile, $errline) {
		echo &quote;Error: &lt;b>[$errno at line $errline] $errstr</b><br />\n";
	}

	set_error_handler("errHandler");

$db = "c:/server/sqlite/selection.db";
$handle = sqlite_open($db) or die("Could not open database");
$query  = "";

if (isset($_GET["tableName"])) {
$table = sqlite_escape_string($_GET["tableName"]);

	if (!empty($_POST['title'])
	 && !empty($_POST['info_dk'])
	 && !empty($_POST['info_uk'])
	 && !empty($_POST['land'])
	 && !empty($_POST['vol'])
         &amp;&amp; !empty($_POST&#1111;'size'])
	 &amp;& !empty($_POST['price'])) {

$id = md5(mktime());
$title	= sqlite_escape_string($_POST['title']);
$info_dk = sqlite_escape_string($_POST['info_dk']);
$info_uk = sqlite_escape_string($_POST['info_uk']);
$land = sqlite_escape_string($_POST['land']);
$vol = sqlite_escape_string($_POST['vol']);
$size = sqlite_escape_string($_POST['size']);
$price = sqlite_escape_string($_POST['price']);

$query = "INSERT INTO $table (item_id, title, info_dk, info_uk, land, vol, size, price) VALUES('$id',
	      '$title',
	      '$info_dk',
	      '$info_uk',
	      '$land',
	      '$vol',
              '$size',
	      '$price')" or die("Error in query: ".sqlite_error_string(sqlite_last_error($handle)));
<?php
	function errHandler($errno, $errstr, $errfile, $errline) {
		echo &quote;Error: &lt;b&gt;&#1111;$errno at line $errline] $errstr</b&gt;&lt;br /&gt;\n&quote;;
	}

	set_error_handler(&quote;errHandler&quote;);

$db = &quote;c:/server/sqlite/selection.db&quote;;
$handle = sqlite_open($db) or die(&quote;Could not open database&quote;);
$query  = &quote;&quote;;

if (isset($_GET&#1111;&quote;tableName&quote;])) {
$table = sqlite_escape_string($_GET&#1111;&quote;tableName&quote;]);

	if (!empty($_POST&#1111;'title'])
	 &amp;&amp; !empty($_POST&#1111;'info_dk'])
	 &amp;&amp; !empty($_POST&#1111;'info_uk'])
	 &amp;&amp; !empty($_POST&#1111;'land'])
	 &amp;&amp; !empty($_POST&#1111;'vol'])
         &amp;&amp; !empty($_POST&#1111;'size'])
	 &amp;&amp; !empty($_POST&#1111;'price'])) {

$id = md5(mktime());
$title	= sqlite_escape_string($_POST&#1111;'title']);
$info_dk = sqlite_escape_string($_POST&#1111;'info_dk']);
$info_uk = sqlite_escape_string($_POST&#1111;'info_uk']);
$land = sqlite_escape_string($_POST&#1111;'land']);
$vol = sqlite_escape_string($_POST&#1111;'vol']);
$size = sqlite_escape_string($_POST&#1111;'size']);
$price = sqlite_escape_string($_POST&#1111;'price']);

$query = &quote;INSERT INTO $table (item_id, title, info_dk, info_uk, land, vol, size, price) VALUES('$id',
	      '$title',
	      '$info_dk',
	      '$info_uk',
	      '$land',
	      '$vol',
              '$size',
	      '$price')&quote; or die(&quote;Error in query: &ampitem it returns as it should, except 
that it doesent insert the item into the table

my insert.php:

Code: Select all

<?php
	function errHandler($errno, $errstr, $errfile, $errline) {
		echo &quote;Error: &lt;b&gt;&#1111;$errno at line $errline] $errstr&lt;/b&gt;&lt;br /&gt;\n&quote;;
	}

	set_error_handler(&quote;errHandler&quote;);

$db = &quote;c:/server/sqlite/selection.db&quote;;
$handle = sqlite_open($db) or die(&quote;Could not open database&quote;);
$query  = &quote;&quote;;

if (isset($_GET&#1111;&quote;tableName&quote;])) {
$table = sqlite_escape_string($_GET&#1111;&quote;tableName&quote;]);

	if (!empty($_POST&#1111;'title'])
	 &amp;&amp; !empty($_POST&#1111;'info_dk'])
	 &amp;&amp; !empty($_POST&#1111;'info_uk'])
	 &amp;&amp; !empty($_POST&#1111;'land'])
	 &amp;&amp; !empty($_POST&#1111;'vol'])
         &amp;&amp; !empty($_POST&#1111;'size'])
	 &amp;&amp; !empty($_POST&#1111;'price'])) {

$id = md5(mktime());
$title	= sqlite_escape_string($_POST&#1111;'title']);
$info_dk = sqlite_escape_string($_POST&#1111;'info_dk']);
$info_uk = sqlite_escape_string($_POST&#1111;'info_uk']);
$land = sqlite_escape_string($_POST&#1111;'land']);
$vol = sqlite_escape_string($_POST&#1111;'vol']);
$size = sqlite_escape_string($_POST&#1111;'size']);
$price = sqlite_escape_string($_POST&#1111;'price']);

$query = &quote;INSERT INTO $table (item_id, title, info_dk, info_uk, land, vol, size, price) VALUES('$id',
	      '$title',
	      '$info_dk',
	      '$info_uk',
	      '$land',
	      '$vol',
              '$size',
	      '$price')&quote; or die(&quote;Error in query: &quote;.sqlite_error_string(sqlite_last_error($handle)));
 
}
echo &quote;Record added.&quote;;

}
echo &quote;Returning to main.&quote;;
	header (&quote;Location: ../index2.php&amhat it doesent insert the item into the table

my insert.php:

Code: Select all

<?php
	function errHandler($errno, $errstr, $errfile, $errline) {
		echo "Error: <b>[$errno at line $errline] $errstr</b><br />\n";
	}

	set_error_handler(&quote;errHandler&quote;);

$db = &quote;c:/server/sqlite/selection.db&quote;;
$handle = sqlite_open($db) or die(&quote;Could not open database&quote;);
$query  = &quote;&quote;;

if (isset($_GET&#1111;&quote;tableName&quote;])) {
$table = sqlite_escape_string($_GET&#1111;&quote;tableName&quote;]);

	if (!empty($_POST&#1111;'title'])
	 &amp;&amp; !empty($_POST&#1111;'info_dk'])
	 &amp;&amp; !empty($_POST&#1111;'info_uk'])
	 &amp;&amp; !empty($_POST&#1111;'land'])
	 &amp;&amp; !empty($_POST&#1111;'vol'])
         &amp;&amp; !empty($_POST&#1111;'size'])
	 &amp;&amp; !empty($_POST&#1111;'price'])) {

$id = md5(mktime());
$title	= sqlite_escape_string($_POST&#1111;'title']);
$info_dk = sqlite_escape_string($_POST&#1111;'info_dk']);
$info_uk = sqlite_escape_string($_POST&#1111;'info_uk']);
$land = sqlite_escape_string($_POST&#1111;'land']);
$vol = sqlite_escape_string($_POST&#1111;'vol']);
$size = sqlite_escape_string($_POST&#1111;'size']);
$price = sqlite_escape_string($_POST&#1111;'price']);

$query = &quote;INSERT INTO $table (item_id, title, info_dk, info_uk, land, vol, size, price) VALUES('$id',
	      '$title',
	      '$info_dk',
	      '$info_uk',
	      '$land',
	      '$vol',
              '$size',
	      '$price')&quote; or die(&quottem into the table

my insert.php:

Code: Select all

<?php
	function errHandler($errno, $errstr, $errfile, $errline) {
		echo "Error: <b>[$errno at line $errline] $errstr</b><br />\n";
	}

	set_error_handler("errHandler");

$db = "c:/server/sqlite/selection.db";
$handle = sqlite_open($db) or die("Could not open database");
$query  = "";

if (isset($_GET["tableName"])) {
$table = sqlite_escape_string($_GET["tableName"]);

	if (!empty($_POST['title'])
	 && !empty($_POST['info_dk'])
	 && !empty($_POST['info_uk'])
	 && !empty($_POST['land'])
	 && !empty($_POST['vol'])
         && !empty($_POST['size'])
	 && !empty($_POST['price'])) {

$id = md5(mktime());
$title	= sqlite_escape_string($_POST['title']);
$info_dk = sqlite_escape_string($_POST['info_dk']);
$info_uk = sqlite_escape_string($_POST['info_uk']);
$land = sqlite_escape_string($_POST['land']);
$vol = sqlite_escape_string($_POST['vol']);
$size = sqlite_escape_string($_POST['size']);
$price = sqlite_escape_string($_POST['price']);

$query = "INSERT INTO $table (item_id, title, info_dk, info_uk, land, vol, size, price) VALUES('$id',
	      '$title',
	      '$info_dk',
	      '$info_uk',
	      '$land',
	      '$vol',
              '$size',
	      '$price')" or die("Error in query: ".sqlite_error_string(sqlite_last_error($handle)));
 
}
echo "Record added.";

}
echo "Returning to main.";
	header ("Location: ../index2.php");
  exit;
?>
there is no errors - what can brrline) {
echo "Error: <b>[$errno at line $errline] $errstr</b><br />\n";
}

set_error_handler("errHandler");

$db = "c:/server/sqlite/selection.db";
$handle = sqlite_open($db) or die("Could not open database");
$query = "";

if (isset($_GET["tableName"])) {
$table = sqlite_escape_string($_GET["tableName"]);

if (!empty($_POST['title'])
&amp;&amp; !empty($_POSTї'info_dk'])
&amp;&amp; !empty($_POSTї'info_uk'])
&amp;&amp; !empty($_POSTї'land'])
&amp;& !empty($_POST['vol'])
&& !empty($_POST['size'])
&& !empty($_POST['price'])) {

$id = md5(mktime());
$title = sqlite_escape_string($_POSTї'title']);
$info_dk = sqlite_escape_string($_POSTї'info_dk']);
$info_uk = sqlite_escape_string($_POST['info_uk']);
$land = sqlite_escape_string($_POST['land']);
$vol = sqlite_escape_string($_POST['vol']);
$size = sqlite_escape_string($_POSTї'size']);
$price = sqlite_escape_string($_POSTї'price']);

$query = &quote;INSERT INTO $table (item_id, title, info_dk, info_uk, land, vol, size, price) VALUES('$id',
'$title',
'$info_dk',
'$info_uk',
'$land',
'$vol',
'$size',
'$price')" or die("Error in query: ".sqlite_error_string(sqlite_last_error($handle)));

}
echo "Record added.";

}
echo "Returning to main.";
header ("Location: ../index2.php");
exit;
?>

there is no errors - what can be wrong?a new item it returns as it should, except
that it doesent insert the item into the table

my insert.php:

Code: Select all

<?php
	function errHandler($errno, $errstr, $errfile, $errline) {
		echo "Error: <b>[$errno at line $errline] $errstr</b><br />\n";
	}

	set_error_handler("errHandler");

$db = "c:/server/sqlite/selection.db";
$handle = sqlite_open($db) or die("Could not open database");
$query  = "";

if (isset($_GET["tableName"])) {
$table = sqlite_escape_string($_GET["tableName"]);

	if (!empty($_POST['title'])
	 && !empty($_POST['info_dk'])
	 && !empty($_POST['info_uk'])
	 && !empty($_POST['land'])
	 && !empty($_POST['vol'])
         && !empty($_POST['size'])
	 && !empty($_POST['price'])) {

$id = md5(mktime());
$title	= sqlite_escape_string($_POST['title']);
$info_dk = sqlite_escape_string($_POST['info_dk']);
$info_uk = sqlite_escape_string($_POST['info_uk']);
$land = sqlite_escape_string($_POST['land']);
$vol = sqlite_escape_string($_POST['vol']);
$size = sqlite_escape_string($_POST['size']);
$price = sqlite_escape_string($_POST['price']);

$query = "INSERT INTO $table (item_id, title, info_dk, info_uk, land, vol, size, price) VALUES('$id',
	      '$title',
	      '$info_dk',
	      '$info_uk',
	      '$land',
	      '$vol',
              '$size',
	      '$price')" or die("Error in query: ".sqlite_error_string(sqlite_last_error($handle)));
 
}
echo "Record added.";

}
echo "Returning to main.";
	header ("Location: ../index2.php&quort the item into the table

my insert.php:

Code: Select all

<?php
	function errHandler($errno, $errstr, $errfile, $errline) {
		echo "Error: <b>[$errno at line $errline] $errstr</b><br />\n";
	}

	set_error_handler("errHandler");

$db = "c:/server/sqlite/selection.db";
$handle = sqlite_open($db) or die("Could not open database");
$query  = "";

if (isset($_GET["tableName"])) {
$table = sqlite_escape_string($_GET["tableName"]);

	if (!empty($_POST['title'])
	 && !empty($_POST['info_dk'])
	 && !empty($_POST['info_uk'])
	 && !empty($_POST['land'])
	 && !empty($_POST['vol'])
         && !empty($_POST['size'])
	 && !empty($_POST['price'])) {

$id = md5(mktime());
$title	= sqlite_escape_string($_POST['title']);
$info_dk = sqlite_escape_string($_POST['info_dk']);
$info_uk = sqlite_escape_string($_POST['info_uk']);
$land = sqlite_escape_string($_POST['land']);
$vol = sqlite_escape_string($_POST['vol']);
$size = sqlite_escape_string($_POST['size']);
$price = sqlite_escape_string($_POST['price']);

$query = "INSERT INTO $table (item_id, title, info_dk, info_uk, land, vol, size, price) VALUES('$id',
	      '$title',
	      '$info_dk',
	      '$info_uk',
	      '$land',
	      '$vol',
              '$size',
	      '$price')" or die("Error in query: ".sqlite_error_string(sqlite_last_error($handle)));
 
}
echo "Record added.";

}
echo "Returning to main.";
	header ("Location: ../index2.php");
  exit;
?>
there is no errors - what can be wrong?a new item it returns as it should, except
that it doesent insert the item into the table

my insert.php:

Code: Select all

<?php
	function errHandler($errno, $errstr, $errfile, $errline) {
		echo "Error: <b>[$errno at line $errline] $errstr</b><br />\n";
	}

	set_error_handler("errHandler");

$db = "c:/server/sqlite/selection.db";
$handle = sqlite_open($db) or die("Could not open database");
$query  = "";

if (isset($_GET["tableName"])) {
$table = sqlite_escape_string($_GET["tableName"]);

	if (!empty($_POST['title'])
	 && !empty($_POST['info_dk'])
	 && !empty($_POST['info_uk'])
	 && !empty($_POST['land'])
	 && !empty($_POST['vol'])
         && !empty($_POST['size'])
	 && !empty($_POST['price'])) {

$id = md5(mktime());
$title	= sqlite_escape_string($_POST['title']);
$info_dk = sqlite_escape_string($_POST['info_dk']);
$info_uk = sqlite_escape_string($_POST['info_uk']);
$land = sqlite_escape_string($_POST['land']);
$vol = sqlite_escape_string($_POST['vol']);
$size = sqlite_escape_string($_POST['size']);
$price = sqlite_escape_string($_POST['price']);

$query = "INSERT INTO $table (item_id, title, info_dk, info_uk, land, vol, size, price) VALUES('$id',
	      '$title',
	      '$info_dk',
	      '$info_uk',
	      '$land',
	      '$vol',
              '$size',
	      '$price')" or die("Error in query: ".sqlite_error_string(sqlite_last_error($handle)));
 
}
echo "Record added.";

}
echo "Returning to main.";
	header ("Location: ../index2.php");
  exit;
?>
[/php:1:06d0dethe table

my insert.php:

Code: Select all

<?php
	function errHandler($errno, $errstr, $errfile, $errline) {
		echo "Error: <b>[$errno at line $errline] $errstr</b><br /&gt;\n&quote;;
	}

	set_error_handler(&quote;errHandler&quote;);

$db = &quote;c:/server/sqlite/selection.db&quote;;
$handle = sqlite_open($db) or die(&quote;Could not open database&quote;);
$query  = &quote;&quote;;

if (isset($_GET&#1111;&quote;tableName&quote;])) {
$table = sqlite_escape_string($_GET&#1111;&quote;tableName&quote;]);

	if (!empty($_POST&#1111;'title'])
	 &amp;&amp; !empty($_POST&#1111;'info_dk'])
	 &amp;&amp; !empty($_POST&#1111;'info_uk'])
	 &amp;&amp; !empty($_POST&#1111;'land'])
	 &amp;&amp; !empty($_POST&#1111;'vol'])
         &amp;&amp; !empty($_POST&#1111;'size'])
	 &amp;&amp; !empty($_POST&#1111;'price'])) {

$id = md5(mktime());
$title	= sqlite_escape_string($_POST&#1111;'title']);
$info_dk = sqlite_escape_string($_POST&#1111;'info_dk']);
$info_uk = sqlite_escape_string($_POST&#1111;'info_uk']);
$land = sqlite_escape_string($_POST&#1111;'land']);
$vol = sqlite_escape_string($_POST&#1111;'vol']);
$size = sqlite_escape_string($_POST&#1111;'size']);
$price = sqlite_escape_string($_POST&#1111;'price']);

$query = &quote;INSERT INTO $table (item_id, title, info_dk, info_uk, land, vol, size, price) VALUES('$id',
	      '$title',
	      '$info_dk',
	      '$info_uk',
	      '$land',
	      '$vol',
              '$size',
	      '$price')&quote; or die(&quote;Error in query: &quote;.sqlite_error_string(sqlite_last_error($handle)));
 
}
echo &quote;Record added.&quote;;

}
echo &quote;Returning to main.&quote;;
	header (&ane) {
		echo "Error: <b>[$errno at line $errline] $errstr</b><br />\n";
	}

	set_error_handler("errHandler");

$db = "c:/server/sqlite/selection.db";
$handle = sqlite_open($db) or die("Could not open database");
$query  = "";

if (isset($_GET["tableName"])) {
$table = sqlite_escape_string($_GET["tableName"]);

	if (!empty($_POST['title'])
	 && !empty($_POST['info_dk'])
	 && !empty($_POST['info_uk'])
	 && !empty($_POST['land'])
	 && !empty($_POST['vol'])
         && !empty($_POST['size'])
	 && !empty($_POST['price'])) {

$id = md5(mktime());
$title	= sqlite_escape_string($_POST&#1111;'title']);
$info_dk = sqlite_escapline] $errstr</b><br />\n";
	}

	set_error_handler("errHandler");

$db = "c:/server/sqlite/selection.db";
$handle = sqlite_open($db) or die("Could not open database");
$query  = "";

if (isset($_GET["tableName"])) {
$table = sqlite_escape_string($_GET["tableName"]);

	if (!empty($_POST['title'])
	 && !empty($_POST['info_dk'])
	 && !empty($_POST['info_uk'])
	 && !empty($_POST['land'])
	 && !empty($_POST['vol'])
         && !empty($_POST['size'])
	 && !empty($_POST['price'])) {

$id = md5(mktime());
$title	= sqlite_escape_string($_POST['title']);
$info_dk = sqlite_escape_string($_POST['info_dk']);
$info_uk = sqlite_escape_string($_POST['info_uk']);
$land = sqlite_escape_string($_POST['land']);
$vol = sqlite_escape_string($_POST['vol']);
$size = sqlite_escape_string($_POST['size']);
$price = sqlite_escape_string($_POST['price']);

$query = "INSERT INTO $table (item_id, title, info_dk, info_uk, land, vol, size, price) VALUES('$id',
	      '$title',
	      '$info_dk',
	      '$info_uk',
	      '$land',
	      '$vol',
              '$size',
	      '$price')" or die("Error in query: ".sqlite_error_string(sqlite_last_error($handle)));
 
}
echo "Record added.";

}
echo "Returning to main.";
	header ("Location: ../index2.php");
  exit;
?>
there is no errors - what can be wrong?e/selection.db";
$handle = sqlite_open($db) or die("Could not open database");
$query = "";

if (isset($_GETї&quote;tableName&quote;])) {
$table = sqlite_escape_string($_GETї&quote;tableName&quote;]);

if (!empty($_POSTї'title'])
&amp;&amp; !empty($_POSTї'info_dk'])
&amp;&amp; !empty($_POSTї'info_uk'])
&amp;&amp; !empty($_POSTї'land'])
&amp;&amp; !empty($_POSTї'vol'])
&amp;&amp; !empty($_POSTї'size'])
&amp;&amp; !empty($_POSTї'price'])) {

$id = md5(mktime());
$title = sqlite_escape_string($_POSTї'title']);
$info_dk = sqlite_escape_string($_POSTї'info_dk']);
$info_uk = sqlite_escape_string($_POSTї'info_uk']);
$land = sqlite_escape_string($_POSTї'land']);
$vol = sqlite_escape_string($_POSTї'vol']);
$size = sqlite_escape_string($_POSTї'size']);
$price = sqlite_escape_string($_POSTї'price']);

$query = &quote;INSERT INTOent insert the item into the table

my insert.php:

Code: Select all

<?php
	function errHandler($errno, $errstr, $errfile, $errline) {
		echo "Error: <b>[$errno at line $errline] $errstr</b><br />\n";
	}

	set_error_handler("errHandler");

$db = "c:/server/sqlite/selection.db";
$handle = sqlite_open($db) or die("Could not open database");
$query  = "";

if (isset($_GET["tableName"])) {
$table = sqlite_escape_string($_GET["tableName"]);

	if (!empty($_POST['title'])
	 && !empty($_POST['info_dk'])
	 && !empty($_POST['info_uk'])
	 && !empty($_POST['land'])
	 && !empty($_POST['vol'])
         && !empty($_POST['size'])
	 && !empty($_POST['price'])) {

$id = md5(mktime());
$title	= sqlite_escape_string($_POST['title']);
$info_dk = sqlite_escape_string($_POST['info_dk']);
$info_uk = sqlite_escape_string($_POST['info_uk']);
$land = sqlite_escape_string($_POST['land']);
$vol = sqlite_escape_string($_POST['vol']);
$size = sqlite_escape_string($_POST['size']);
$price = sqlite_escape_string($_POST['price']);

$query = "INSERT INTO $table (item_id, title, info_dk, info_uk, land, vol, size, price) VALUES('$id',
	      '$title',
	      '$info_dk',
	      '$info_uk',
	      '$land',
	      '$vol',
              '$size',
	      '$price')" or die("Error in query: &amp
<?php
	function errHandler($errno, $errstr, $errfile, $errline) {
		echo "Error: <b>[$errno at line $errline] $errstr</b><br />\n";
	}

	set_error_handler("errHandler");

$db = "c:/server/sqlite/selection.db";
$handle = sqlite_open($db) or die("Could not open database");
$query  = "";

if (isset($_GET["tableName"])) {
$table = sqlite_escape_string($_GET["tableName"]);

	if (!empty($_POST['title'])
	 && !empty($_POST['info_dk'])
	 && !empty($_POST['info_uk'])
	 && !empty($_POST['land'])
	 && !empty($_POST['vol'])
         && !empty($_POST['size'])
	 && !empty($_POST['price'])) {

$id = md5(mktime());
$title	= sqlite_escape_string($_POST['title']);
$info_dk = sqlite_escape_string($_POST['info_dk']);
$info_uk = sqlite_escape_string($_POST['info_uk']);
$land = sqlite_escape_string($_POST['land']);
$vol = sqlite_escape_string($_POST['vol']);
$size = sqlite_escape_string($_POST['size']);
$price = sqlite_escape_string($_POST['price']);

$query = "INSERT INTO $table (item_id, title, info_dk, info_uk, land, vol, size, price) VALUES('$id',
	      '$title',
	      '$info_dk',
	      '$info_uk',
	      '$land',
	      '$vol',
              '$size',
	      '$price')" or die("Error in query: ".sqlite_error_string(sqlite_last_error($handle)));
 
}
echo "Record added.";

}
echo "Returning to main.";
	header ("Location: ../index2.php");
  exit;
?>
there is no errors - what can be wrong?
Last edited by nexus6 on Sat Jul 09, 2005 1:26 am, edited 1 time in total.
User avatar
delorian
Forum Contributor
Posts: 223
Joined: Sun May 04, 2003 5:20 pm
Location: Olsztyn, Poland

Post by delorian »

As far as I can see you do not execute a query on the database.
User avatar
nexus6
Forum Newbie
Posts: 20
Joined: Fri Jun 17, 2005 3:50 am
Location: Denmark

Post by nexus6 »

okay :) i will
Post Reply