neil.mckillop.org

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== Teaching PHP ======
===== Making a MySQL database connection =====

<code php>
$host = "localhost";
$dbname = "database_name";
$username = "username";
$password = "password";
$port = 3306;
$charset = "utf8mb4";

$connection_string = "mysql:host=$host;dbname=$dbname;port=$port;charset=$charset";
$db_settings = array(PDO::ATTR_ERRMODE => PDO::ERRMODE_WARNING,
                     PDO::ATTR_PERSISTENT => true);

$db = new PDO($connection_string, $username, $password, $db_settings);
</code>

==== Fetching data ====
<code php>
$sql = "select * from tablename";
$stmt = $db->query();
$data = $stmt->fetchall();
</code>

==== Fetching specific data ====
<code php>
$search_term = "Neil";
$sql = "select * from tablename where forename=?"
$stmt = $db->prepare($sql);
$stmt->execute([$search_term]);
$data = $stmt->fetch();
</code>

==== Inserting data ====
<code php>
$test_var = 123;
$sql = "insert into tablename set var1=?";
$stmt = $db->prepare($sql);
$stmt->execute([$test_var]);
</code>

neil.mckillop.org

User Tools

Site Tools

Page Tools