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 Data to Make JSON

Hi
Today I will showing How to create PHP to JSON Data. It's Easy and simple

 

PHP Code 

<?php

    $Arraydata= array("UserDetails" => array(array("name" => "Khaled", "age" => "18")), "WorkDetails" => array(array("company_name" => "My Company", "role" => "web application developer", "employees" => "91")));
    $json_encode = json_encode($Arraydata);
    echo $json_encode."<br/>";

 ?>

Output 

{"UserDetails":[{"name":"Khaled","age":"18"}],"WorkDetails":[{"company_name":"My Company","role":"web application developer","employees":"91"}]}

8:27 AM Share:

How to Make Visitor Counter using PHP

Hi Friend, Today I will showing how to create visitor counter using php. it's easy to use any website. Its simple code just copy and past.

 

2:33 AM Share:

Voting System with Jquery PHP

Today I will showing, How to create Voting system without database using only php,jquery and txt file. I'ts easy to create any voting system.

Download Source Code : (this source code upload your server and run voating.php file)

7:23 AM 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:

How to make a custom language date and time

Today i will showing how to make a custom language data time system using php.

11:36 AM Share:

How to Create English day name to Farnch day name using php

Today i will showing how to covert english week name to covert any language week name using php.
it's simple way to create this function. 

7:55 AM 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: