Viewing file:  photoupdate.php (1.14 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
$con=mysqli_connect("localhost","ailwssor_user","rb!ail838","ailwssor_database");
// Check connection
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$path = "files/";
$valid_formats = array("jpg", "png", "gif", "bmp","jpeg");
if(isset($_POST) and $_SERVER['REQUEST_METHOD'] == "POST")
{
$name = $_FILES['upload']['name'];
$size = $_FILES['upload']['size'];
if(strlen($name))
{
list($txt, $ext) = explode(".", $name);
if(in_array($ext,$valid_formats))
{
if($size<(1024*1024)) // Image size max 1 MB
{
$tmp = $_FILES['upload']['tmp_name'];
$actual_image_name = $_POST[serial].".".$ext;
//This gets all the other information from the form
}}}}
$op=$_POST[serial];
echo $op;
$sql = ("UPDATE student_admission SET
photo_upload='$actual_image_name'
WHERE serialno='$op'");
if(move_uploaded_file($_FILES['upload']['tmp_name'],$path.$actual_image_name)) ;
{
echo $actual_image_name;
}
if (!mysqli_query($con,$sql)) {
die('Error: ' . mysqli_error($con));
}
mysqli_close($con);
die ("<script>location = 'photoupdate_registration.php'</script>");
?>
|