Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $name;
- if(isset($_REQUEST['surname'])) {
- $name = $_REQUEST['surname'];
- } else {
- echo "podaj cos <br>";
- }
- $Host='127.0.0.1';
- $DBase='oswiata';
- $FUser='root';
- $FPass='';
- function polacz( $host,$dbase,$user, $pass ) {
- @$pol=mysql_connect( $host, $user, $pass );
- if( !$pol ) {
- echo 'BÅ‚ad polaczenia z Serwerem Bazy Danych';
- exit();
- } else {
- @mysql_select_db( $dbase );
- if( mysql_errno() ) {
- echo mysql_errno() . ': '. mysql_errno();
- echo mysql_error();
- exit();
- }
- }
- return $pol;
- }
- $idpol=polacz($Host, $DBase, $FUser, $FPass);
- @$wyniki=mysql_db_query($DBase, "SELECT * FROM pracownicy WHERE nazwisko like '$name%'", $idpol);
- if( $wyniki ) {
- $index = 0;
- echo "<table border=1>";
- while($wiersz=mysql_fetch_row($wyniki)) {
- $color;
- if ($index%2 == 0) {
- $color = "#dcdde5";
- } else {
- $color = "#c0c6e0";
- }
- $index++;
- echo "<tr style=\"background-color: $color\">";
- echo "<td>$wiersz[0]</td><td>$wiersz[1]</td><td>$wiersz[2]</td><td>$wiersz[3]</td><td>$wiersz[4]</td>";
- echo "</tr>";
- }
- echo "</table>";
- } else {
- echo "Brak";
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement