Write some Software
$10-30 USD
In Progress
Posted almost 8 years ago
$10-30 USD
Paid on delivery
I am trying to get the results of this to come out in table format also to get the email. The email is just a combo of the firstname + Lastname + @gmail. I can't figure it out. This code works but it only prints out the data with a ,.
$output ='';
//collect
if (isset($_POST ['search'])) {
$searchq = $_POST ['search'];
$searchq = preg_replace("#[^0-9a-z]#i","",$searchq);
$query = mysql_query("SELECT * FROM Emp_Dir WHERE FIRST_NAME LIKE '%$searchq%' OR LAST_NAME LIKE '%$searchq%' OR PHONE_NUMBER LIKE '%$searchq%'") or die("could not search!");
$count = mysql_num_rows ($query);
if($count == 0){
$output = 'There was no Search results!';
}else{
while($row = mysql_fetch_array ($query)) {
$FirstName = $row['FIRST_NAME'];
$LastName = $row['LAST_NAME'];
$PhoneNumber = $row['PHONE_NUMBER'];
$Email = $row["FIRST_NAME"+"LAST_NAME"];
$output .= '<div>'.$FirstName.','.$LastName.','.$PhoneNumber.'</div>';
}
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>Search</title>
</head>
<body>
<?php printf ("$output");?>
<table>
</table>
</body>
</html>
Project ID: 11068096
About the project
1 proposal
Remote project
Active 8 yrs ago
Looking to make some money?
Benefits of bidding on Freelancer
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
1 freelancer is bidding on average $25 USD for this job
0.6
0.6
About the client
Nampa, United States
43
Payment method verified
Member since Jul 21, 2016
Client Verification
Other jobs from this client
$30-250 USD
$30-250 USD
$30-250 USD
$10-30 USD
$250-750 USD
Similar jobs
₹37500-75000 INR
₹1500-12500 INR
$10-30 USD
₹12500-37500 INR
$8-15 USD / hour
€3000-5000 EUR
£750-1500 GBP
$10-30 USD
$12-30 SGD
$2-8 USD / hour
$750-1500 USD
₹600-5000 INR
$10-30 USD
$25-50 USD / hour
$8-15 USD / hour
₹1500-12500 INR
$250-750 CAD
₹600-1500 INR
€30-250 EUR
₹1500-12500 INR
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Copy to clipboard failed, please try again after adjusting your permissions.
Copied to clipboard.
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.