mySQL and PHP search
Posted on
16th Feb 2014 07:03 pm by
admin
Hello,
I am trying to code a project and ran into a brick wall with one of my pages. I am pretty new at php/mySQL and can not figure this out. Now I know that you are not going to sit there and type my whole script out for me. That is NOT what I am asking. I need pointers, links to tutorials, or whatever help you can get me. I appreciate it very much!
First off, I am recoding a site I created a little while ago in pure HTML to php. This site is a help wanted site and it has had massive amounts of hits and requests to put up listings. I have the pages to submit a listing, write that to the database, and one to show the results in a raw format. However, I am running into two problems. One is that I want to code the main page to just be a mysql query. This means that I want it to show just the company name and position available, then have a button to click to get the rest of the info about the job listing in a separate pop-up window. I can not seem to find code, tut or anything of the like about this.
Second problem, in my raw data results (plan table showing database contents) I need a link that will remove the entry. I have tried a couple of scripts and messed up my code further. I was wondering if anyone knows of something that describes this is great detail. It is all in a table.
Here is some of my code for the table with the DB contents:
Code: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>View All Job Listings</title>
</head>
<body>
<?php
require 'dbconnect.inc';
mysql_select_db("coushatta", $con);
$result = mysql_query('SELECT * FROM jobs', $con);
echo "<table border='1'>
<tr>
<th>ID</th>
<th>Business Name</th>
<th>Contact Name</th>
<th>Phone Number</th>
<th>Fax Number</th>
<th>Email Address</th>
<th>Position Open</th>
<th>Open</th>
<th>Filled</th>
<th>Closed</th>
<th>Listing Content</th>
<th>Delete?</th>
</tr>";
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['ID'] . "</td>";
echo "<td><a href='" . $row['ID'] . ".html'>" . $row['business_name'] . "</a></td>";
echo "<td>" . $row['contact_name'] . "</td>";
echo "<td>" . $row['phone_number'] . "</td>";
echo "<td>" . $row['fax_number'] . "</td>";
echo "<td>" . $row['email_address'] . "</td>";
echo "<td>" . $row['position_open'] . "</td>";
echo "<td>" . $row['learnmore'];
if ( $row['learnmore'] == TRUE ) {
echo "";
} else {
echo "";
}
"</td>";
echo "<td>" . $row['filled'];
if ( $row['filled'] == TRUE ) {
echo "";
} else {
echo "";
}"</td>";
echo "<td>" . $row['closed'];
if ( $row['closed'] == TRUE ) {
echo "";
} else {
echo "";
}"</td>";
echo "<td>" . $row['listing_content'] . "</td>";
echo "</tr>";
}
echo "</table>";
mysql_close($con);
?>
</body>
</html>
No comments posted yet
Your Answer:
Login to answer
239 
47 
Other forums
mail with attachment problems
Hi. I have the following code:
Code: else if(file_exists("site".$timp.".zip")
All possible combinations of String in PL/SQL
Hi All,
Could you please explain the logic of getting all possible combinations of String
Parse Error
Hi Guys,
I have a function in my class which returns a string link variable. The problem is i
my login script page is not working on remote computers
hi my login is working on my computer, but when i tried 2 computers from 2 different locations, they
Shuffle Array
Hi,
I am writing a script for a game that needs players to randomly be assigned a target (ano
Query failed issue with php script but works fine in mssql manager!
hi i have the script below which copies data from one table to another but will only insert new data
Upload Code Help
Hi everyone I need some help with a bit of code ive been working with for a while. I am completely s
Displaying returned XML in another PHP page
I have an online payment form that will return XML given if a payment is successful or declines. I
Libraries in C++
Hi all,
I have two libraries. one is based targeted on linux platform and uses another li
mail() problem
Hi Guys,
I've set up a contact email form. It sends the information fine, but it sends it to
