WEB DEVELOPMENT
PHP PRESENTATORS MD. AL-MAMUN SARKAR
PHP MYSQL
Connection $conn = new mysqli(server, username, password, dbname); $conn = mysqli_connect(server, username, password, dbname);
Query $conn->query($sql) mysqli_query($conn, $sql)
Select OOP $sql = "SELECT id, firstname, lastname FROM MyGuests"; $result = $conn->query($sql); if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { echo "id: " . $row["id"]; } } else { echo "0 results"; }
Select Procedural $sql = "SELECT * FROM students"; $result = mysqli_query($conn, $sql); if (mysqli_num_rows($result) > 0) { while($row = mysqli_fetch_assoc($result)) { echo "id: " . $row["id"]; } } else { echo "0 results"; }
Insert $sql = "INSERT INTO users(firstname, lastname, email) VALUES ('John', 'Doe', 'john@example.com')"; mysqli_query($conn, $sql)
Update $sql = "UPDATE users SET lastname='Doe' WHERE id=2"; $conn->query($sql)
Delete $sql = "DELETE FROM students WHERE id=3"; mysqli_query($conn, $sql)
QUESTION ?
THANK YOU

Database Management - Lecture 4 - PHP and Mysql