php/aboutUsAdmin at master · 00ZRHun/php · GitHub

1
2
3
4
5
6
7
8
9
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
75
76
77
78
79
80
81
<?php
 $conn = mysqli_connect("localhost", "root", "", "newdemo");
 $connect = mysqli_connect("localhost", "root", "", "photo");
// Check connection
if($conn -> connect_error)
{
	die("Connection failed:".$conn -> connect_error);
}

 if(isset($_POST["insert"]))
 {
      $file = addslashes(file_get_contents($_FILES["image"]["tmp_name"]));
      $query = "INSERT INTO tbl_images(name) VALUES ('$file')";
      if(mysqli_query($connect, $query))
      {
           echo '<script>alert("Image Inserted into Database")</script>';
      }
 }
?>
<!DOCTYPE html>
<html>
<head>
	<title></title>
	<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.0/jquery.min.js"></script>
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" />
    <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>

    <meta name="viewport" content="width=device-width, initial-scale=1">
</head>
<body>
	<?php
	$sql = "SELECT * from about_us;";
	//$result = $conn -> query($sql);
	$result = mysqli_query($conn, $sql);
	$row = mysqli_fetch_assoc($result);
	?>
	<h1 class="title"><?php echo "$row["title"]<br>" ?></h1>
<a href='edit.php?edit=$row[content]'>edit</a>


	<div class="text">
<!-- <h1 class="header"></h1> -->
<?php echo $row["content"]; ?>
	</div>
	<div class="image"><img src="data:image/jpeg;base64,'.base64_encode($row['image'] ).'" height="200" width="200" class="img-thumnail" style="text-align: right; margin: 30" /></div>
	<a href="edit.php?edit=$row[content]">edit</a>

	<!-- image -->
	<br /><br />
           <div class="container" style="width:500px;">
                <h3 align="center">Insert and Display Images From Mysql Database in PHP</h3>
                <br />
                <form method="post" enctype="multipart/form-data">
                     <input type="file" name="image" id="image" />
                     <br />
                     <input type="submit" name="insert" id="insert" value="Insert" class="btn btn-info" />
                </form>
                <br />
                <br />
                <table class="table table-bordered">
                     <tr>
                          <th>Image</th>
                     </tr>
                <?php
                $query = "SELECT * FROM tbl_images ORDER BY id DESC";
                $result = mysqli_query($connect, $query);
                while($row = mysqli_fetch_array($result))
                {
                     echo '
                          <tr>
                               <td>
                                    <img src="data:image/jpeg;base64,'.base64_encode($row['name'] ).'" height="200" width="200" class="img-thumnail" />
                               </td>
                          </tr>
                     ';
                }
                ?>
                </table>
            </div>
</body>
</html>