PDO Insert

Home Tutorial Php Phppdo Tutorial PDO Insert

PDO Insert
Posted on: April 2, 2010 at 12:00 AM

In this tutorial we will study about insertion of data using PDO in PHP, How to insert data using inbuilt function exec() is described here. Examples will make this clearer.

PDO-Insert-Code

To get data from the database, we need to put some data into it. In PDO we use same conventional coding of inserting data, but to execute the query we use PDO::exec method. PDO::exec method returns the number of effected rows which are successfully updated. PDO::exec method should use when SQL statements wont return a result set.

Example:

<?php

header('Content-type:text/plain');

try {

$db = new PDO("pgsql:dbname=ignou;host=localhost", "postgres", "1234" );

echo "connected\n";

$id=5;

$name='prabhat';

$roll=4;

$sql='insert into student(id,name,roll)values ($id,$name,$roll)';

$count=$db->exec("insert into student(id,name,roll)values ('$id','$name','$roll')");

echo "Number of affected rows are:".$count;

$db=null;

}

catch (PDOException $e)

{

echo $e->getMessage();

}

Output:

connected
Number of affected rows are:1

Related Tags for PDO Insert:

«Previous Index Next»

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.

Tutorial Topics