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?

[Dormilich]

if $ProjName is a string, you should enclose it in single quotation marks.

regards

[micky125]

sound one that solved the mysql problem... still have to figure the
Undefined index: EmailFrom[] in /home/moneill/public_html/mainPHP.php on line 37

which are me arrays..

[Markus]

sound one that solved the mysql problem... still have to figure the
Undefined index: EmailFrom[] in /home/moneill/public_html/mainPHP.php on line 37

which are me arrays..

Post the code concerning your arrays. I currently can't find them in your given code.

[micky125]

lo markus

just got in from work there the code im using in the html file is basically having

header 1 h2 h3 h4 h5 etc |BUTTON|

There is zero input boxes below this so when you first press button javascript kicks in with 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[]"; 
} 
 
 

I have a couple of these all adding rows to different tables and it updates them ok. The problem i am having is that the inputs that it creates doesnt appear to work in the php program as i get the error;

unidentified index

I am using $_POST to pass them from html to php by

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

It is only the variables that i pass to php using this format all the normal inputs are accepted but not these. The problem i am guessing it is is that the javascript is not being passed to php but i cant be sure ... have you any ideas on this.

[Markus]

You're receive and undefined error, not unidentified.

When you pass an array to POST, you access it like an array.

 
$Date = $_POST['date']
 
 

[pbmods]

Heya, Micky.

When you name an input with '[]' at the end, it creates an array on the PHP side.

http://php.net/variables.external

[micky125]

sound one guys in work now but having to work till 10pm gmt the night so uve helped me loads. its in for next friday an i cant work on it over the weekend.

THANKS.

[micky125]

lol hey guys well ive done what u say and fair enuf it works but how do i separate the array i get into smaller parts.
I have tried the usual
for($i=1; $i<=count("theA rray"); $i++) //"theArray" is generic

but this throws an undefined offset which is when the array part im accessing doesnt exist. I have also tried using

explode(",", "theArray")

but it throws array to string conversion...

because of this i get undefined offset within any for loop i use with these arrays.

[pbmods]

For greater efficiency, consider using foreach. Putting count() in the for loop is a bit inefficient, as the array elements are count()'ed with each iteration.

http://blog.pbmods.com/2007/11/27/wh...lopers-part-1/