Hello there
Actually I've been trying to code some modification, which requires member to fill a form in a vbulletin powered page, this form collects data & inserts it in the database.
However it turned out that I'm not qualified enough to bring my idea to life
So I had to ignore lots of quality standards such as normalization, & other security issues, & I couldn't, finally I thought that best way to get started by making a very simple version of my idea, hence I created a very simple table called
testtable with just 2 columns one was
id, & the other was:
testcoulmn
id column was the primary key & auto incremented, the other (i.e.,
testcolumn) was varchar with length of 100
and I made my page as explained here in vb.org, and here is my code:
PHP Code:
<?php
// ####################### SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE & ~8192);
// #################### DEFINE IMPORTANT CONSTANTS #######################
define('NO_REGISTER_GLOBALS', 1);
define('THIS_SCRIPT', 'test'); // change this depending on your filename
// ################### PRE-CACHE TEMPLATES AND DATA ######################
// get special phrase groups
$phrasegroups = array(
);
// get special data templates from the datastore
$specialtemplates = array(
);
// pre-cache templates used by all actions
$globaltemplates = array(
'TEST',
);
// pre-cache templates used by specific actions
$actiontemplates = array(
);
// ######################### REQUIRE BACK-END ############################
require_once('./global.php');
// #######################################################################
// ######################## START MAIN SCRIPT ############################
// #######################################################################
$navbits = array();
$navbits[$parent] = 'Test Page';
$navbits = construct_navbits($navbits);
eval('$navbar = "' . fetch_template('navbar') . '";');
eval('print_output("' . fetch_template('TEST') . '");');
$testtable = "testtable";
$testform = $_POST['testform'];
if ($_REQUEST['do'] == "save")
{
$db->query_write("INSERT INTO " . TABLE_PREFIX . "" . $testtable . "(testcolumn) VALUES (" . $testform . ")");
}
?>
associated with this template called
TEST
HTML Code:
$stylevar[htmldoctype]
<html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
<head>
<title>$vboptions[bbtitle]</title>
$headinclude
</head>
<body>
$header
$navbar
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="tcat">Title</td>
</tr>
<tr>
<td class="alt1"><form name="someform" method="POST" action="test.php?do=save">
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="alt2" align="center">The Test Form</td>
<td class="alt2" align="center">
<input size="20" name="testform" dir="rtl"></td>
</tr>
<tr>
<td cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]"colspan="2" class="tfoot" align="center">
<input type="submit" value="Submit"></td>
</tr>
</table>
</form></td>
</tr>
</table>
$footer
</body>
</html>
but every time I try to insert data I don't find any data inserted in this
testtable, even though when I try to insert it through the phpmyadmin, it looks just fine, I put data only in the
testcolumn field and I find the table filled in both
id &
testcolumn fields, and the
id value is incremented and every thing looks just fine
Conclusion: I hope to get help in inserting data through a form into data base, just like what I'm trying to do.
waiting for your help, guys
thanks in advanced
More Information