₦airaland Forum

Please can any one assist me wit d php codes on how to insert multiple records at once in a table?

What have you done so far? Have you attempted it?

Yes you can see my code below
when submitted it will write failed
if(isset($_POST['submit']))
{
$result = $_POST["grades"];
$total = $ca1+$ca2+$exam;
if ($total <= $gpa6){
$grade4 = $grad1;
$letter = $letter1;
}
elseif ($total <=$gpa7){
$grade4 = $grad2;
$letter = $letter2;
}
elseif ($total <=$gpa8){
$grade4 = $grad3;
$letter = $letter3;
}
elseif ($total <=$gpa9){
$grade4 = $grad4;
$letter = $letter4;
}
elseif ($total <=$gpa10){
$grade4 = $grad5;
$letter = $letter5;
}
if (count($result > 0))
{
$new = array();
foreach ($result as $key => $value)
{
$new[] = "('". $regno . "', '" . $name . "', '" . $sex. "', '" . $admissionyr."', '" . $value["term"] . "', '" . $value["session"] . "', '" . $value["subject"] . "', '" . $value["ca1"] . "', '" . $value["ca2"] . "', '" . $value["exam"] . "', '" . $value["total"] . "', '" . $value["grade"] . "', '" . $value["remark"] . "')";
}
if (count($new) > 0)
{

$checkdepart = mysql_query("select * from yrone where regno = '$regno' and subject = '$subject' and term ='$term'" or die ('could not select from registeration'.mysql_error());
$depart = mysql_num_rows($checkdepart);
while($row = mysql_fetch_assoc($checkdepart))
{
$c = $row['regno'];
}

if($depart == 0){
$query = mysql_query("INSERT INTO yrone (regno,name,admissionyr,class,term,session,subject,ca_test,mid_termtest,exam,total,grade, remark, now()) VALUES '.implode(',', $new)'";
if ($query)
{
echo "SUCCESS";
}
else
{
echo "FAILED";
}
}
}

first of all,with mysql functions, you are seriously opened to SQL injection(s)...try switching to mysqli or pdo....



there are multiple ways to do...
1.) You could use the multi_query function...

2.) you could run a foreach loop with the connection parameter outside the loop... you insert the SQL in the loop....

OP
Check this line where you have

if (count($result > 0));



I think, it should be like this



if (count($result) > 0);

dandylass:
Please can any one assist me wit d php codes on how to insert multiple records at once in a table?

what is in the row column and values.

There are several errors which we have to fix for your code to work. Let's see how this goes. Btw, which book are you learning with?

dandylass:
Yes you can see my code below
When submitted it will write failed
<?php
if(isset($_POST['submit']))
{
$result = $_POST["grades"]; /* is $_POST["grades"] receiving an array from the form?*/
[color=#563445]$total = $ca1+$ca2+$exam;
if ($total <= $gpa6){
$grade4 = $grad1;
$letter = $letter1;
}
elseif ($total <=$gpa7){
$grade4 = $grad2;
$letter = $letter2;
}
elseif ($total <=$gpa8){
$grade4 = $grad3;
$letter = $letter3;
}
elseif ($total <=$gpa9){
$grade4 = $grad4;
$letter = $letter4;
}
elseif ($total <=$gpa10){
$grade4 = $grad5;
$letter = $letter5;
}[/color]

/* You assigned your variables to variables that have not been previously initialized. For example,
$grade4 = $grad5;
Fix these first.*/

if (count($result > 0))
{
$new = array();
foreach ($result as $key => $value)
{
$new[] = "('". $regno . "', '" . $name . "', '" . $sex. "', '" . $admissionyr."', '" . $value["term"] . "', '" . $value["session"] . "', '" . $value["subject"] . "', '" . $value["ca1"] . "', '" . $value["ca2"] . "', '" . $value["exam"] . "', '" . $value["total"] . "', '" . $value["grade"] . "', '" . $value["remark"] . "')";
}
if (count($new) > 0)
{

$checkdepart = mysql_query("select * from yrone where regno = '$regno' and subject = '$subject' and term ='$term'" or die ('could not select from registeration'.mysql_error());
$depart = mysql_num_rows($checkdepart);
while($row = mysql_fetch_assoc($checkdepart))
{
$c = $row['regno'];
}

if($depart == 0){
$query = mysql_query("INSERT INTO yrone (regno,name,admissionyr,class,term,session,subject,ca_test,mid_termtest,exam,total,grade, remark, now()) VALUES '.implode(',', $new)'";
if ($query)
{
echo "SUCCESS";
}
else
{
echo "FAILED";
}
}
}

Ouch! Many errors. Brb. Fix the undefined values first.
Wait, I hope you're not using register_globals? That's the only way those variables could be assigned uninitialized variables and it's very insecure.

Can we know the values received in the $_POST array? Maybe seeing the html form can help.

Choiiii....I'll definitely get past this stage in my infant coding stage.

Ok to make evrything easier to people dt want to assist me i will post html form wit d code. tanx