[ define @ 28.01.2005. 16:59 ] @
Operativni sistem je WINDOWS Apache server apache_1.3.27-win32-x86-no_src php php-4.2.3-Win32 mysql je mysql-3.23.52-win sve instalirano kako treba i radi. Php scriptovi rade, ali je problem kada pozivam mysql bazu. "NE ODAZIVA SE" evo kodova Code: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML> <HEAD> <TITLE>Knjizara O - RAMA katalog</TITLE> <META NAME="Generator" CONTENT="EditPlus"> <META NAME="Author" CONTENT=""> <META NAME="Keywords" CONTENT=""> <META NAME="Description" CONTENT=""> </HEAD> <BODY> <h1>Book-O-Rama Katalog pretraga</h1> <form action="results.php" method="post"> Izaberi tip pretrage:<br/> <select name="searchtype"> <option value="author">Autor</option> <option value="title">Naziv</option> <option value="isbn">ISBN</option> </select> <br/> Unesi rec za pretragu:<br/> <input name="searchterm" type="text"> <br/> <input type="submit" value="Search"> </form> </BODY> </HTML> ovo je search.html a evo i koda koji se poziva Code: <html> <head> <title>Book-O-Rama</title> </head> <body> <h1>Rezultati pretrage</h1> <?php $searchtype=$HTTP_POST_VARS['searchtype']; $searchterm=$HTTP_POST_VARS['searchterm']; $searchterm= trim($searchterm); if(!$searchtype || !$searchterm) { echo 'Niste uneli detalje za pretragu'. 'Molimo Vas vratite se na prethodnu stranu i pokusajte ponovo.'; exit; } $searchtype=addslashes($searchtype); $searchterm=addslashes($searchterm); @ $db = mysql_pconnect('localhost','root','lozinka'); if (!$db) { echo 'Error: Niste se konektovali sa bazom podataka.'. 'Molimo Vas pokusajte kasnije'; exit; } mysql_select_db('books'); $query="select * from books where ".$searchtype. "like '%".$searchterm."%'"; $result=mysql_query($query); $num_results=mysql_num_rows($result); echo '<p>Broj knjiga koje su nadjene:'.$num_results.'</p>'; for ($i=0; $i <$num_results; $i++) { $row=mysql_fetch_array($result); echo '<p><strong>'.($i+1).'.Title:'; echo htmlspecialchars(stripslashes($row['title'])); echo '</strong><br/>Autor: '; echo stripslashes($row['autor'])'; echo '<br/>ISBN: '; echo stripslashes($row['isbn'])'; echo '<br/>Cijena'; echo stripslashes($row['price'])'; echo '</p>'; } ?> </body> </html> Problem je sto se nista ne desava. Korisnik je root, a sifra je lozinka nece da radi, ne znam zasto. Kada se logujem na mysql preko comand prompta onda hoce da radi. kucam use books; describe books; i ono izlista sve podatke. Znaci sve je uredu, ali nesto nece da reaguje. Pokusavao sam i neke obicne test scripte za mysql, ali samo ovaj radi Code: <?php mysql_connect("localhost","root","lozinka") or die("Uh Oh, Could not connect"); $Version = mysql_get_server_info(); $HostInfo = mysql_get_host_info(); print "My current MySQL version is: $Version<br>On $HostInfo"; ?> Cim pozovem bazu javlja se greska evo koda kod koga mi se takodje javlja greska Code: a greska je You have an error in your SQL syntax near 'database' at line 1<? $connect = mysql_connect("localhost","knjizara","knjizara123") or die(mysql_error()); mysql_select_db("books") or die(mysql_error()); // trying select statement $query = "SELECT * FROM database"; $do = mysql_query($query) or die(mysql_error()); if(!$do) { echo "ups"; } else { echo "select statement works..."; } ?> POMOC |