note 60859 added to ref.msql
| From: | johnny at freemail dot hu | Date: | Wed, 18 Jan 2006 16:47:25 +0000 |
| Subject: | note 60859 added to ref.msql | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-102033@lists.php.net to get a copy of this message | ||
<?php
// kakpcsolat létrehozása
$kapcsolat = mysql_connect("localhost", "gepesz", "gepesz");
mysql_select_db("gepesz",$kapcsolat);
// az űrlap POST metódussal küldte el az adatokat; ezt így lehet leszedni: $valtozo =
$_POST['urlapadat'];
$magyarszo = $_POST['magyarszo'];
// lekérdezés az adatbázisból
$select = mysql_query("select * from szotar where magyar like '%$magyarszo%' order by
magyar, angol");
// változóba tárolja, hány sorból áll a lekérdezés
$sor = mysql_num_rows($select);
// kiírja hány sorból áll a lekérdezés
echo ("<p align='center'>$sor szót találtam");
// létrehozza a html táblát a listázáshoz
echo ("<table border='1' align='center' cellspacing='2'
cellpadding='2'>");
// fejléc
echo ("<tr><td align='center'><b>magyar</b></td><td
align='center'><b>angol</b></td>");
while ( $sor = mysql_fetch_array($select) ) {
$magyar = $sor['magyar'];
$angol = $sor['angol'];
echo ("<tr><td align='center'>$magyar</td><td
align='center'>$angol</td></tr>");
}
/*
echo ("</table></p>");
*/
?>
----
Server IP: 64.246.30.37Probable Submitter: 88.209.192.25
----
Manual Page -- http://www.php.net/manual/en/ref.msql.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+60859
Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+60859&report=yes&reason=added+to+the+manual
Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+60859&report=yes&reason=bad+code
Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+60859&report=yes&reason=spam
Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+60859&report=yes&reason=useless
Delete: non-english -- http://master.php.net/manage/user-notes.php?action=delete+60859&report=yes&reason=non-english
Delete: already in docs -- http://master.php.net/manage/user-notes.php?action=delete+60859&report=yes&reason=already+in+docs
Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+60859&report=yes
Reject -- http://master.php.net/manage/user-notes.php?action=reject+60859&report=yes
Search -- http://master.php.net/manage/user-notes.php