<?php
if ($_SERVER['REQUEST_METHOD'] == 'POST'){
$getLima=$_POST['Onoma'];
include "connect.php";
$rsSelectOnomata=mysql_query("SELECT * FROM titloslimmatos WHERE LimmatikosTypos='$getLima'");
//$result=mysql_query($query);
while($rsRow=mysql_fetch_assoc($rsSelectOnomata)) {
echo $rsRow[titloslimmatos.LimmatikosTypos];
$rsRow[titloslimmatos.MerosLogoy];
$rsRow[titloslimmatos.YfologikoEpipedo];
$rsRow[titloslimmatos.GlwssikoEpipedo];
//$rsRow[extralimmatikoitypoi.ExtraLimmatikosTypos];
//$rsRow[extralimmatikoitypoi.YfologikoEpipedo];
//$rsRow[Simasia.XrisiLeksis];
//$rsRow[synonimo.Synonimo];
//$rsRow[synonimo.Example];
//$rsRow[antitheto.Antitheto];
//$rsRow[antitheto.Example];
}
}
else {
?>
<html>
<body bgcolor="#FFFFCC">
<h3><center><b>Δώστε το λήμμα που ψάχνετε</b></center></h3>
<table>
<form method="post" action="<? echo $PHP_SELF ?>">
<input name="onoma" type="text">
<input type="Submit" name="set" >
</form>
</table>
</body>
</html>
<?
}
?>
anna05 0 Newbie Poster
Recommended Answers
Jump to PostPrint and execute the query in phpmyadmin / mysql console. Check the error message.
OR
Use$rsSelectOnomata=mysql_query("SELECT * FROM titloslimmatos WHERE LimmatikosTypos='$getLima'") or die(mysql_error());This will print the error message on failure. This is good for testing purpose (and not in the production environment as it exposes …
Jump to PostYeah. You don't have
mysql_select_db("Databasename");in your script.
Jump to PostWhy oh why did I even bother writing the FAQ that answers this very issue if no one is going to read it? It never stops baffling me when I see these posts.
Jump to PostLine 16 has echo, but lines 17 to 26 not. if php is in safe mode the error not appear, only show a blank page. May be this help.
This actually isn't an error, it just won't do anything. Those are completely valid statements (like I said, they just don't …
All 13 Replies
Will Gresham 81 Master Poster
Might help to state what the problem is. I don't want to sit here looking through your code without knowing what I am looking for.
Also, use code tags.
anna05 0 Newbie Poster
i want to make a site on line dictionary, i use the programm xampp,
when i run this code (localhost) and insert a word that exist in my database the result is a blank page...
can someone help me? its emergency!
also sometimes when i run this code it's show me:
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\index.php on line 12
nav33n 472 Purple hazed! Team Colleague Featured Poster
Print and execute the query in phpmyadmin / mysql console. Check the error message.
OR
Use
$rsSelectOnomata=mysql_query("SELECT * FROM titloslimmatos WHERE LimmatikosTypos='$getLima'") or die(mysql_error());This will print the error message on failure. This is good for testing purpose (and not in the production environment as it exposes your table structure and all that!)
Will Gresham 81 Master Poster
What nav33n said.
Also, if you want to search for values which I guess you will do for a dictionary, look into the LIKE operator for your SQL query.
anna05 0 Newbie Poster
index.php
<?php
if ($_SERVER['REQUEST_METHOD'] == 'POST'){
$getLima=$_POST['Onoma'];
include "connect.php";
$rsSelectOnomata=mysql_query("SELECT * FROM titloslimmatos WHERE LimmatikosTypos='$getLima'") or
die(mysql_error());
$result1=mysql_query($query);
while($rsRow=mysql_fetch_assoc($rsSelectOnomata)) {
echo $rsRow[titloslimmatos.LimmatikosTypos];
$rsRow[titloslimmatos.MerosLogoy];
$rsRow[titloslimmatos.YfologikoEpipedo];
$rsRow[titloslimmatos.GlwssikoEpipedo];
//$rsRow[extralimmatikoitypoi.ExtraLimmatikosTypos];
//$rsRow[extralimmatikoitypoi.YfologikoEpipedo];
//$rsRow[Simasia.XrisiLeksis];
//$rsRow[synonimo.Synonimo];
//$rsRow[synonimo.Example];
//$rsRow[antitheto.Antitheto];
//$rsRow[antitheto.Example];
}
}
else {
?>
<html>
<body bgcolor="#FFFFCC">
<h3><center><b>Δώστε το λήμμα που ψάχνετε</b></center></h3>
<table>
<form method="post" action="<? echo $PHP_SELF ?>">
<input name="onoma" type="text">
<input type="Submit" name="set" >
</form>
</table>
</body>
</html>
<?
}
?>-------------------------------------------------------------
connect.php
<?php
$link = mysql_connect('localhost', 'root', '');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>when i run the file index.php the result was:
Connected successfully No database selected
any idea please?
nav33n 472 Purple hazed! Team Colleague Featured Poster
Yeah. You don't have mysql_select_db("Databasename"); in your script.
ShawnCplus 456 Code Monkey Team Colleague
Why oh why did I even bother writing the FAQ that answers this very issue if no one is going to read it? It never stops baffling me when I see these posts.
anna05 0 Newbie Poster
sorry.. that was by mistake...
the code of connect.php is:
<?php
$link = mysql_connect('localhost', 'root', '');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_select_db("annadb");
//mysql_close($link);
?>i run again the file index.php and the result was:
Connected successfully
whay it doesn't show me the word that i insert?
nav33n 472 Purple hazed! Team Colleague Featured Poster
Why oh why did I even bother writing the FAQ that answers this very issue if no one is going to read it? It never stops baffling me when I see these posts.
;) Newbies prefer to skip the first post I believe ! Sigh.
nav33n 472 Purple hazed! Team Colleague Featured Poster
sorry.. that was by mistake...
the code of connect.php is:
<?php $link = mysql_connect('localhost', 'root', ''); if (!$link) { die('Could not connect: ' . mysql_error()); } echo 'Connected successfully'; mysql_select_db("annadb"); //mysql_close($link); ?>i run again the file index.php and the result was:
Connected successfullywhay it doesn't show me the word that i insert?
Okay! Now I am totally lost. Where are you inserting the values ? Check this link. I hope that link will answer your question.
And pleaseee(eee). Wrap your code in [code=php] code here [/code] tags.
artsist 0 Newbie Poster
Line 16 has echo, but lines 17 to 26 not. if php is in safe mode the error not appear, only show a blank page. May be this help.
ShawnCplus 456 Code Monkey Team Colleague
Line 16 has echo, but lines 17 to 26 not. if php is in safe mode the error not appear, only show a blank page. May be this help.
This actually isn't an error, it just won't do anything. Those are completely valid statements (like I said, they just don't do anything)
anna05 0 Newbie Poster
You help me very much...
Thanks a lot all of you....!!!
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.