Skip to main content

Save image to database using PhP


 <?php

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

 $cont =   file_get_contents($_FILES['f1']['tmp_name']); 
$type = $_FILES['f1']['type'];         $cont=addslashes($cont); 
    mysql_connect("servername","username","password");
mysql_select_db("dbname"); 

 $sql="insert into tablename values ('','$cont','$type')"; 

if(mysql_query($sql)) 
echo "Inserted"; 
else 
echo mysql_error(); 
}
?>

 <form method="post" action="" enctype="multipart/form-data">

 <input type="file" name="f1">

Image : <input type="submit" value="Upload" name="sub">

</form> -------------------------------------------------------------------- Note: When we using XAMPP or WAMP, servername = localhost, username = root, password is empty.

Comments

Popular posts from this blog

Temperature Calculator using PHP

This is a PHP script to calculate and display average temperature, five lowest and highest temperatures. <?php $month_temp = "78, 60, 62, 68, 71, 68, 73, 85, 66, 64, 76, 63, 81, 76, 73, 68, 72, 73, 75, 65, 74, 63, 67, 65, 64, 68, 73, 75, 79, 73"; $temp_array = explode(',', $month_temp); $tot_temp = 0; $temp_array_length = count($temp_array); foreach($temp_array as $temp) {  $tot_temp += $temp; }  $avg_high_temp = $tot_temp/$temp_array_length;  echo "Average Temperature is : ".$avg_high_temp."; sort($temp_array); echo " List of five lowest temperatures :"; for ($i=0; $i< 5; $i++) { echo $temp_array[$i].", "; } echo "List of five highest temperatures :"; for ($i=($temp_array_length-5); $i< ($temp_array_length); $i++) { echo $temp_array[$i].", "; } ?>

PHP fiction to change array values to upper and lower case

<?php function array_change_value_case($input, $ucase) { $case = $ucase; $narray = array(); if (!is_array($input)) { return $narray; } foreach ($input as $key => $value) { if (is_array($value)) { $narray[$key] = array_change_value_case($value, $case);  continue; } $narray[$key] = ($case == CASE_UPPER ? strtoupper($value) : strtolower($value)); } return $narray; } $Color = array('A' => 'Blue', 'B' => 'Green', 'c' => 'Red'); echo 'Actual array '; print_r($Color); echo 'Values are in lower case.'; $myColor = array_change_value_case($Color,CASE_LOWER); print_r($myColor); echo 'Values are in upper case.'; $myColor = array_change_value_case($Color,CASE_UPPER); print_r($myColor); ?>