YLRsT9mT

1<?php
2$servername = "localhost";
3$username = "";
4$password = "";
5$dbname = "";
6
7$artist="BLACKPINK";
8$title="Kill This Love";
9$duration="03:00";
10$album="solo";
11$idyt="2S24-y0Ij3Y";
12
13
14$size='4MB';
15$permalink="$artist-$title-mp3";
16$permalink=str_replace(' ','-',$permalink);
17
18$thumb=$permalink;
19
20// Create connection
21$conn = mysqli_connect($servername, $username, $password, $dbname);
22// Check connection
23if (!$conn) {
24    die("Connection failed: " . mysqli_connect_error());
25}
26
27// sql to create table
28$tabel = "CREATE TABLE IF NOT EXISTS bejo (
29      id INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
30      permalink varchar(255) NOT NULL,
31      artist varchar(255) NOT NULL,
32      title varchar(250) NOT NULL,
33      size varchar(250) NOT NULL,
34      duration varchar(250) NOT NULL,
35      album varchar(255) NOT NULL,
36      idyt varchar(255) NOT NULL,
37      thumb varchar(255) NOT NULL,
38      reg_date TIMESTAMP
39)";
40
41if (mysqli_query($conn, $tabel)) {
42
43} else {
44    echo "Error creating table: " . mysqli_error($conn);
45}
46
47$sql= "INSERT INTO 
48            bejo 
49         SET
50            permalink = ".$permalink.",
51            artist = ".$artist.",
52            title = ".$title.",
53            size = ".$size.",
54            duration = ".$duration.",
55            album = ".$album.",
56            idyt = ".$idyt.",
57            thumb = ".$thumb.",
58            ";
59if (mysqli_query($conn, $sql)) {
60    echo "New record created successfully";
61} else {
62    echo "Error: " . $sql . "<br>" . mysqli_error($conn);
63}
64
65
66mysqli_close($conn);
67?>