How to add array and insert it in MYsql

otixz

Hello and thank you very much for those who answered all of my questions.

I have another one.

example I have two arrays:
Array1 ( [0] => 2006-12-18 [1] =2006-12-18>
Array2 ( [0] => grace [1] =nombre>

question:
1.) how can I make a loop condition where i can insert the values of these two arrays in MYsql?

example:
where: $count = count(array1);

for($1=0;$i<=$count; $i++)
{
$qry="insert into table set ('date','user') values ('Array1','Array2');
$do = mysql_query($qry);
}

so the value in the table will be

date | user |

2006-12-18|grace

2006-12-18|nombre

I hope you can help in this problem.
Thank you again!
Grace

bradgrafelman

Hmm, I'd say something like..

for($count = count($array1), $i = 0, $data = ''; $i < $count; $i++) {
    if(!isset($array2[$i])) {
        echo 'Error: Array count mismatch.';
        break;
    }
    $data .= ', (\'' . $array1[$i] . '\', \'' . $array2[$i] . '\')';
}
$query = 'INSERT INTO `table` (`date`, `user`) VALUES ' . ltrim($data, ', ');
$do = mysql_query($qry);

otixz

Thank you very much for your reply Sir,
However, my application uses 8 arrays.
example

if my $data is:
,('','040724','2006-12-28','70','10','10','10', '060101')
,('','040724','2006-12-28','70','','','', '060101')
,('','040724','2006-12-28','70','10','10','10', '060101')

what can code can I use to cancel the insert statement if in case that one of the array has a null value? (2nd line of $data)? Like the error: Array Mismatch

I wish that you can still help me on this.
Thank you very much.

Grace

bradgrafelman

You could just add something like this to the for() loop:

if($array1[$i] == NULL || $array2[$i] == NULL) {
    echo 'Error: Empty string passed in array.';
    break;
}

otixz

Thank you Sir...
again, I'm seeking for your help:

for example:
I have 2 arrays:

Given:
array1=('','040724','2006-12-20','70','09:00:00','09:00:00','ds', '060101')
array2=('','040724','2006-12-20','70','09:00:00','','', '')
array3=('','040724','2006-12-20','70','09:00:00','09:00:00','ds', '060101')

from the example you gave me, the FOR loop let the array1 to be inserted to the database because it has valid values but when it is the array2's turn, the For loop terminated because it has a null value.

Question:
what can we do in order for the foor loop to check the arrays first from 1 to 2 if they have a valid value before it executes the insert command?

Example: from the Given, the insert for array1 will not execute because array2 has a null value. and so on with the other arrays.

thank you very much for your time sir...your help makes me learn PHP day by day?
Any advice? do you think the ROLLBACK and COMMIT can help us?

bradgrafelman

You mean you want to see if any of the arrays have null values before working with them? Something like this should do that:

if(array_search($array1, null) !== FALSE || array_search($array2, null) !== FALSE || array_search($array3, null) !== FALSE) {
    echo 'Error: One of the arrays has an empty value.';
} else {
    // put the for() statement here
    // no need to check for null values anymore... already did that
}

otixz

Thank you very much Sir,

One problem already resolved...

I only have one more problem:
Remember the $data variable you gave me from your previous replies?

The $data that I got from my code is like this:

,('','040724','2006-12-19','70','09:00:00','09:00:00','d', '060101')
,('','040724','2006-12-18','','09:00:00','09:00:00','d', '060101')

I tried also the array_search that you gave me to check if there is a null value for the $data variable but I got an error saying: array_search(): Wrong datatype for second argument

Sir, How can I check the $data varible if it has a null value? if it has a null value it will not execute the insert command...

Thank you Sir... for sharing your wisdom. You're helping me big on this one.
Grace

bradgrafelman

Woops, my mistake... I switched up the parameter order. It should look like this:

if(array_search(null, $array1) !== FALSE || array_search(null, $array2) !== FALSE || array_search(null, $array3) !== FALSE) { 
    echo 'Error: One of the arrays has an empty value.'; 
} else { 
    // put the for() statement here 
    // no need to check for null values anymore... already did that 
}

otixz

thank you very much sir for your patience, but I will still ask questions to you...

the $data's returned value is:

,('','040724','2006-12-07','73','09:00:00','09:00:00','09:00:00', '060101')
,('','040724','2006-12-07','73','09:00:00','09:00:00','09:00:00', '')
,('','040724','2006-12-07','73','09:00:00','','09:00:00', '060101')
,('','040724','2006-12-07','73','09:00:00','09:00:00','09:00:00', '060101')

I would like to ask, if you would recommend me some codes that I can use that will check the $data variable. If it contains a null variable then the INSERT query will not execute if it has all the variables needed, then the INSERT query will be executed.

Reminder: all of the given is the value of $data.

Question: is $data is an array or just a variable?
Thank you very much Sir

bradgrafelman

I thought $data was being defined by the for() loop and the other arrays, so if we checked the other arrays for null values before $data was ever defined, there wouldn't be a problem.

I suppose you could check for a literal '' in $data...

if(strpos($data, "''") !== FALSE) {
    echo 'Error: Null value detected in INSERT query.';
} else {
    // query is fine - execute with mysql_query()
}

otixz

Got it!
thank you very much for your support SIr!
I've done it so far...

You're the best!
Grace

bradgrafelman

Glad I could help! If that completely resolves your issue, don't forget to mark this thread resolved.