populating mysql using php

[anfetienne]

hi this question is linked to this post ive made in the mysql section.

http://bytes.com/topic/mysql/answers...le#post3499253

simply i want to use a form to populate a table with the locations of images, thumbnails and their corresponding captions. i want to populate the table like this:

id image location thumbnail location caption

1 folder/image1.jpg folder/t/image1.jpg just a test
2 folder/image2.jpg folder/t/image2.jpg just the test
3 folder/image3.jpg folder/t/image3.jpg just to test

is it possible to loop php to insert data into more than one row in a mysql table like shown above?

[dlite922]

Dorm,

Don't worry, when i was learning PHP, if you had slapped me in the face then gave me the wrong answer, I'd still would have loved you for it :)

But that's just me, I love learning,



Dan

[Dormilich]

yea, sometimes I wish I had a teacher for PHP… anyways, thanks Dan

Dorm the Worm *harhar*

[anfetienne]

apology accepted....bei ng new to php doesn't exactly help me in any case.

thanks for the tip, ill give it a try as well

[anfetienne]

ok ive done a test using prepared statements..... nice and fast but one problem....i dont know whether my loop is correct for this, it has worked when i done a multiple INSERT but only inserts 1 row with the prepared statements..

here is my code

<?php error_reporting(E_ALL);
 
$returnURL = $_POST['returnURL'];
 
if(isset($_POST['create_xml'])){
 
// configuration 
$dbtype     = "sql"; 
$dbhost     = "localhost"; 
$dbname     = "theau10_resources"; 
$dbuser     = "theau10_tawUser"; 
$dbpass     = "auction10"; 
 
// database connection 
$conn = new PDO("mysql:host=$dbhost;dbname=$dbname",$dbuser,$dbpass); 
 
// query 
$sql = "INSERT INTO flashGallery (id,imageLoc,thumbLoc,imageCap) VALUES (:id,:imageLoc,:thumbLoc,:imageCap)"; 
$q = $conn->prepare($sql); 
 
foreach ($_POST['random_digit'] as $key => $random_digit)
{
  $q->execute(array(':id'=>$random_digit,
                      ':imageLoc'=>$_POST['imageT'][$key],
                    ':thumbLoc'=>$_POST['thumbnailT'][$key], 
                    ':imageCap'=>$_POST['captionT'][$key])); 
 
}
 
}
?> 
 

[anfetienne]

problem solved....just had to change id to tempID for the project number and add a column id to auto increment

here is the final code

<?php error_reporting(E_ALL);
 
$returnURL = $_POST['returnURL'];
$random_digit = $_POST['random_digit'];
 
// configuration 
$dbtype     = "sql"; 
$dbhost     = "localhost"; 
$dbname     = "theau10_resources"; 
$dbuser     = "theau10_tawUser"; 
$dbpass     = "auction10"; 
 
// database connection 
$conn = new PDO("mysql:host=$dbhost;dbname=$dbname",$dbuser,$dbpass); 
 
// query 
$sql = "INSERT flashGallery (imageNo,tempID,imageLoc,thumbLoc,imageCap) VALUES (:imageNo,:tempID,:imageLoc,:thumbLoc,:imageCap)"; 
$q = $conn->prepare($sql); 
 
foreach ($_POST['picT'] as $key => $value)
{
  $q->execute(array(':tempID'=>$random_digit,
                    ':imageNo'=>$value,
                  ':imageLoc'=>$_POST['imageT'][$key],
                ':thumbLoc'=>$_POST['thumbnailT'][$key], 
                                ':imageCap'=>$_POST['captionT'][$key])); 
 
}
?>