This is my first time working with php and databases and I would like some advice trying to connect them.

This is my database table fields

http://www.tarantuladatabase.com/tf.jpg

This is my field values

http://www.tarantuladatabase.com/fv.jpg

I am using two php files one of them is called connect.php and it only has the information to connect to my database. The other files is called echo.php. The form is at

http://www.tarantuladatabase.com/***...es/search.html

When I try and connect I am getting this error message

Warning: include(includes/connect.php) [function.include]: failed to open stream: No such file or directory in /home/e0120590/public_html/tarantuladatabase.com/assets/php/echo.php on line 38

Warning: include() [function.include]: Failed opening 'includes/connect.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/e0120590/public_html/tarantuladatabase.com/assets/php/echo.php on line 38

Warning: mysql_query() [function.mysql-query]: Access denied for user 'e0120590'@'localhost' (using password: NO) in /home/e0120590/public_html/tarantuladatabase.com/assets/php/echo.php on line 40

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/e0120590/public_html/tarantuladatabase.com/assets/php/echo.php on line 40

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/e0120590/public_html/tarantuladatabase.com/assets/php/echo.php on line 43

Warning: mysql_close(): no MySQL-Link resource supplied in /home/e0120590/public_html/tarantuladatabase.com/assets/php/echo.php on line 48

I am kinda stuck right here so any advice would be greatly appreciated.

I know its just bad php coding on my part but i'm not sure where. Is my connect.php file working like it should?

Here are the files I'm working with http://www.tarantuladatabase.com/3_Files.zip

Can we see the code that you are using. It looks like the username/password combo is not correct for your database.

I am using the user name tester and the password forum.

It was the file path.

Now I have a new error message.

Well I think from here the problems are in my echo.php file.

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/e0120590/public_html/tarantuladatabase.com/assets/php/echo.php on line 43

That does seem to be your problem. If you post your PHP code then we can actually give you some helpful help =)

I really haven't learned what goes in the echo.php file yet so I really don't have anything it. I was mostly just trying to make sure that the connect.php file was working.

Don't get me wrong I would love to here your advice on what my next step should be. I have a feeling its a lot of php code reading but if you have any examples that I could see that would be very helpful.

<?
include("connect.php");
// now you are connected and can query the database
$request = mysql_query("select field1,field2 from table");

// loop through the results with mysql_fetch_array()
while($row = mysql_fetch_array($result)){
echo $row[0]." / ".$row[1]."<br>\n";
}

// don't forget to close the mysql connection
mysql_close();
?>

Well, the problem seems to be your while loop...you have $result when it should be $request.

include("connect.php");
// now you are connected and can query the database
$request = mysql_query("select field1,field2 from table");

// loop through the results with mysql_fetch_array()
while($row = mysql_fetch_array($request)){
  echo $row[0]." / ".$row[1]."<br>\n";
}

// don't forget to close the mysql connection
mysql_close();
?>

Thanks so much for the help

This phase of my tarantula database project has really slowed everything down. Learning PHP code is way more difficult than setting up the database.

I am trying to match my php code up with the form found here. http://www.tarantuladatabase.com/***...es/search.html The big problem is that I've done so much guess work with the database that I'm not sure if its even set up like I need it to be.

But aside from that I have a php file called connect.php that is working and connecting to my database after my file path issue got in order. I also have a file called echo.php that contains my non working php code.

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/e0120590/public_html/tarantuladatabase.com/assets/php/echo.php on line 43

This is my php code

<?
include("connect.php");
// now you are connected and can query the database
$request = mysql_query("select field1,field2 from table");
 
// loop through the results with mysql_fetch_array()
while($row = mysql_fetch_array($request)){
  echo $row[0]." / ".$row[1]."<br>\n";
}
 
// don't forget to close the mysql connection
mysql_close();
?>

Its just a copy and paste gig I got off of some php link I was reading. All i changed was the path to my connect.php file and the $results to $request so I expected the errors and now..

I'm just trying to find out if my database has enough information in it to even be search able? http://www.tarantuladatabase.com/fv.jpg and what I need to do to get my php file talking to it?

Any advice or links or anything to point me on the right track would be great. I have been reading and trying to learn php but its really confusing me hehe

It doesn't matter about the size of the table. 1 result or 1000 results, you can still search for specific results and display them. I would also suggest some type of message if the results equal 0.

$count = mysql_num_rows($request);
if ($count == 0)
{
echo "There are no results to display. Try your search again.";
}

* 1 / Arboreal
2 / Terrestrial
3 / Fossorial
4 /

I made this happen lol but not sure what it means


and here is my new code

<?
include("connect.php");
// now you are connected and can query the database
$query = "SELECT * FROM `common_traits` `habitat``humidity``speed``size``location``aggression`";
$request = mysql_query($query);
if($request == false)
{
   user_error(mysql_error() . "<br />\n$query");
}

// loop through the results with mysql_fetch_array()
while($row = mysql_fetch_array($request)){
  echo $row[0]." / ".$row[1]."<br>\n";
}

// don't forget to close the mysql connection
mysql_close();
?>

Where do I put that code?

I am reading stuff and making some progress but it's just not added up. Nothing I have read tells me how to make my from do work.

I copyed the code off of a page I was reading that tells me how to code php i'm kinda picking stuff up bit by bit so i'm really thankful for any help you can give me. I think I learn code better when I can see an example of what should be happening.

Try this:

<?
include("connect.php");
// now you are connected and can query the database
$query = "SELECT * FROM `common_traits` `habitat``humidity``speed``size``location``aggression`";
$request = mysql_query($query);
if($request == false)
{
   user_error(mysql_error() . "<br />\n$query");
}
// Count rows
$count = mysql_num_rows($request);
if ($count == 0)
{
echo "There are no results to display.";
}
// loop through the results with mysql_fetch_array()
while($row = mysql_fetch_array($request)){
  echo $row['fieldname']." / ".$row['fieldname]."<br>\n";
}

// don't forget to close the mysql connection
mysql_close();
?>

The count function will count the number of row and if 0 is found, it will display a message. Also, I have adjusted the code that displays your results. I use this because it is easier to know exactly which rows are being displayed. Just change it from fieldname to your actually name (ie. habitat, humidity, etc.)

The $count variable can also be used to display the number of results that were found, if you want to go that route.

echo "There were ".$count."results found.";

I think i got it??? I think it got it http://www.tarantuladatabase.com/***...es/search.html