Search script
Ne conectam la mysql folosind urmatorul cod:
% mysql -u username_mysql -p
mysql>use baza_de_date;
Creem tabela in care vom introduce date
mysql>CREATE TABLE `tabela_mysql` (
>`id` int(11) NOT NULL,
>`continut` char(255) DEFAULT NULL,
>`name` char(255) DEFAULT NULL,
>`type` char(255) DEFAULT NULL,
>`size` int(11) DEFAULT NULL,
>`nume` char(255) DEFAULT NULL,
>`prenume` char(255) DEFAULT NULL,
>`media` char(255) DEFAULT NULL,
>PRIMARY KEY (`id`)
>) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
Pentru a vedea tabela creata de noi putem folosi describe sau forma scurta din patru litere desc
mysql> desc tabela_mysql ;
+----------+-----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+-----------+------+-----+---------+-------+
| id | int(11) | NO | PRI | NULL | |
| continut | char(255) | YES | | NULL | |
| name | char(255) | YES | | NULL | |
| type | char(255) | YES | | NULL | |
| size | int(11) | YES | | NULL | |
| nume | char(255) | YES | | NULL | |
| prenume | char(255) | YES | | NULL | |
| media | char(255) | YES | | NULL | |
+----------+-----------+------+-----+---------+-------+
8 rows in set (0.03 sec)
Pentru a introduce date in tabela noastra vom folosi urmatoarea instructiune de introducerea datelor. Prin aceasta comanta selectam doar coloanele in care dorim sa introducem date. Id pentru ca este cheie primara este introdus automat de catre sistem.
insert into tabela_mysql set continut="fisier",name="Tutorial de Instalare FreeBSD",type="video",size=1024,
nume="Charly",prenume="Root",media="video.flv";
Conectare seleactarea bazei de date din PHP. Aceasta bucata de cod poate fi introdusa intr-o pagina separata si adaugata in orice pagina in care folositi datele din mysql.
<?php $con = mysql_connect("localhost","username_mysql","parola_mysql"); $db = mysql_select_db("baza_de_date", $con); ?> |
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><title>Formular</title><script type="text/javascript" src="script.js"></script><link rel="stylesheet" href="style.css" type="text/css" /><style type="text/css">#articol{margin:20px 0;}</style></head><body><h1>Cautare</h1><div class="search"> <form id="formsearch" action="" method="get"> <p><label for="search">Search : </label> <input id="search" type="text" name="s" /></p> <p><input id="submit" type="submit" value="Cauta" /></p> </form></div> |
<?php if(isset($_GET['s'])){?><div id="search_output"><?php |
$search = htmlentities(stripslashes($_GET['s']));$sql='select continut,name,type,size,nume,prenume,media from tabela_mysql where continut like "%'.$search.'%" or name like '%'.$search.'%" or nume like "%'.$search.'%" or prenume like "%'.$search.'%" or media like "%'.$search.'%"'; |
$exe = mysql_query($sql,$con);$row = mysql_fetch_array($exe);while($row){$continut = $row[0];$name = $row[1];$type = $row[2];$size = $row[3];$nume = $row[4];$prenume = $row[5];$media = $row[6];?><div class="articol"> <p><strong>Continut:</strong><?php echo $continut; ?></p> <p><strong>Name:</strong><?php echo $name; ?></p> <p><strong>Type - size:</strong><?php echo $type." - ".$size; ?></p> <p><strong>Nume - prenume:</strong><?php echo $nume." - ".$prenume; ?></p> <p><strong>Media:</strong><?php echo $media; ?></p></div><?php } ?></div><!-- terminare search_output--!><?phpmysql_close($con);} ?> |
download Search Script SOSA
You can follow any responses to this entry through the
RSS 2.0 feed.You can
leave a response, or
trackback from your own site.