PHP PDO SQL Snippets

Some very basis PDO snippets to use SQL with PHP.

Insert

if (isset($_POST['submit'])) {

	// parse form data
	$sTitle      = $_POST['title'];
	$sMessage    = htmlspecialchars($_POST['message']);
	
	try
	{
		// prepare the query
		$sql = "INSERT INTO 
				table
				(title, message) 
				VALUES 
				(:title, :message)";

		// bind date to the query
		$stmt = $db->prepare($sql);
		$stmt->bindParam(':title',$sTitle, PDO::PARAM_STR);
		$stmt->bindParam(':message', $sMessage, PDO::PARAM_STR);
		
		// execute query
		$result = $stmt->execute();

		// print message on success
		if($result) {
			echo "<br>Added... ok";
		}
	}
	catch(PDOException $e)
	{
		echo '<pre>';
		echo 'Line: '.$e->getLine().'<br>';
		echo 'File: '.$e->getFile().'<br>';
		echo 'Message: '.$e->getMessage();
		echo '</pre>';
	}
}

Select

if (isset($_POST['submit'])) {

	// parse form data
	$sId      = $_POST['id'];
	
	try
	{
		// prepare the query
		$sql = "SELECT
				*
				FROM 
				table
				WHERE
				id - :id";

		// bind date to the query
		$stmt = $db->prepare($sql);
		$stmt->bindParam(':id',$sId, PDO::PARAM_INT);
		
		// execute query
		$result = $stmt->execute();

		// print message on success
		if($result) {
			echo "<br>Succes... ok";
		}
	}
	catch(PDOException $e)
	{
		echo '<pre>';
		echo 'Line: '.$e->getLine().'<br>';
		echo 'File: '.$e->getFile().'<br>';
		echo 'Message: '.$e->getMessage();
		echo '</pre>';
	}
}

Update

if (isset($_POST['submit'])) {

	// parse formitems
	$sId         = $_POST['id'];
	$sTitle      = $_POST['title'];
	$sMessage    = htmlspecialchars($_POST['message']);
	
	try
	{
		// prepare the query
		$sql = "UPDATE
				table
				SET
				title=:head, message=:message
				WHERE
				id=:id";

		// bind date to the query
		$stmt = $db->prepare($sql);
		$stmt->bindParam(':id', $sId);
		$stmt->bindParam(':title',$sTitle, PDO::PARAM_STR);
		$stmt->bindParam(':message', $sMessage, PDO::PARAM_STR);
		
		// execute query
		$result = $stmt->execute();

		// print message on success
		if($result) {
			echo "<br>Changed... ok";
		}
	}
	catch(PDOException $e)
	{
		echo '<pre>';
		echo 'Line: '.$e->getLine().'<br>';
		echo 'File: '.$e->getFile().'<br>';
		echo 'Message: '.$e->getMessage();
		echo '</pre>';
	}
}

Delete

if (isset($_POST['submit'])) {

	$sId = $_POST['id'];

	try
	{
		// prepare the query
		$sql = "DELETE FROM table WHERE id = :id";

		// bind date to the query
		$stmt = $db->prepare($sql);
		$stmt->bindParam(':id', $sId);
		
		// execute query
		$result = $stmt->execute();

		// print message on success
		if($result) {
			echo "<br>Removed... ok";
		}
	}
	catch(PDOException $e)
	{
		echo '<pre>';
		echo 'Line: '.$e->getLine().'<br>';
		echo 'File: '.$e->getFile().'<br>';
		echo 'Message: '.$e->getMessage();
		echo '</pre>';
	}
}