CODE (htmlphp):
скопировать код в буфер обмена
скопировать код в буфер обмена
- <?php
- switch($_POST['type'])
- {
- case "SMPP":
- $tip=4;
- break;
- case "All":
- $tip=5;
- break;
- case "SMTP":
- $tip=9;
- break;
- case "HTTP":
- $tip=4;
- break;
- case "WEB":
- $tip=8;
- break;
- case "FTP":
- $tip=6;
- break;
- }
- function request ($tip) {
- $query = "
- SELECT baza.id AS id, clienttip AS
- TYPE , Name,
- TYPE AS Connection, Email
- FROM `baza`.`baza` , `baza`.`clienttip` , `baza`.`types`
- WHERE `types`.`id` = '$tip'
- LIMIT 10;
- ";
- $link = mysql_connect("127.0.0.1", "root" )
- or die("Could not connect : <br>" . mysql_error());
- mysql_set_charset('koi8r',$link);
- print "Connected successfully!";
- $result = mysql_query($query) or die("Query failed : " . mysql_error());
- retutn $result;
- }
- function viewer ($result) {
- print "\n<table border=1>\n";
- print "<tr>\t<td>ID</td>\n\t<td>Client type</td>\n\t<td>Name</td>\n\t<td>Client </td>\n\t<td>Connection type </td>\n\t<$
- \t<td>Email</td>\n</tr>\n$";
- $i=1;
- while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
- print "<tr>\n";
- echo "\t<td>$i</td>\n";$i++;
- foreach ($line as $col_value) {
- print "\t<td>$col_value </td>\n";
- }
- print "</tr>\n";
- }
- print "</table>\n";
- }
- ?>