mysql插入路径_我想在一个文件夹中插入 3 个图像，并使用新名称将路径导入 mysql...

# Below Database.php

$servername = "localhost";

$username = "root";

$password = "";

$dbname = "ctg";

// Create connection

connecttodb($servername,$dbname,$username,$password);

function connecttodb($servername,$dbname,$dbuser,$dbpassword)

{

global $link;

$link=mysql_connect ("$servername","$dbuser","$dbpassword");

if(!$link){

die("Could not connect to MySQL");

}

mysql_select_db("$dbname",$link) or die ("could not open db".mysql_error());

}

?>

# Below File.php

//error_reporting(0);

include("database.php");

if(isset($_POST['upload']))

{

/* Concept Image */

$aMyUploads = array();

foreach ($_FILES as $key => $aFile) {

for($i = 0; $i

//echo $aFile['error'][$i]; exit;

if(0 === $aFile['error'][$i]){

$uploadLocation = 'uploads/'.$aFile['name'][$i];

}

if(0 === $aFile['error'][$i] && (false !== move_uploaded_file($aFile['tmp_name'][$i], $uploadLocation))){

$aMyUploads[] = $uploadLocation;

} else {

$aMyUploads[] = '';

}

}

}

if(is_array($aMyUploads)){

$image1 = $aMyUploads[0];

$image2 = $aMyUploads[1];

$image3 = $aMyUploads[2];

$qry = mysql_query("INSERT INTO `ict` (`image1`, `image2`, `image3`) VALUES ('$image1', '$image2', '$image3')");

//$ex =mysql_query($qry,$con);

}else{

echo "ERROR :: Not insert Please try";

}

}

?>

IMAGE1

IMAGE2

IMAGE3

Upload