PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
Copy Clear
Copy Format Clear
<?php $servername = "localhost"; $username = "username"; $password = "password"; $dbname = "database_name"; // Create connection // Check connection if ($mysqli->connect_error) { die("Connection failed: " . $mysqli->connect_error); } $sql = "CREATE TABLE users ( id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, name VARCHAR(30) NOT NULL, email VARCHAR(50), password VARCHAR(255) NOT NULL )"; if (mysqli_query($mysqli, $sql)) { echo "Table users created successfully"; } else { echo "Error creating table: " . mysqli_error($conn); } // CREATE if (isset($_POST['create'])) { $name = $_POST['name']; $email = $_POST['email']; $sql = "INSERT INTO users (name, email) VALUES ('$name', '$email')"; if ($mysqli->query($sql) === TRUE) { echo "New record created successfully"; } else { echo "Error: " . $sql . "<br>" . $mysqli->error; } } // READ $sql = "SELECT id, name, email FROM users"; $result = $mysqli->query($sql); if ($result->num_rows > 0) { echo "<table><tr><th>ID</th><th>Name</th><th>Email</th></tr>"; // output data of each row while($row = $result->fetch_assoc()) { echo "<tr><td>" . $row["id"]. "</td><td>" . $row["name"]. "</td><td>" . $row["email"]. "</td></tr>"; } echo "</table>"; } else { echo "0 results"; } // UPDATE if (isset($_POST['update'])) { $id = $_POST['id']; $name = $_POST['name']; $email = $_POST['email']; $sql = "UPDATE users SET name='$name', email='$email' WHERE id=$id"; if ($mysqli->query($sql) === TRUE) { echo "Record updated successfully"; } else { echo "Error: " . $sql . "<br>" . $mysqli->error; } } // DELETE if (isset($_POST['delete'])) { $id = $_POST['id']; $sql = "DELETE FROM users WHERE id=$id"; if ($mysqli->query($sql) === TRUE) { echo "Record deleted successfully"; } else { echo "Error: " . $sql . "<br>" . $mysqli->error; } } $mysqli->close(); ?> <!-- HTML form for user input --> <form action="index.php" method="post"> <input type="hidden" name="id"> Name: <input type="text" name="name"><br><br> Email: <input type="text" name="email"><br><br> <input type="submit" name="create" value="Create"> <input type="submit" name="update" value="Update"> <input type="submit" name="delete" value="Delete"> </form>
Show:  
Copy Clear