January 2013 – Clecotech

Using Cookies with Authentication in PHP

January 6, 2013

Using Cookies with Authentication:<?php$cookie_name = “test”;$cookie_value = “string”;$cookie_expire = time()+10;$cookie_domain = “127.0.0.1”;$cookie_domain2 = “localhost”;setcookie($cookie_name, $cookie_value, $cookie_expire, “/” ,$cookie_domain, 0);setcookie($cookie_name, $cookie_value, $cookie_expire, “/” ,$cookie_domain2, 0);?><HTML><HEAD><TITLE>Set…

What are Cookies in PHP ?

January 6, 2013

What are Cookies ?Cookies are pieces of text that are sent to a user’s Web browser. Cookies can help you create shopping carts, user…

Displaying Data from MySql Database Table in PHP

January 6, 2013

Selecting and Displaying Data from MySql database table in php: <?php $con = mysql_connect(“localhost”,”peter”,”abc123″); if (!$con) { die(‘Could not connect: ‘ ….

Delete Data from Database Table in Mysql using PHP

January 6, 2013

Delete Data from Database Table in Mysql using PHP: <?php$con = mysql_connect(“localhost”,”root”,”root”);if (!$con) { die(‘Could not connect: ‘ . mysql_error()); }mysql_select_db(“db_name”, $con);mysql_query(“DELETE FROM Persons…

Insert Data into Database Table in MySql using PHP

January 6, 2013

Insert Data into Database Table in MySql using PHP:<?php$con = mysql_connect(“localhost”,”root”,”root”);mysql_select_db(“db_name”, $con);mysql_query(“INSERT INTO Persons (FirstName, LastName, Age)VALUES (‘Angry’, ‘Ashu’, ’35’)”); mysql_query(“INSERT INTO Persons (FirstName,…

Create Table in MySql using PHP

January 6, 2013

Create table in MySql using PHP: <?php $con = mysql_connect(“localhost”,”root”,”root”); mysql_select_db(“db_name”, $con); $sql = “CREATE TABLE Persons ( FirstName varchar(15), LastName varchar(15), Age int…

Deleting Database in MySql using PHP

January 6, 2013

Deleting Database in MySql using PHP: <? $sql = “DROP DATABASE testDB2”; $connection = @mysql_connect(“localhost”,”rot”,”root”)or die(mysql_error()); $result = @mysql_query($sql,$connection) or die(mysql_error()); if ($result) {…

Create New Database in My Sql using PHP

January 6, 2013

Create New Database in My Sql using PHP: <?php $sql = “CREATE database sexybabe_db”; $connection = mysql_connect(“localhost”,”root”,”root”); $query = mysql_query ($sql, $connection) or die(mysql_error());…

List Database and Tables from MySql in PHP

January 6, 2013

List Database and tables in PHP: <?php $connection = @mysql_connect(“localhost”,”root”,”root”) or die(mysql_error()); $dbs = @mysql_list_dbs($connection) or die(mysql_error()); $db_list = “<ul>”; $i = 0; while…

Establishing a Connection to MySql in PHP

January 6, 2013

Establishing a Connection to MySql using PHP: <? $connection = @mysql_connect(“localhost”, “root”, “root”) or die(mysql_error()); if($connection) { echo “Connection success!”; } ?>

M	T	W	T	F	S	S
	1	2	3	4	5	6
7	8	9	10	11	12	13
14	15	16	17	18	19	20
21	22	23	24	25	26	27
28	29	30	31