Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $username="root";
- $password="1k9i2n8gjd";
- $database="admin_db";
- $servername="localhost";
- // Create connection
- $conn = new mysqli($servername, $username, $password, $database);
- // Check connection
- if ($conn->connect_error)
- {
- die("Connection failed: " . $conn->connect_error);
- }
- echo "Connected successfully <br><hr>";
- $name = $_POST['name'];
- $dateTime = $_POST['dateTime'];
- $caption = $_POST['caption'];
- $comment = $_POST['comment'];
- $slideshow = $_POST['slideshow'];
- $hidden = false;
- $albumName = $_POST['albumName'];
- // echo "album name is" . $albumName;
- $sql = "SELECT albumID FROM album_tbl WHERE albumName = $albumName";
- $albumID = $conn->query($sql);
- // echo "Number of rows is " . $albumID->num_rows;
- if ($albumID->num_rows > 0) {
- // output data of each row
- while($row = $albumID->fetch_assoc()) {
- echo "Album ID: " . $row["albumID"]. "<br>";
- }
- } else {
- echo "0 results";
- }
- /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
- $new_comment = str_replace("'", "''", $comment);
- $sql = "INSERT INTO `image_tbl`(`name`, `dateTime`, `caption`, `comment`, `slideshow`, `hidden`, `albumID`) VALUES ('$name', '$dateTime', '$caption', '$new_comment', '$slideshow', '$hidden', '$albumID')";
- $result = $conn->query($sql);
- if ($result)
- {
- echo "Data has been inserted";
- }
- else
- {
- echo "Failed to insert";
- }
- $conn->close();
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement