How to insert data into mysql database using oops php5 concepts?

Question

I am new for PHP5 OOP concept. Please give some example source code for "How to insert data using oops concept?".I want to use pure php5 concept for this even in the connection.php page also. I want to improve my knowledge. please any one help me....

I know below the basic concept

insert_db.php

                $sql="INSERT INTO Persons (FirstName, LastName, Age)
            VALUES
            ('$_POST[firstname]','$_POST[lastname]','$_POST[age]')";

            if (!mysql_query($sql,$con))
              {
              die('Error: ' . mysql_error());
              }
            echo "1 record added";

            mysql_close($con)

connectio.php

          <?php
            // connect database  code
             $dbhost ='localhost';
            $dbuser = 'tomking';
            $dbpass = 'dsfds';
            $dbname = 'mydb';
            //connectivity of database
            $conn = mysql_connect($dbhost,$dbuser,$dbpass) or die ('Error Connecting to mysql');
            mysql_select_db($dbname);
          ?>

I suggest learning MySQLi instead of the obsolete mysql API in PHP — Adrian Cornish
– Adrian Cornish, Commented Sep 20, 2012 at 4:08
Just google with 'insert mysql data in php', you will get lot of examples for it. — Justin John
– Justin John, Commented Sep 20, 2012 at 4:16
@justin But i want to use class and all the php5 concept for this. Google is showing result same as above code... — Dan
– Dan, Commented Sep 20, 2012 at 4:20
This PDO tutorial will show you how to use PDO, how to wrap it in a class is your own design decision. — user1233508
– user1233508, Commented Sep 20, 2012 at 4:22
if anybody have a small sample of php5 project for inserting data into database(using pure php5 concept). Then please forward it to my mail -> [email protected] — Dan
– Dan, Commented Sep 20, 2012 at 4:25

Yogesh Suthar · Accepted Answer · 2013-07-17 02:19:57Z

1

Use Mysqli or PDO for using sql queries instead of directly pass variables to query.

This will cause sql injection when you directly pass variable to query

If you want to pass variable to sql query , you have to use filters for this

filtering-escaping-post-data-from-injection-attacks

PDO Documentation

MySQLi Documentation

And this is all pure PHP5 concept.

edited Jul 17, 2013 at 2:19

answered Sep 20, 2012 at 4:18

Yogesh Suthar

30.5k18 gold badges75 silver badges100 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user1233508 Over a year ago

Don't use stripslashes. Disable magic_quotes instead and let bind variables take care of all filtering for you.

Mihai Matei · Accepted Answer · 2012-09-20 04:21:06Z

1

$mysqli = new mysqli($hostname, $username, $password, $database_name);

if($mysqli->error)
    die($mysqli->error);

$mysqli->query("SET NAMES 'UTF8'");

$query = "INSERT INTO my_table VALUES ('value_1', 'value_2')";
$mysqli->query($query);
if(!$mysql->error)
   echo 'do something';

$query = "SELECT * FROM my_table";
$sql = $mysqli->query($query);
if($sql->num_rows > 0) {
    while($row = $sql->fetch_assoc()) {
        echo $row['field_1'];
    }
}
$sql->close();

answered Sep 20, 2012 at 4:21

Mihai Matei

24.3k5 gold badges34 silver badges50 bronze badges

Collectives™ on Stack Overflow

How to insert data into mysql database using oops php5 concepts?

connectio.php

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

connectio.php

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related