Not Inserting into DB

Posted on 16th Feb 2014 07:03 pm by admin

I can't get my Add new Division form to submit to the database. Anyone see my issue?

Code: <?php
$e = <<<here
<script src="./jscripts/scriptaculous/prototype.js" type="text/javascript"></script>
<script src="./jscripts/scriptaculous/scriptaculous.js" type="text/javascript"></script>
<script type="text/javascript" src="./jscripts/ajax.js"></script>
here;
switch ($_REQUEST['option']) {
case 0:
echo $e;
?>
<h1 class="backstage">Division Management</h1><br />
<h2 class=backstage>Divisions :: <a href="#" onclick="ajaxpage('backstage_libs/division.php?option=1', 'content'); return false;">Add New</a></h2><br />
<table width="100%" class="table1">
<tr class="rowheading">
<td>&nbsp;</td>
<td>Name</td>
</tr>
<?php
$query = "SELECT * FROM efed_list_divisions";
$result = mysql_query ( $query );
$rows = mysql_num_rows($result);

if ($result) {
$i = 0;
while ( $row = mysql_fetch_array ( $result, MYSQL_ASSOC ) ) {
$sClass = 'row2';
if ($i++ % 2) $sClass = 'row1';
printf ( "<tr class="%s">", $sClass );
print "<td valign="top" align=center width=35><a href="#" onclick="ajaxpage('backstage_libs/division.php?option=2', 'content'); return false;">Edit</a></td>";
printf ( "<td valign="top">%s</td>", $row [name] );
echo '</tr>';
}
echo '</table>';
} else {
echo '<span>There are no divisions.</span><br />';
}
returnmain();
break;
case 1:
echo $e;
require_once('../backstagefunctions.php');
?>
<h1 class="backstage">Division Management</h1><br />
<h2 class="backstage">Add New Division</h2><br />
<form name="divisions" method="post">
<input type="hidden" name="action" value="division" />
<table width="100%" class="table2">
<tr>
<td width="120" class="rowheading" valign="center">Division Name:</td><td class="row3"><input type="text" name="name" class="fieldtext490"></td>
</tr>
</table><br />
<input type="hidden" name="newadded" value="true">
<input type="submit" value="Save Division" class="button"></form><br />
<form method="post"><input type="submit" value="Return to Division List" class="button200" name="return">
</form><br />
<?php
returnmain();
break;
case 2:
echo $e;
require_once('../backstagefunctions.php');
?>
<h1 class="backstage">Division Management</h1><br />
<h2 class="backstage">Edit Division</h2><br />
<form name="editdivision" method="post">
<table width="100%" class="table2">
<tr>
<td width="120" class="rowheading" valign="center">Division:</td><td class="row3"><input type="text" name="division" class="fieldtext490" value=""></td>
</tr>
</table><br />
<center>
<input type="checkbox" name="deletedivision"><span class="table1heading">Delete Division?</span><br /><br />
<input type="submit" value="Edit Division" class=button name="editdivision"><br /><br />
<input type="button" value="Return to Divisions List" class="button200"><br /><br />
</form>
<?php
returnmain();
break;
}
function division() {
if ((!empty($_POST['newadded'])) && (!empty($_POST['divisions']))) {
$name = mysql_real_escape_string($_POST['name']);
$query = "INSERT INTO `efed_list_divisions` (name) VALUES ('".$name."')";
if (mysql_query($query)) {
//success
} else {
//fail
}
}
}
?>

Your Answer:

Login to answer

Other forums

Is it possible to put an entire 500-page book in a database with PHP?
I am working on an intranet and I was wondering if its possible to code php with mysql to enter a fu

php mysql query from input textbox
Hi,

I have a text box, in that i have given the mysql query. I can able to get the query in v

column name cancatenation within PL/SQL
I have a PLSQL store procedure, and the following statement is part of a subquery
fname||lnam

Pre-Fill out a PHP form...??
This is for work actually (geek squad). We have to fill out this online php form at work over and ov

Dynamically allocating the number of rows in a table based on a variable value
Hi,
I have situation here which i cannot resolve, I have a variable temp which stores the num

FlashVar function how to insert variables
Hi guys. Im new in this forum and also new in php programming. Can you help me about this code?
<

textfield unchanged
hi,
i want my form to know whether its textbox is unchange or not.

if($textbox == 'unchang

Creation of Raw Exposure manually
SAP Gurus

I am creating Raw Exposure ( Hedge management ) thru T Code TEM10 with followin

Solution to the FindControl problem
I have seen may posts about having problems with the FindControl method. Most seem to come about bec

Help with Password Encoding/Decoding?
Trying to design a "change password" tool. On my signup code I'm using base64_encode, now