Mixture between html and php- UNIDENTIFIED INDEX

[micky125]

Lo all,

Had me head wrecked the whole week with a really stupid problem that came down to me not reading something but now when im running the php file i have errors switched on and i have bout 15 unidentified index but the problem is that i have used the code

function addActual()
{
var myTab = document.getElementById('myTable2');
var row=myTab.rows.length; var y=myTab.insertRow(row);
var a=y.insertCell(0);
var xx= document.createElement('input');
xx.type="text";
xx.name="Date[]";
a.appendChild(xx);
var b=y.insertCell(1);
var xx= document.createElement('input');
xx.type="text";
xx.name="Staff[]";
b.appendChild(xx);
var c=y.insertCell(2);
var xx= document.createElement('input');
xx.type="text";
xx.name="Wage[]";
c.appendChild(xx); var d=y.insertCell(3);
var xx= document.createElement('input');
xx.type="text";
xx.name="Hours[]";
}
 

to add a row of a table in my input form but i have alot of them and as you can see they start array lists. the code in me php to call these is

$Date = $_POST['Date[]']; 
$Staff = $_POST['Staff[]'];
$Wage = $_POST['Wage[]'];
$Hours = $_POST['Hours[]'];
 

I also think this is stopping my mysql select statement as i use

function getProjectDetails()
{
    global $ProjName;
    $temp = mysql_query("SELECT   Float, Extension, Excusable, NonExcusable, Delays, Value, LiquidatedDamages, totalLiquidatedDamages 
              FROM     ProjectDetails
              WHERE    Name= $ProjName")or die('<hr />MySQL Error1: ' .mysql_error(). '<hr />'); 
    $row = mysql_fetch_array($temp);
    return $row;
}
// A function to allow overall project variables to be manipulated.
function makeVariableProjectDetails()
{
    global $projectFloat, $projectExtension, $projectExcusable, $projectNonExcusable,
        $projectDelays, $projectValue, $liquidateddamages, $totalliquidateddamages;
    $temp = getProjectDetails();
    $projectFloat = $temp['ProjectFloat'];
    $projectExtension = $temp['Extension'];
    $projectExcusable = $temp['Excusable'];
    $projectNonExcusable = $temp['NonExcusable'];
    $projectDelays = $temp['Delays'];
    $projectValue = $temp['Value'];
    $liquidateddamages = $temp['LiquidatedDamages'];
    $totalliquidateddamages = $temp['totalLiquidatedDamages'];
}
 

where the error message

MySQL Error1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Float, Extension, Excusable, NonExcusable, Delays, Value, Liquid

comes. So is this connected and any1 ideas... im bout 99% positive me sql query is sound and i had ProjName in input form added so it wasnt that?

[micky125]

LOL PBMods u hit the nail on the head there... im only outa uni (doing this for dissertation in construction management [yes a major change]) and all i learned was java, cobol, mysql and prolog so what ur saying is 100% but i have looked at foreach code and have not understood it. In ur explanation it is very clear tbh but what is $element, is this the $i or do i go for column headings?

[pbmods]

This code:

foreach( $array as $index => $element )
{
  .
  .
  .
}
 

is roughly equivalent to this:

for( $index = 0; $index <= count($array); $index++ )
{
  $element = $array[$index];
 
  .
  .
  .
}
 

Except that foreach runs through EVERY element in the array, even if it has a non-numeric index.

http://php.net/foreach

[micky125]

U learn something new every day... thanks for explaining it to me cus i know uve got the blog and probs explain everyday of the week but sound1. Ill pass this teaching on LOL. :D

[micky125]

Hi guys ive been trying to use these foreach loops and was just looking clarification to find whetehr i am doing it rite.

//Email Variables
$EmailFro = $_POST['EmailFrom'];
$EmailT = $_POST['EmailTo'];
$EmailDat = $_POST['EmailDate'];
$EmailSubjec = $_POST['EmailSubject'];
$EmailMessag = $_POST['EmailMessage'];
 
foreach ($EmailFro as $i => $temp) {
  $EmailFrom[$i] = $temp;
}
foreach ($EmailT as $i => $temp) {
  $EmailTo[$i] = $temp;
} 
foreach ($EmailDat as $i => $temp) {
  $EmailDate[$i] = $temp;
}
foreach ($EmailSubjec as $i => $temp) {
  $EmailSubject[$i] = $temp;
}
foreach ($EmailMessag as $i => $temp) {
  $EmailMessage[$i] = $temp;
}
 
// With the remaining foreach loops being
 
foreach ($Dat as $i => $temp) {
  $Date[$i] = $temp;
}
foreach ($Staf as $i => $temp) {
  $Staff[$i] = $temp;
}
foreach ($Wag as $i => $temp) {
  $Wage[$i] = $temp;
}
foreach ($Hour as $i => $temp) {
  $Hours[$i] = $temp;
}
foreach ($SubDat as $i => $temp) {
  $SubDate[$i] = $temp;
}
foreach ($Sub as $i => $temp) {
  $Subs[$i] = $temp;
}
foreach ($Pric as $i => $temp) {
  $Price[$i] = $temp;
}
foreach ($Typ as $i => $temp) {
  $Type[$i] = $temp;
}
 
 

I get errors of

Warning: Invalid argument supplied for foreach() in /home/moneill/public_html/mainPHP.php on line 231

Notice: Undefined offset: 1 in /home/moneill/public_html/mainPHP.php on line 238

and the period of coding that this represents is

// A function to allow overall project variables to be manipulated.
function makeVariableProjectDetails()
{
    global $ProjName, $projectFloat, $projectExtension, $projectExcusable, $projectNonExcusable,
        $projectDelays, $projectValue, $liquidateddamages, $totalliquidateddamages;
 
    $temp = mysql_query("SELECT Name, ProjectFloat, Extension, Excusable, NonExcusable, Delays, Value, LiquidatedDamages, totalLiquidatedDamages 
              FROM     ProjectDetails
              WHERE    Name= '$ProjName'")or die('<hr />MySQL Error1: ' .mysql_error(). '<hr />');
    $temp = mysql_fetch_array($temp); 
    $projectFloat = $temp['ProjectFloat'];
    $projectExtension = $temp['Extension'];
    $projectExcusable = $temp['Excusable'];
    $projectNonExcusable = $temp['NonExcusable'];
    $projectDelays = $temp['Delays'];
    $projectValue = $temp['Value'];
    $liquidateddamages = $temp['LiquidatedDamages'];
    $totalliquidateddamages = $temp['totalLiquidatedDamages'];
}
 

Where line 231 is $projectFloat ... and 238 is $liquidatedDama ges?

The reason why I want to call a variable by for loop is that the 800 lines of code have a lot of for loops and the program, as well as 20000 words has to be in for wednesddday morning so im a bit caught for time. Any one any ideas of the problem?

[pbmods]

Save your server some CPU cycles and just do:

$EmailFrom = $_POST['EmailFrom'];
$EmailTo = $_POST['EmailTo'];
$EmailDate = $_POST['EmailDate'];
$EmailSubject = $_POST['EmailSubject'];
$EmailMessage = $_POST['EmailMessage'];
 

Its result is identical to that of the code that you posted.