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;
?>}
set_error_handler("errHandler"e;);
$db = "e;c:/server/sqlite/selection.db"e;;
$handle = sqlite_open($db) or die("e;Could not open database"e;);
$query = "e;"e;;
if (isset($_GETї"e;tableName"e;])) {
$table = sqlite_escape_string($_GETї"e;tableName"e;]);
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 = "e;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')"e; or die("e;Error in query: "e;.sqlite_error_string(sqlite_last_error($handle)));
}
echo "e;Record added."e;;
}
echo "e;Returning to main."e;;
header ("Location: ../index2.php"e;);
exit;
?>
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')"e; or die("e;Error in query: "e;.sqlite_error_string(sqlite_last_error($handle)));
}
echo "e;Record added."e;;
}
echo "e;Returning to main."e;;
header ("e;Location: ../index2.php"e;);
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"e;;
}
set_error_handler("e;errHandler"e;);
$db = "e;c:/server/sqlite/selection.db"e;;
$handle = sqlite_open($db) or die("e;Could not open database"e;);
$query = "e;"e;;
if (isset($_GETї"e;tableName"e;])) {
$table = sqlite_escape_string($_GETї"e;tableName"e;]);
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 = "e;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')"e; or die("e;Error in query: "e;.sqlite_error_string(sqlite_last_error($handle)));
}
echo "e;Record added."e;;
}
echo "e;Returning to main."e;;
header ("e;Location: ../index2.php"e;);
exit;
?>
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'])
&& !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 = "e;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')"e
$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($_ the item into the table
my insert.php:
Code: Select all
<?php
function errHandler($errno, $errstr, $errfile, $errline) {
echo "e;Error: <b>[$errno at line $errline] $errstr</b><br />\n"e;;
}
set_error_handler("e;errHandler"e;);
$db = "e;c:/server/sqlite/selection.db"e;;
$handle = sqlite_open($db) or die("e;Could not open database"e;);
$query = "e;"e;;
if (isset($_GETї"e;tableName"e;])) {
$table = sqlite_escape_string($_GETї"e;tableName"e;]);
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 = "e;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')"e; or die("e;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 "e;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("e;Could not open database"e;);
$query = "e;"e;;
if (isset($_GETї"e;tableName"e;])) {
$table = sqlite_escape_string($_GETї"e;tableName"e;]);
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 = "e;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')"e; or die("e;Error in query: "e;.sqlite_errecho "Error: <b>ї$errno at line $errline] $errstr</b><br />\n"e;;
}
set_error_handler("e;errHandler"e;);
$db = "e;c:/server/sqlite/selection.db"e;;
$handle = sqlite_open($db) or die("e;Could not open database"e;);
$query = "e;"e;;
if (isset($_GETї"e;tableName"e;])) {
$table = sqlite_escape_string($_GETї"e;tableName"e;]);
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 = "e;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')"e; or die("e;Error in query: "e;.sqlite_error_string(sqlite_last_error($handle)));
}
echo "e;1]
<?php
function errHandler($errno, $errstr, $errfile, $errline) {
echo "e;Error: <b>ї$errno at line $errline] $errstr</b><br />\n"e;;
}
set_error_handler("e;errHandler"e;);
$db = "e;c:/server/sqlite/selection.db"e;;
$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 = 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"e;);
$query = "e;"e;;
if (isset($_GETї"e;tableName"e;])) {
$table = sqlite_escape_string($_GETї"e;tableName"e;]);
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 = "e;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')"e; or die("e;Error in query: "e;.sqlite_error_string(sqlite_last_error($handle)));
}
echo "e;Record added."e;;
}
echo "e;Returning to main."e;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;
?>$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, 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"e;);
$query = "e;"e;;
if (isset($_GETї"e;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_escap
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_errHandler($errno, $errstr, $errfile, $errline) {
echo "Error: <b>[$errno at line $errline] $errstr</b><br />\n"e;;
}
set_error_handler("e;errHandler"e;);
$db = "e;c:/server/sqlite/selection.db"e;;
$handle = sqlite_open($db) or die("e;Could not open database"e;);
$query = "e;"e;;
if (isset($_GETї"e;tableName"e;])) {
$table = sqlite_escape_string($_GETї"e;tableName"e;]);
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 = "e;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')"e; or die("e;Error in query: "e;.sqlite_error_string(sqlite_last_error($handle)));
}
echo "e;Record added."e;;
}
echo "e;Returning to main."e;;
header ("e;Location: ../index2.php"e;);
exit;
?>}
set_error_handler("e;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 = "e;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')"e; or die("e;Error in query: "e;.sqlite_error_string(sqlite_last_error($handle)));
}
echo "e;Record added."e;;
}
echo "e;Returning to main."e;;
header ("e;Location: ../index2.php&_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 = "e;INSERT INTO $table (item_id, titlt;<br />\n";
}
set_error_handler("errHandler");
$db = "c:/server/sqlite/selection.db";
$handle = sqlite_open($db) or die("e;Could not open database"e;);
$query = "e;"e;;
if (isset($_GETї"e;tableName"e;])) {
$table = sqlite_escape_string($_GETї"e;tableName"e;]);
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 = "e;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 "e;Error: <b>ї$errno at line $errline] $errstr</b><br />\n"e;;
}
set_error_handler("e;errHandler"e;);
$db = "e;c:/server/sqlite/selection.db"e;;
$handle = sqlite_open($db) or die("e;Could not open database"e;);
$query = "e;"e;;
if (isset($_GETї"e;tableName"e;])) {
$table = sqlite_escape_string($_GETї"e;tableName"e;]);
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 = "e;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')"e; or die("e;Error in query: "e;.sqlite_error_string(sqlite_last_error($handle)));
}
echo "e;Record added.&qurns 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 "e;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']);: <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($_POSTo
that it doesent insert the item into the table
my insert.php:Code: Select all
<?php
function errHandler($errno, $errstr, $errfile, $errline) {
echo "e;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 = md5ept
that it doesent insert the item into the table
my insert.php:Code: Select all
<?php
function errHandler($errno, $errstr, $errfile, $errline) {
echo "e;Error: <b>ї$errno at line $errline] $errstr</b><br />\n"e;;
}
set_error_handler("e;errHandler"e;);
$db = "e;c:/server/sqlite/selection.db"e;;
$handle = sqlite_open($db) or die("Could not open database");
$query = ""e;;
if (isset($_GETї"e;tableName"e;])) {
$table = sqlite_escape_string($_GETї"e;tableName"e;]);
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 = &quturns 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 "e;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)));
<?php
function errHandler($errno, $errstr, $errfile, $errline) {
echo "e;Error: <b>ї$errno at line $errline] $errstr</b><br />\n"e;;
}
set_error_handler("e;errHandler"e;);
$db = "e;c:/server/sqlite/selection.db"e;;
$handle = sqlite_open($db) or die("e;Could not open database"e;);
$query = "e;"e;;
if (isset($_GETї"e;tableName"e;])) {
$table = sqlite_escape_string($_GETї"e;tableName"e;]);
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 = "e;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')"e; or die("e;Error in query: &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 "e;Error: <b>ї$errno at line $errline] $errstr</b><br />\n"e;;
}
set_error_handler("e;errHandler"e;);
$db = "e;c:/server/sqlite/selection.db"e;;
$handle = sqlite_open($db) or die("e;Could not open database"e;);
$query = "e;"e;;
if (isset($_GETї"e;tableName"e;])) {
$table = sqlite_escape_string($_GETї"e;tableName"e;]);
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 = "e;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')"e; or die("e;Error in query: "e;.sqlite_error_string(sqlite_last_error($handle)));
}
echo "e;Record added."e;;
}
echo "e;Returning to main."e;;
header ("e;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("e;errHandler"e;);
$db = "e;c:/server/sqlite/selection.db"e;;
$handle = sqlite_open($db) or die("e;Could not open database"e;);
$query = "e;"e;;
if (isset($_GETї"e;tableName"e;])) {
$table = sqlite_escape_string($_GETї"e;tableName"e;]);
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 = "e;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')"e; or die("tem 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;
?>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 = "e;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;
?>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 />\n"e;;
}
set_error_handler("e;errHandler"e;);
$db = "e;c:/server/sqlite/selection.db"e;;
$handle = sqlite_open($db) or die("e;Could not open database"e;);
$query = "e;"e;;
if (isset($_GETї"e;tableName"e;])) {
$table = sqlite_escape_string($_GETї"e;tableName"e;]);
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 = "e;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')"e; or die("e;Error in query: "e;.sqlite_error_string(sqlite_last_error($handle)));
}
echo "e;Record added."e;;
}
echo "e;Returning to main."e;;
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ї'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;
?>$handle = sqlite_open($db) or die("Could not open database");
$query = "";
if (isset($_GETї"e;tableName"e;])) {
$table = sqlite_escape_string($_GETї"e;tableName"e;]);
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 = "e;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: &
<?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;
?>