$videoTitle = "comm'ent faire 'un fonctio'n qui me perm'et de vérfier";
Code : Tout sélectionner
<?php
class DB {
public $tableName = 'videos';
function __construct(){
// Database configuration
$dbHost = 'localhost';
$dbUsername = 'root';
$dbPassword = '123456';
$dbName = 'database';
// Connect database
$conn = new mysqli($dbHost, $dbUsername, $dbPassword, $dbName);
if($conn->connect_error){
die("Failed to connect with MySQL: " . $conn->connect_error);
}else{
$this->db = $conn;
}
}
function CheckTitle($videoTitle){
$query = "SELECT * FROM $this->tableName WHERE video_title = $videoTitle ";
$query = $this->db->query($sql);
if ($query !== FALSE)
{
// Run your code
if ($query->num_rows() === 1)
{
return $query->row();
}
}
else
{
// Check error
echo '0';
}
}
}
?>
