Answered
PHP Notice: Undefined offset ???
Hi Chaps,
I'm having some trouble with a PHP Form page and an Update Script page.
I've tested this on my Apache server and it works fine, but fails on my 'Live' IIS server:
Form Code:
PHP Code:
<input type='text' name='jobpriority[]' value="<?php echo $row_rsWorkload_All['jobpriority'];?>"/>
<?php echo $row['jobcount']; ?>
<?php echo $row_rsWorkload_All['jobpriority'];?>
<?php
$table_name = $row_rsWorkload_All['fromtable'];
$item_id = $row_rsWorkload_All['jobid'];
?>
<input type="hidden" name="setpriority[]" value="<?php echo $table_name; ?>:<?php echo $item_id; ?>" />
The 'hidden' input did look like this:
PHP Code:
<input type="hidden" name="setpriority[]" value="<?php echo $table_name; ?>:<?php echo $item_id; ?>:<?php $_POST ['jobpriority']; ?>" />
Code:
:<?php $_POST ['jobpriority']
Since removing the code, the page opens but when I 'click send' to pass the data to the script page, I get this error:
Quote:
| PHP Notice: Undefined offset: 22 in C:\Inetpub\XxxxxXxxxx\NewFiles\Xxxxx\Xxxxx\scripts\script.php on line 64 |
Code:
$allowed_tables = Array('tbl_table1','tbl_table2','tbl_table3'); // to prevent SQL injection
$i = 1;
foreach($_POST['setpriority'] as $var) {
$arr = explode(':', $var);
if(in_array($arr[0], $allowed_tables)) {
$table = $arr[0];
$rowid = $arr[1];
$priority = $_POST['jobpriority'][$i];
$i++;
if(is_numeric($rowid)) {
// run your SQL query here to update $table where row matches $rowid
$query = sprintf("
UPDATE $table
SET jobpriority='$priority'
WHERE jobid=$rowid");
$result = mysql_query($query, $conndb2) or die(mysql_error());
$mess = $ref = $_SERVER['HTTP_REFERER']; header( 'refresh: 0; url='.$ref);
}
else {
$mess = "<p>There was a problem</p>";
}
}
}
AdChoices