I am very new with PHP...started doing this a few days ago to help someone and I need some help please. I have a webpage that is not displaying the records I want it to. The sql is correct, and I think the php code is correct to display the result, but php just "seems" to echo the php code that I have embedded in the page (maybe a type that I have missed). No errors seem to be happening, but it just does not display any records. Can anyone help please? -
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
-
<html xmlns="http://www.w3.org/1999/xhtml" >
-
<head>
-
<title>C&J`s Lawn Service</title>
-
<link href="main.css" rel="stylesheet" type="text/css" />
-
</head>
-
<body>
-
<div id="wrapper">
-
<div id="branding">
-
<img src="images/branding2.gif" alt="C&J's Lawn Care" />
-
</div>
-
<div id="navigation">
-
<ul>
-
<li class="first"><a href="index.html">Home</a></li>
-
<li><a href="enterjob.html">Enter Job</a></li>
-
<li><a href="services.html">Services</a></li>
-
<li><a href="contactus.html">Contact Us</a></li>
-
</ul>
-
</div>
-
<div id="body">
-
<p> All Jobs: </p>
-
<blockquote>
-
<?php
-
error_reporting(E_ALL);
-
ini_set('display_errors', True);
-
-
$host="localhost"; // Host name
-
$username="test"; // Mysql username
-
$password="test12"; // Mysql password
-
$db_name="testdb"; // Database name
-
$tbl_name="jobs"; // Table name
-
-
// Connect to server and select databse.
-
mysql_connect("$host", "$username", "$password")or die("cannot connect");
-
mysql_select_db("$db_name")or die("cannot select DB");
-
-
// Request the text of all the jobs
-
//$result=mysql_query("SELECT jobtype, jobdescription, phone FROM jobs j Join members m on m.id = j.userid Order By id desc");
-
-
$result=mysql_query("SELECT jobtype, jobdescription, phone FROM jobs j Join members m on m.id = j.userid Order By id desc", $link_id) or die('<hr />MySQL Error: ' .mysql_error(). '<hr />');
-
-
// Display the text of each job in a paragraph
-
while ( $row = mysql_fetch_array($result) )
-
{
-
echo("<p>Job: " . $row['jobtype'] . "</p>");
-
echo("<p>Description: " . $row['jobdescription'] . "</p>");
-
echo("<p>Phone: " . $row['phone'] . "</p>");
-
echo("<br />";
-
echo("<br />";
-
}
-
?>
-
</blockquote>
-
</div>
-
</body>
-
</html>
-
-
3  1506  Atli 5,058
Expert 4TB
Hi Mike. Welcome to The Scripts!
Is the PHP code just being displayed in the page like any other text?
If that is so, is it possible that the file is not a .php file? A normal .html file will not execute the PHP code, but treat it as text and display it.
Also, in your mysql_query() function, you use a variable called '$link_id' as a second parameter. I can't find this variable anywhere before that. Try removing it and see what happens.
That was it...thank you very much. I did not realize that the page had to have a php extension. Course, now that you pointed it out, it makes sense :)
Atli 5,058
Expert 4TB
I'm glad you got it working :)
Don't hesitate to post again if you have any more questions or problems we can help with.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Tim Graichen |
last post by:
Good morning,
I have a sub-form that displays records from a table as a continuous form.
The table has several hundred records, but the subform only displays five or
six records. The records do...
|
by: Matt K. |
last post by:
Hi there,
I have a form in an Access project that contains a subform which
displays the results of a query of the style "select * from
where = #a certain date#". In the main part of the form...
|
by: Robert |
last post by:
Hello Accessors
I have some reports created in Access that are very good for what they do.
However, it seems to me that when you are displaying information you don't
need to print out that a...
|
by: VM |
last post by:
When I display data to a Windows datagrid I usually fill the underlying
table (in another class) and then, once it contains all the data, I attach
it to the grid. But there are some processes that...
|
by: Johan Christensson |
last post by:
Hi.
Is there any other ways of displaying a webpage in an VB.Net form other then
using the "Microsoft Web Browser" object? Any third-party?
/Johan Ch
|
by: liberatingathena |
last post by:
I'm writing you from Alajuela, Costa Rica. It's 4:30 in the morning
here and I'm reaching a point of pure desperation as I've been
searching the internet all night for a solution. I am not an...
|
by: sureshreddy |
last post by:
hi friends,
I want the time to be displayed for a webpage to redirect to another webpage. You can see this concept in job sites when we fill all the details and click the search button it displays...
|
by: sushant2009 |
last post by:
Hi ,
I want to display empty databae table(actually table contains lot of records) to datagrid using dataset and dataadpter.
After displaying i will fill new records in datagrid and i will save...
|
by: sejal17 |
last post by:
hello everyone,
I have a problem with displaying records between two dates.Below is my designing page:
start date: combobox of month(smonth) & combobox of year(syear)
end date :...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |
