With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
Course Of The Month
9 days, 7 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
How to create a Hyperlink using MYSQL data to be passed into a url
Posted on 2011-03-09
Hi Experts,
What im trying to do is
Make some data from mysql into a hyperlink so when the hyperlink is pressed sends the hyperlink for example "0777777777" into the array and would then direct onto the next page.
so the url once the link is clicked would be something like
http://localhost/billing.php?val=07777777777
how would i make the 077777777 retrieved from the database into a link which sets as a variable?
this is what ive got so far. see attached
Many thanks for your help
What im trying to do is
Make some data from mysql into a hyperlink so when the hyperlink is pressed sends the hyperlink for example "0777777777" into the array and would then direct onto the next page.
so the url once the link is clicked would be something like
http://localhost/billing.php?val=07777777777
how would i make the 077777777 retrieved from the database into a link which sets as a variable?
this is what ive got so far. see attached
Many thanks for your help
<?php
error_reporting(E_ALL);
include 'myphp.php';
$val = $_GET['val'];
$sql = "SELECT * FROM customer_details WHERE customer_name = '" . $val . "'";
$result = mysql_query($sql) or die(mysql_error() . " IN $sql");
$rs = mysql_query($sql);
while($row = mysql_fetch_array($rs))
{
echo"<table>";
echo "<tr><td>Customer:</td><td>".$row['customer_name']."</td></tr>";
echo "<tr><td>Mobile Number:</td><td>".$row['mobile_number']."</td></tr>";
echo"</table>";
}
?>
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3
4 Comments
Try this:
<?php
error_reporting(E_ALL);
include 'myphp.php';
$val = $_GET['val'];
$sql = "SELECT * FROM customer_details WHERE customer_name = '" . $val . "'";
$result = mysql_query($sql) or die(mysql_error() . " IN $sql");
$rs = mysql_query($sql);
while($row = mysql_fetch_array($rs))
{
echo"<table>";
echo "<tr><td>Customer:</td><td
echo "<tr><td>Mobile Number:</td><td><a href=\"billing.php?val=".$
echo"</table>";
}
?>
<?php
error_reporting(E_ALL);
include 'myphp.php';
$val = $_GET['val'];
$sql = "SELECT * FROM customer_details WHERE customer_name = '" . $val . "'";
$result = mysql_query($sql) or die(mysql_error() . " IN $sql");
$rs = mysql_query($sql);
while($row = mysql_fetch_array($rs))
{
echo"<table>";
echo "<tr><td>Customer:</td><td
echo "<tr><td>Mobile Number:</td><td><a href=\"billing.php?val=".$
echo"</table>";
}
?>
I think I missed one \"
echo "<tr><td>Mobile Number:</td><td><a href=\"billing.php?val=".$
echo "<tr><td>Mobile Number:</td><td><a href=\"billing.php?val=".$
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
3 proven steps to speed up Magento powered sites. The article focus is on optimizing time to first byte (TTFB), full page caching and configuring server for optimal performance.
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
- Databases
- AWS
- MySQL Server
- MongoDB
- NoSQL Databases
- Percona
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing.
Set up your basic HTML file. Open your form tag and set the method and action attributes.:
(CODE)
Set up your first few inputs one for the name and …
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month9 days, 7 hours left to enroll
624 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.