PHP Database SELECT and INSERT Example – php-pdo

LAMP is probably the most popular web stack in the world. It powers Wikipedia, and it powered Facebook for years.

To access your MariaDB database from PHP server side scripts, use PHP-PDO. Remember to use library functions to put user data into SQL strings (prepare, bind); and sanitize away any Javascript before showing data to users (htmlentities).

This is just a quick script. For more thorough explanations, see Read MySQL database with PHP – php-pdo.

<?php
// connect
$pdo=new PDO("mysql:host=localhost;charset=UTF8;dbname=hats", 'hats', 'di3fgh2..&dheAB_loK');

// insert

$name = $_GET["name"];
$price = $_GET["price"];

if ("" != $name) {
	echo "<p>Inserting new record.</p>";
	$pdoStatement=$pdo->prepare("INSERT INTO hats (name) VALUES (:name)");
	$pdoStatement->bindParam(':name', $name);
	$pdoStatement->execute();
}

// list
$pdoStatement=$pdo->prepare('SELECT * FROM hats;');
$pdoStatement->execute();
$hits=$pdoStatement->fetchAll();

foreach($hits as $row) {
     echo "<p>".$row['id']." ".htmlentities($row['name'])." price ".$row['price']." rupees</p>\n";
}

?>

<form method=get>
	<input type=text name=name value="pipo">
	<input type=text name=price value=12>
	<input type=submit>
</form>
Posted in Uncategorized | Tagged | Leave a comment

Leave a Reply

Your email address will not be published. Required fields are marked *

*

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

  • Recent Posts

  • Picks

  • Boxing Clock for AndroidOcton8 Diving T-ShirtsShaking Tower Panda Android GameLearn Chinese with Android
  • Student projects