mysqli connection adobe dreamweaver cs5

Outline

Mysqli Connection via PHP

Create PHP file connection to connect database.

DB connection via Dreamweaver.

By: Eng\ Mohammed Hussein 2

http://localhost/


Mysql and Mysqli

The Mysql_* and Mysqli_* family of functions were both

created to give a programmer methods of interacting with a

MySQL database using PHP.

For instance, when we want to connect to MySQL and open

communication to it, we use mysqli_connect. Then to close

that same connection we use musqli_close Not very

complicated.

After added Mysqli family of functions with PHP5, it has

improved efficiency, speed, code, security and interfacing due

to the way the new model is structured.


http://localhost/phpmyadmin/


Login to phpDb Database


PHP file Connection

Create PHP file connection to connect database


PHP Sessions

<?php

session_start();

if(isset($_SESSION['views']))

$_SESSION['views']=$_SESSION['views']+1;

else

$_SESSION['views']=1;

echo "Views=". $_SESSION['views'];

?>

<html>

<body>

<br>

<?php

echo "This is inside PHP<br>";

echo "Hello World!<br>";

$q= "How Are You Every Body?";

Echo $q;

?>

</body>

</html>

F5

Google Chrome

1

2

8By: Eng\ Mohammed Hussein

Include PHP file connection & Query

Calling php file connection inside index.php code.


Query calling back

Using $body variable inside index.php code


DB connection via Dreamweaver


Recordset using Dreamweaver


Import data using Dreamweaver


References

1) http://www.w3schools.com/php/php_ref_string.asp

2) http://www.w3schools.com/php/php_looping.asp

14By: Eng\ Mohammed Hussein

http://www.w3schools.com/php/php_ref_string.asp



http://www.w3schools.com/php/php_looping.asp



mysqli connection adobe dreamweaver cs5

Education