In Progress

Search PHP

Hello everyone,

I need to help with a PHP – MySQL project. I need 1 task performed.

1. In a page, I need a simple, small html form where people can select from certain options and then submit that into a results page in PHP. There is no need for any styling or anything like that, just simple, raw PHP code. The page will show results from a MySQL database. It will need to show 3 or 4 columns from 2 different tables (inside same DB). The database is already created, and everything is ready to just add the connection to the database and the PHP code.

I have a very limited budget, so please have that in mind. Also, I would like a second task performed, but please bid on the last task only and then send me a PM on how much would you charge me for both (I am not sure if I would be able to afford it).

The other task is:

2. In the next code lines, I am pulling information from one table, but I would like to be able to pull information from 2 tables, and then just be able to use variables (or other methods) to show the information through the website:

<?php

$id=$_GET['id'];

$hostname = "localhost";

$db_user = "HIDDEN";

$db_password = " HIDDEN ";

$database = " HIDDEN ";

$db = mysql_connect($hostname, $db_user, $db_password);

mysql_select_db($database) or die( "Unable to select database");

$query=" SELECT * FROM Hotels WHERE id='$id'";

$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

$i=0;

while ($i < $num) {

$name=mysql_result($result,$i,"hotel_name");

$swf=mysql_result($result,$i,"main_swf");

$p1=mysql_result($result,$i,"paragraph_1");

$p2=mysql_result($result,$i,"paragraph_2");

$p3=mysql_result($result,$i,"paragraph_3");

$am1=mysql_result($result,$i,"amenities_1");

$am2=mysql_result($result,$i,"amenities_2");

$i++;

}

?>

Thank you.

Skills: HTML, Javascript, MySQL, PHP

See more: php search, php html search, search php html, php id, php mysql connection, people search , am2, mysql code search, php form mysql page, php connection, task javascript php, php connection select, simple search javascript, javascript connection, mysql search table, mysql connection query, database connection php, php localhost, connection php mysql, php show information mysql, mysql search database table, form hidden submit, search next, php mysql database query, mysql database search form

About the Employer:
( 44 reviews ) Kissimmee, United States

Project ID: #1142167

Awarded to:

SerhiyVas

Hello! Please, check your PM Regards, Sergey

$30 USD in 1 day
(19 Reviews)
5.6

17 freelancers are bidding on average $44 for this job

netxpertindia

NetXpertIndia is a customer-specific service oriented company has got a Professional and creative team. We are the Professional Web Development Company having rich experience in Web design and development. Our team can More

$30 USD in 0 days
(77 Reviews)
6.6
jsr3

Please Check PMB.

$60 USD in 2 days
(56 Reviews)
6.3
developershut

HI, please check PMB

$100 USD in 1 day
(59 Reviews)
6.2
dracco

see your pmb please

$40 USD in 0 days
(141 Reviews)
5.9
SourceBurner

Please take a look at PMB. Regards

$30 USD in 1 day
(69 Reviews)
5.4
Wezigners

Ready to start

$90 USD in 2 days
(41 Reviews)
4.9
MakeYouBelieve

Hi, I can start right now. Please allow me help you. Regards.

$30 USD in 0 days
(38 Reviews)
4.6
casaucao

Dear Sir, please check your PM :-)

$40 USD in 1 day
(3 Reviews)
2.8
abhijuyallx

Please check pmb

$50 USD in 2 days
(1 Review)
1.4
eximo

Hi, please check your PMs.

$30 USD in 0 days
(0 Reviews)
0.0
swamis71

I have sent the details for second task on pm

$35 USD in 1 day
(0 Reviews)
0.0
ilantic

Ready to start. Please check PMB.

$30 USD in 0 days
(0 Reviews)
0.0
debasishw3tindia

Sir, please give us this project and you can check in our company profile

$50 USD in 15 days
(0 Reviews)
0.0
mohsinali1017

i have bid for the ist part. lets start right away.

$35 USD in 2 days
(0 Reviews)
0.0
dannybirch

Hey, willing to help you out. Also sent you a PM

$60 USD in 7 days
(0 Reviews)
0.0
dramin

Dramin web team is ready to start working on your project. Twenty years experience in general programming are best guarantee that your project will be finished successfully within projected timeframe. For details about More

$35 USD in 1 day
(0 Reviews)
2.8
threadnix

Hi, I am ready to help you in this project. I have experience in PHP and MySQL.

$30 USD in 3 days
(0 Reviews)
0.0
tareqdhk

Hi, Please check your PMB for details...

$30 USD in 0 days
(0 Reviews)
0.0