photo upload

-
<html>
<head>
 <script src="assets/js/jquery-1.10.2.js"></script>
    <!-- BOOTSTRAP SCRIPTS -->
    <script src="assets/js/bootstrap.js"></script>
    <!-- PAGE LEVEL SCRIPTS -->
    <script src="assets/js/bootstrap-fileupload.js"></script>
    <!-- METISMENU SCRIPTS -->
    <script src="assets/js/jquery.metisMenu.js"></script>
    <!-- CUSTOM SCRIPTS -->
    <script src="assets/js/custom.js"></script>
       
</head>
<body>

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

<input  type="file" name="photo"><br>
<input type="submit" name="submit" value="SEND">
</form>


    <?php

        $con=mysqli_connect("localhost","root","root","img") or die(mysqli_error());
if(isset($_POST['submit']))
{

    extract($_POST);

    $name=$_FILES['photo']['name'];
    $type=$_FILES['photo']['type'];
    $size=$_FILES['photo']['size'];

    $temp=$_FILES['photo']['tmp_name'];
    move_uploaded_file($temp,"abc/".$name);

    $query=mysqli_query($con,"insert into img1(name,type,size) value('$name','$type','$size') ") or die(mysqli_error($con));



}

?>



<?php
    $con=mysqli_connect("localhost","root","root","img") or die(mysqli_error());
    $que=mysqli_query($con,"select * from img1") or die(mysqli_error($con));
   

?>
<table border="1">
<tr>
<td>ID</td>
    <td>img</td>
<td>type</td>
<td>size</td>
   
</tr>
<?php
while($fet=mysqli_fetch_array($que))
{
extract($fet);
 ?>    
<tr>
<td><?php echo $id; ?></td>
<td><img src="abc/<?php echo $name;  ?>" height="200" width="200"></td>
<td><?php echo $type; ?></td>
<td><?php echo $size; ?></td>
   
</tr>
<?php

}
?>
</table>


<select>
<option>Select any one</option>
<?php
    $con=mysqli_connect("localhost","root","root","img") or die(mysqli_error());
    $quer=mysqli_query($con,"select * from img1") or die(mysqli_error($con));
     while($dr=mysqli_fetch_array($quer))
       {
        extract($dr);
    echo "<option value='$name'>$name</option>";
   

       }
?>


</select>



















</body>
</html>

Comments

Post a Comment

Popular posts from this blog

How to Delete record using PHP Ajax

-
index.php ?   01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 <!DOCTYPE html> <html> <head>      <title></title> </head> <body>   <?php        $connection = mysqli_connect( "localhost" , "root" , "" , "db_2018" ) or die (mysqli_error());        $ReadSql = "SELECT * FROM `crud`" ;      $res = mysqli_query( $connection , $ReadSql );   ?>     <table>      <tr>          <th>name</th>          <th>Last Name</th>          <th>email id</th>     ...
Read more

How to seperate character from string in php

-
?   1 2 3 4 5 6 7 8 9 $string = "abcdef" ; $result =[]; $strlen = strlen ( $string ); for ( $i =0; $i < $strlen ; $i ++) {      $result [ $i ]= $string [ $i ];   } print_r( $result );     $string = "abcdef"; $result=[]; $strlen = strlen($string); for($i=0;$i<$strlen;$i++) { $result[$i]=$string[$i]; } print_r($result);
Read more
-
 <?php function numberToWords($num) {     $ones = array(         0 => "zero",         1 => "one",         2 => "two",         3 => "three",         4 => "four",         5 => "five",         6 => "six",         7 => "seven",         8 => "eight",         9 => "nine",         10 => "ten",         11 => "eleven",         12 => "twelve",         13 => "thirteen",         14 => "fourteen",         15 => "fifteen",         16 => "sixteen",         17 => "seventeen",         18 => "eighteen",         19 => "nineteen"   ...
Read more