[EDIT] FILE: imageupload.php.tar
home/koolde6/public_html/lovestrong/imageupload.php 0000755 00000001650 15073350455 0016557 0 ustar 00 <?php $files = glob("/home/koolde6/lovestrong/server/public/profileImage"."/*.jpg"); // get all files in a folder echo "got filename..".count($files); // Loop through array of fetched files and insert into database. $servername = "localhost"; $username = "koolde6_lsappuser"; $password = "ufU245j6TDXhF5h"; $dbname="koolde6_lovestrong"; // Create a connection $conn = mysqli_connect($servername, $username, $password, $dbname); // Check the connection if (!$conn) { die("Connection failed: " . mysqli_connect_error()); } echo "Connected successfully"; foreach ($files as $file) { $filename = basename($file); // WRITE YOU MySQL code here that inserts filenames into DB $sql = "INSERT INTO imagenames (name) VALUES ('".$filename."')"; if (mysqli_query($conn, $sql)) { echo "New record created successfully..".$filename; } else { echo "Error: " . $sql . "<br>" . mysqli_error($conn); } } mysqli_close($conn); ?>
SAVE
CANCEL