Create the database in MySQL
PHP with databases access, we have chosen MySQL database because it is free and also because it is the most widely used in UNIX environment. To this end, the server where the pages are hosted must provide us with tools to create the database or have access to Telnet.
The command to create a MySQL database is the following: mysqladmin -u root create data_base
To create the table you can use your web server's MySQL administration tool or you can write a text file with the content of the equivalent SQL and then indicate the database engine to execute it with the following instruction: mysql -u root base_datos <test.sql
Connection to the database
<html>
<head>
<title>PHP SWT Example</title>
</head>
<body>
<?php
function Connect()
{
if (!($link=mysql_connect("localhost","root","")))
{
echo "Error connecting to server.";
exit();
}
if (!mysql_select_db("base_datos",$link))
{
echo "Error Selecting database.";
exit();
}
return $link;
}
$link=Conectarse();
echo "Connection Success.<br>";
mysql_close($link); //cierra la conexion
?>
</body>
</html>
<head>
<title>PHP SWT Example</title>
</head>
<body>
<?php
function Connect()
{
if (!($link=mysql_connect("localhost","root","")))
{
echo "Error connecting to server.";
exit();
}
if (!mysql_select_db("base_datos",$link))
{
echo "Error Selecting database.";
exit();
}
return $link;
}
$link=Conectarse();
echo "Connection Success.<br>";
mysql_close($link); //cierra la conexion
?>
</body>
</html>
Querying the database
<?php
function Connect()
{
if (!($link=mysql_connect("localhost","root","")))
{
echo "Error connecting to server.";
exit();
}
if (!mysql_select_db("base_datos",$link))
{
echo "Error Selecting database.";
exit();
}
return $link;
}
?>
function Connect()
{
if (!($link=mysql_connect("localhost","root","")))
{
echo "Error connecting to server.";
exit();
}
if (!mysql_select_db("base_datos",$link))
{
echo "Error Selecting database.";
exit();
}
return $link;
}
?>
<html>
<head>
<title>PHP SWT Example</title>
</head>
<body>
<H1>Ejemplo de uso de bases de datos con PHP y MySQL</H1>
<?php
include("connection.phtml");
$link=Conect();
$result=mysql_query("select * from users",$link);
?>
<TABLE BORDER=1 CELLSPACING=1 CELLPADDING=1>
<TR><TD> ID</TD><TD> Username </TD></TR>
<?php
while($row = mysql_fetch_array($result)) {
printf("<tr><td> %s</td><td> %s </td></tr>", $row["id"],$row["username"]);
}
mysql_free_result($result);
mysql_close($link);
?>
</table>
</body>
</html>
<head>
<title>PHP SWT Example</title>
</head>
<body>
<H1>Ejemplo de uso de bases de datos con PHP y MySQL</H1>
<?php
include("connection.phtml");
$link=Conect();
$result=mysql_query("select * from users",$link);
?>
<TABLE BORDER=1 CELLSPACING=1 CELLPADDING=1>
<TR><TD> ID</TD><TD> Username </TD></TR>
<?php
while($row = mysql_fetch_array($result)) {
printf("<tr><td> %s</td><td> %s </td></tr>", $row["id"],$row["username"]);
}
mysql_free_result($result);
mysql_close($link);
?>
</table>
</body>
</html>
Inserting records to the database
<?php
include("connection.phtml");
$link=Conect();
$id=$_GET['id'];
$username=$_GET['username'];
mysql_query("insert into users(id,username) values ('$id','$username')",$link);
header("Location: thanks.phtml");
?>
include("connection.phtml");
$link=Conect();
$id=$_GET['id'];
$username=$_GET['username'];
mysql_query("insert into users(id,username) values ('$id','$username')",$link);
header("Location: thanks.phtml");
?>
No comments:
Post a Comment