withinweb

Here are some of the basic syntax for using PDO Objects.
The advantage of PDO objects is that you pass your variables into the SQL function using prepared statements.
Prepared statements are what are termed paramatised queries when working with program languages like Microsoft dot.net and
provide a way to prevents sql injection into databases.
SQL FETCH
<?php
$dbh = new [...]

[Read more →]

<?php
//Example of fetching data from a database using PDO objects
# using the shortcut ->query() method here since there are no variable
# values in the select statement.
try {
$dbhost = “localhost”;
$dbname    = “users”;
$dbusername = “root”;
$dbpass = “”;
//Connect to the database
$dbh = new PDO(“mysql:host=” . $dbhost . “;dbname=” . $dbname, $dbusername, $dbpass);
//the sql query
$sql = “SELECT * FROM [...]

[Read more →]