PHP PDO Insert and Update Data in mysql Database

Hello Everyone today i will create new post. In this post, we will implement prepared statement for insert and update data. I will show simple example.

prepare($sql);
$q->execute(array(':author'=>$author,
                  ':title'=>$title));


?>

Example for update data:

prepare($sql);
$q->execute(array($title,$author,$id));


?>

10:27 PM Share:

PHP User Login script without Database

Hello,
How are you, today i will showing how to create member login php script without database. only using txt file. you save all member login details this txt file. it's easy to create login system.

Setup Step :
   1. Create New Folder
   2. Create New Txt File (member.txt)
   3. Copy and past this code new file on same folder

Download Full Script 

12:53 PM Share:

PHP Ajax Login With Shake Animation Effect.

Today I will writing, how to create a simple Ajax PHP login with welcome page using MySQL database. This will explain you creating user tables, posting form values and storing and destroying the session values.

11:42 PM Share:

PHP Connect to the MySQL Database

Open a Connection to the MySQL Database

After you can access data in your database, we must open a connection to the MySQL Database.

In PHP, this is done with the mysql_connect() function.

Example :

host = Type a host name or an IP address

username = Enter MySql User Name

Password = Enter Mysql Password

8:02 AM Share: