Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- <meta http-equiv="content-type" content="text/html; charset=utf-8">
- </head>
- <title>Telefoniraamat</title>
- <body>
- <?php
- $user = "a2152177_user";
- $pass = "password1";
- $host = "mysql15.000webhost.com";
- $con = mysql_connect($host, $user, $pass);
- mysql_select_db("a2152177_db", $con);
- $mode = "";
- $order = false;
- if ($_GET)
- {
- if (array_key_exists('mode', $_GET)) $mode = $_GET['mode'];
- if (array_key_exists('id', $_GET)) $id = $_GET['id'];
- if (array_key_exists('order', $_GET)) $order = $_GET['order'];
- }
- if ($_POST)
- {
- switch($_POST['mode'])
- {
- case "muudetud":
- mysql_query("UPDATE Telefoniraamat
- SET Eesnimi='$_POST[ees]', Perenimi='$_POST[pere]' ,Telefon='$_POST[tel]'
- WHERE id=$_POST[id]");
- break;
- case "lisatud":
- mysql_query("INSERT INTO Telefoniraamat (Eesnimi, Perenimi, Telefon)
- VALUES ('$_POST[ees]','$_POST[pere]','$_POST[tel]')");
- break;
- case "otsing":
- $mode = "otsing";
- $tükid = "";
- $tükk = strtok($_POST['otsi'], " ");
- while($tükk != false)
- {
- $tükid .= "'$tükk',";
- $tükk = strtok(" ");
- }
- $tükid = strrev(substr(strrev($tükid), 1));
- $andmed = mysql_query("SELECT * FROM Telefoniraamat WHERE
- Eesnimi IN ($tükid) OR Perenimi IN ($tükid)");
- if (mysql_num_rows($andmed) != 0) teeTabel($andmed, false);
- else print "Ei leitud ühtki tulemust";
- ?><br />
- <a href=<?=$_SERVER['PHP_SELF'];?>>Tagasi</a><?
- break;
- default:
- break;
- }
- }
- if ($order != false)
- $andmed = mysql_query("SELECT * FROM Telefoniraamat ORDER BY $order");
- else
- $andmed = mysql_query("SELECT * FROM Telefoniraamat");
- switch($mode)
- {
- case "otsing";
- break;
- case "muuda":
- $andmed = mysql_query("SELECT * FROM Telefoniraamat WHERE id=$id");
- $rida = mysql_fetch_array($andmed);
- ?>
- <form action=<?=$_SERVER['PHP_SELF'];?> method="post">
- <input type="hidden" name="mode" value="muudetud" />
- <input type="hidden" name="id" value=<?=$id;?> />
- <table border="0" width="400">
- <tr>
- <td width="200"><b>MUUTMINE:</b></td>
- </tr>
- <tr>
- <td>Eesnimi:</td>
- <td><input type="text" name="ees" value="<?print $rida['Eesnimi'];?>" /></td>
- </tr>
- <tr>
- <td>Perenimi:</td>
- <td><input type="text" name="pere" value="<?print $rida['Perenimi'];?>" /></td>
- </tr>
- <tr>
- <td>Telefon</td>
- <td><input type="text" name="tel" value="<?print $rida['Telefon'];?>" /></td>
- </tr>
- <tr>
- <td><input type="submit" value="Muuda!" /></td>
- </tr>
- </table>
- </form>
- <?
- break;
- case "kustutatud":
- mysql_query("DELETE FROM Telefoniraamat WHERE id=$_GET[id]");
- header("location: $_SERVER[PHP_SELF]");
- break;
- default:
- teeTabel($andmed);
- ?>
- <form action=<?=$_SERVER['PHP_SELF'];?> method="post">
- <input type="hidden" name="mode" value="lisatud" />
- <table border="0" width="500">
- <tr>
- <td width="300"><b>LISAMINE:</b></td>
- </tr>
- <tr>
- <td>Eesnimi:</td>
- <td><input type="text" name="ees" /></td>
- </tr>
- <tr>
- <td>Perenimi:</td>
- <td><input type="text" name="pere" /></td>
- </tr>
- <tr>
- <td>Telefon</td>
- <td><input type="text" name="tel" /></td>
- </tr>
- <tr>
- <td><input type="submit" value="Lisa!" /></td>
- </tr>
- <tr><td><br /></td></tr>
- <tr>
- <td colspan="2"><hr /></td>
- </tr>
- </table>
- </form>
- <form action=<?=$_SERVER['PHP_SELF'];?> method="post">
- <input type="hidden" name="mode" value="otsing" />
- <b>OTSIMINE:</b>
- <input type="text" name="otsi" />
- <input type="submit" value="Otsi!" />
- </form>
- <?
- break;
- }
- function teeTabel($data, $funkt = true)
- {
- if ($funkt == true)
- {?>
- <table border="0" width="500">
- <tr style="background-color:LightGrey">
- <td><a href=<?=$_SERVER['PHP_SELF'];?>?order=Eesnimi>Eesnimi</a></td>
- <td><a href=<?=$_SERVER['PHP_SELF'];?>?order=Perenimi>Perenimi</a></td>
- <td><a href=<?=$_SERVER['PHP_SELF'];?>?order=Telefon>Telefon</a></td>
- <td colspan="2">Funktsioonid</td>
- </tr><?
- }
- else
- {?>
- <table border="0" width="500">
- <tr style="background-color:LightGrey">
- <td>Eesnimi</td>
- <td>Perenimi</td>
- <td>Telefon</td>
- <td colspan="2">Funktsioonid</td>
- </tr><?
- }
- $x = 0;
- while($rida = mysql_fetch_array($data))
- {
- if ($x % 2 == 0)
- $color = "WhiteSmoke";
- else
- $color = "White";
- ?>
- <tr style='background-color:<?=$color;?>'>
- <td><?=$rida['Eesnimi'];?></td>
- <td><?=$rida['Perenimi'];?></td>
- <td><?=$rida['Telefon'];?></td>
- <td><a href=<?=$_SERVER['PHP_SELF'];?>?mode=muuda&id=<?=$rida['id'];?>>[muuda]</a></td>
- <td><a href=<?=$_SERVER['PHP_SELF'];?>?mode=kustutatud&id=<?=$rida['id'];?>>[kustuta]</a></td>
- </tr>
- <?
- $x += 1;
- }?>
- <tr>
- <td colspan="5"><hr /></td>
- </tr>
- </table>
- <?
- }
- mysql_close($con);?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement