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>
<!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>
<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";
?>
<?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:
<?
$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..."; }
?>
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