PHP - Php <a Href> Link Using Mysql Id

Hi people,

I've been having trouble with this for a while now. Basically, i have this website: http://el07jpg.info . You can log in with username:doctor1 password:password1

Once you've logged on, u can click on "Patients". Then, if you click on a patient, it shows their info. Then at the bottom, I have links to glucose readings and heart rate readings... but when I click on either of those links, it goes back to the main page, showing all the patients..

The weird thing is that I got this to work for the first step, u click on the <a href> link of a patient, and it brings you to their page. Then I've done the EXACT same thing to link to the glucose or heart rate readings of that specific patient, but it doesn't work. I really can't see what i've done wrong. Although I noticed in the address bar, when I click on glucose readings for example, the url is http://el07jpg.info/index.php?op=patients&id=&reading=glucose (id should be equal to a number, like id=4, but there's no number... Any help would be much appreciated! Cheers! Code for op_patients.php page:


<?php

//Page if a set of records is selected from a single patient's page

if ($_REQUEST[reading]+0) {

        $GLOBALS['html']['css'][]="default.css";
   $reading_source=$_REQUEST[reading]+0;
   $sql="select * from {$reading_source}_readings where patientRFID='{$patient[patientRFID]}' ";
   $results=mysql_select_assoc($sql);
   if (!$results){
      $GLOBALS[err][]="No records exist!";
      exit;
   }
   
   $GLOBALS['html']['title']="Patient: {$patient[first_name]} {$patient[last_name]}'s {$reading_source} readings ";
       
        echo $reading_source;
}

//Page if a single patient is selected

if ($_REQUEST[id]+0) {

        $GLOBALS['html']['css'][]="default.css";
   $id=$_REQUEST[id]+0;
   $sql="select * from patients where doctorID='{$_SESSION[user][id]}' and patientID='$id' ";
   $patient=mysql_select_assoc($sql);
   if (!$patient){
      $GLOBALS[err][]="The patient can't be found!";
      exit;
   }
   
   $GLOBALS['html']['title']="Patient: {$patient[last_name]}, {$patient[first_name]} ";
       
   $output.="
        <br>
        <table border='1' cellpadding='5' cellspacing='5' width='600'>
        <tr><td rowspan=6><img src=\"$patient[photo]\"> </td>
        <th>Name: </th><td>{$patient[first_name]} {$patient[last_name]} </td></tr>
        <tr><th>D.O.B: </th><td>{$patient[dob]} </td></tr>
        <tr><th>Email: </th><td>{$patient[email]} </td></tr>
        <tr><th>Phone Number: </th><td>{$patient[phone_no]}</td></tr>
        <tr><th>Address: </th><td>{$patient[address]}</td></tr>
        <tr><th><br> Comments:<br> </th>
        <td>{$patient[comments]} </td></tr>
        </table>

        <table border='1' cellpadding='5' cellspacing='5' width='600'>
        <tr><th colspan=3><br>Medical Readings<br><br></th></tr>
        <tr>
        <td align='center' width='300'>
        <a href='index.php?op=patients&id={$v[patientID]}&reading=glucose'>Glucose Readings</a>
        </td>
   <td colspan=2 align='center' width='300'>
   <a href='index.php?op=patients&id={$v[patientID]}&reading=heart'>Heart Rate Readings</a>
   </td>
   </tr> 
        </table>
   ";

   echo $output;
        exit;
}

//Main Page showing all patients

$GLOBALS['html']['title']="Patients";
$GLOBALS['html']['css'][]="default.css";

if(!$_SESSION[user][id]) {
        $er="Access Denied! Please Log in.";
        echo "<div style='color:red;'>$er</div>";
} else {


$sql="select * from patients where doctorID='{$_SESSION[user][id]}' order by last_name";
$d=mysql_getarray_assoc($sql);
$output='';
foreach ($d as $v){
   $output.="
   <tr><td>
   <a href='index.php?op=patients&id={$v[patientID]}'>{$v[last_name]}, {$v[first_name]}</a>
   </td></tr>
   ";
}

echo "
<table width=80% align=left border='1' cellpadding='5' cellspacing='5' width='100%'>
<tr><th class=popupheader align='left'>
Patient Name<br><br>
</th></tr>
$output
</table>
";

}


?>

Hello Everyone,

I'm using PHP with MySQL.  One of the fields in the database is website.  The code I'm using is as follows:

variable:

$web=mysql_result($result,$i,"web");

html/php code:

<td><font face="Arial, Helvetica, sans-serif"><a href="<? echo "$web"; ?>">Website</a></font></td>

What it should do is have the clickable word Website with the correct url from the database.  Instead it's repeating the website the page is on.  For example it's doing this:

http://mywebsite/www.enteredwebsite.com

Any help is appreciated.

Hey all,

I'm working on a website to show various products.  I am using PHP, HTML, MySQL.  I have a products page which shows a table of products (either all or just products from a specific category).  Currently, the page works fine, shows an image, brand, name, and price of each product.  However, when I have tried to make the image and the brand and name a link, it doesn't fully work.  In the page source it will show correctly, but on the webpage itself I cannot click on the links.  I have scoured various forums and manuals and have tried all the various ways to code the <a href=> but it still does not work right.  Here's a snippet of the code with the link...

Code: [Select]
/*Other code above for MySQL queries, HTML table etc*/

<td>
<?php
echo '<a href="details.php?id=' . $row['id'] . '"><img src="resize.php?id=' . $row['id'] . '"/></a>';
?>
</td>
<td>
<?php
echo "<a href=\"details.php?id=" . $row['id'] . "\">" . $row['brand'] . "<br>" . $row['name'] . "</a><br>";
echo "Price: $" . $row['price'] . "<br>";
?>
</td>

I have even tried putting the <a href="details.php?id=<?php echo $row['id']; ?> ... </a> just between the <td> and </td>.  I still can't click the links on the page, even though they are technically there.  The page source will show <a href="details.php?id=1"> ... =2"> ... =3"> ... etc for each product that is displayed.  If I actually type details.php?id=1 in my browser and go back to the products page the text will change color to the "visited link" color.

Any insight into my dilemma?
Thanks in advance...

Hello. I have a bit of a problem. When I fetch the link field from the database.i don't see an actual link on the page.  One more thing, what type of field should I use to store the link in the database? Probably there is where I went wrong. All help is 

Hi guys; 

I've managed to find my way into something of a maze. 

<td> <a href="'Details/21/index.php'"?id= . $id .'>" . $row['id'] . "</a> </td> 

I'm looking at this line in the code. I realise it's currently in the wrong syntax but I'm just trying multiple different variations.

At the moment I'm actually just trying to make it go to a static link but my real goal is to - get it to pick up the id number, of the id row I click, and concatenate that with the rest of my address string. Then use that as the href. 

Something like this: -

"'Details/' + $id + '/index.php'"

It's really confusing me though inside this loop and for some reason the id number is being picked up as an int, by the looks of things. It's getting above my level of understanding. 

Any chance one of you masters would through a n00b a lifeline? 

 

This is my code below 

 

<!DOCTYPE html>
<html>
<head>
	<title>LifeSaver DB</title>
	<h1> LifeSaver Database </h1>
</head>
<body>
	<table>
		<tr>
			<th>Id</th>
			<th>Location</th>					
			<th>Initials</th>
			<th>TimeStamp</th>
			<th>Notes</th>					
		</tr>
		<?php
		$conn = mysqli_connect("localhost", "meh", "pas", "DB"); 
		// Check connection
		if ($conn->connect_error) {
			die("Connection failed: " . $conn->connect_error);
			}
			
		$sql = "SELECT * FROM LifeSaver1 ORDER BY id DESC";
		$result = $conn->query($sql);
		
		if ($result->num_rows > 0) {
			// output data of each row
			while($row = $result->fetch_assoc()) {
				
				//for href row
				$id = $row['id'];
				$Footage = ['Footage'];
				
				echo 
				"<tr>
					<td> <a href="'Details/21/index.php'"?id= . $id .'>" . $row['id'] . "</a> </td>                
					<td>" . $row["Location"] . "</td>		
					<td>" . $row["Initials"]. "</td>
					<td>" . $row["TimeStamp"]. "</td>	
					<td>" . $row["Notes"] . "</td>
							
				</tr>";}
				
				//show table
				echo "</table>";
				} else { echo "0 results"; }
			$conn->close();

	?>
	</table>
</body>
<style>
	
table, td, th {
  border: 1px solid black;
  margin: auto;
}

table {
  border-collapse: collapse;
color: #000;   <!--font colour -->
font-family: monospace;
font-size: 18px;
text-align: center;}

th {
background-color: #337AFF;
color: white;
font-weight: bold; }

tr:nth-child(odd) {background-color: #add8e6}


</style>
</html>

 

Edited February 8, 2020 by JonnyDriller

hello, is there a way to check a query to see if a link is in it?  like if i have $description=$row['description'];  and $description says something like

Mikes bio is at http://www.website.com/mike/

i want to be able to click that link

is this possible?

Hi,
So my code returns this:
mysql_query() expects parameter 2 to be resource, null given

My query & result is:
$query = "SELECT * FROM wow_logon.accounts WHERE forum_acc = ('$userid')";
$result = mysql_query($query,$connect);

So, something's wrong with my connect variable:
$connect = mysql_connect($conf["host"],$conf["user"],$conf["password"]) or die(mysql_error());
                         mysql_select_db($conf["db"],$connect) or die(mysql_error());

So I don't get why it doesn't work, perhaps the select db isn't parsed, but it's told which database to use in the query :/
Any help is much appreciated.

What is wrong?

Warning: mysql_select_db(): supplied resource is not a valid MySQL-Link resource in /home/rweekly/public_html/2012/view_arguments.php on line 41

Warning: mysql_query(): supplied resource is not a valid MySQL-Link resource in /home/rweekly/public_html/2012/view_arguments.php on line 43

Code: [Select]
mysql_select_db($database_news, $news);
$query_news = "SELECT * FROM news WHERE id = '$id'";
$news = mysql_query($query_news, $news) or die(mysql_error());
$row_news = mysql_fetch_assoc($news);
$totalRows_news = mysql_num_rows($news);

mysql_select_db($database_news, $news);
$query_arguments = "SELECT * FROM argue WHERE pid = '$id'";
$arguments = mysql_query($query_arguments, $news) or die(mysql_error());
$row_arguments = mysql_fetch_assoc($arguments);
$totalRows_arguments = mysql_num_rows($arguments);

Hey guys,

Currently Im using the code:

while($row=mysql_fetch_array($nt)){

echo"
$row[user_login],$row[user_email],$row[CallHistoryTimes],$row[CallHistoryInfo],$row[CallHistoryLastOp]$row[CallHistoryLastDate],<br>";
}

To list a mysql array; what I am trying to do is to use the mysql row ID and turn the entire string above into a list.

So for example, the database would get the ID information & create a link of edit.php/?id=3

If someone could help me on this it would be mega appreciated.

Thanks

I have a table where it displays some data. How do I make this Code: [Select]
echo "<td>" . $row['title'] . "</td>"; into a link?

Hey,

I'm trying to save a MySQL-Link source as an instance variable in my query class.
The problem is that MySQL sees it as an invalid MySQL-Link (supplied argument is not a valid MySQL-Link resource).
What I'm I doing wrong?

//Walle

Code: [Select]
private $connection;
//Construct
public function __construct(&$connection)
{
  $this->connection = $connection;
}

//Where the error occurs
public function exe_query($sql)
 {
  $result = mysql_query($sql, $this->connection);
  if(!$result) {
  throw new Exception(mysql_error());
 }
 return $result;
}

Hi Everyone.

I get the following data from a result from database search

<?php echo $rsjobs['CompanyURL'];?>  It prints out the url but when I try to turn it into a clickable link it does not work

Here is the coding I have so far.


<a href="<?php echo $rsjobs['CompanyURL'];?>"><?php echo $rsjobs['CompanyURL'];?></a>


 What am I doing wrong ? please help.

Hi guys.. 1st post here.  I'm pretty new to php.. just a few weeks in.  I've gotten pretty decent at making mysql connections and extracting data, but now I'm wanting to take one of my urls that I echo to my page and create a new page.  Hoping someone can help...  Here's the pictu

MY MySQL Setup:
I have 1 table called table1. It has 2 columns which a 'Title' & 'Description'

My Index.php Page:
I connect to mysql. I pull the 'Title' from MySQL and loop it to produce 100 rows of data that fill my index page, as expected.

My Problem:
I now want to be able to click one of those rows and dynamically create a new page (description.php) that includes the 'Title' & 'Description'.

My Progress:
I've managed to click a row and create a hyperlink to mysite.com/$title (where 'title' is pulling the 'title' from the mysql db) but I all I get is page not found.

My Question:
How do I tell description.php to pull the 'Title' and 'Description' and link to it from index.php?

My Gratitude:
Thanks in advance!

I have a function that generates a random number and checks to make sure it does not exists in the database.

I call this function using
Code: [Select]
$ref = get_record_ref();

I get the following error.

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in line 68


EDITED....
if i place the code from the function in my script and not use it as a function the script works.
why would this be?

Code: [Select]
<?php
  db_connect() or die('Unable to connect to database server!');

  function db_connect($server = 'localhost', $username = 'username', $password = 'password', $database = 'databasename', $link = 'db_link') {
    global $$link;

    $$link = mysql_connect($server, $username, $password);

    if ($$link) mysql_select_db($database);

    return $$link;
  }

//Function to handle database errors.
  function db_error($query, $errno, $error) {
die('<font color="#000000"><strong>' . $errno . '<br><br><br><br><small><font color="#ff0000">[STOP]</font></small><br><br></strong><br><br><br>One of our coders have been informed of this problem and shall be working on it very shortly.<br><br>Please try again in a few minutes or so when we should have this issue fixed.<br><br>Thank you.</font>');
  }

//Function to query the database.
  function db_query($query, $link = 'db_link') {
    global $$link;
$theip = $_SERVER['REMOTE_ADDR'];
$httpuseragent = $_SERVER['HTTP_USER_AGENT'];
$fromlink4 = gethostbyaddr($_SERVER['REMOTE_ADDR']);


// this next line is the error line 68
    $result = mysql_query($query, $$link) or db_error($query, mysql_errno(), mysql_error());




    return $result;
  }




function get_record_ref() {
// /*
// set new $record_ref.
$record_ref =  (rand(10, rand(10, 1000000000)));
// check if exisits in DB.
$sql = "SELECT * FROM `table` WHERE `record_ref` = '". $record_ref ."'";
$get_records_with_record_ref = db_query($sql,'');
// count entries in DB for $record_ref.
$count_record_ref =  mysql_num_rows($get_records_with_record_ref);

while ($count_record_ref > 0) {
// set new $record_ref.
$record_ref =  (rand(10, rand(10, 1000000000)));
// check if exisits in DB.
$sql = "SELECT * FROM `table` WHERE `record_ref` = '". $record_ref ."'";
$get_records_with_record_ref = db_query($sql);
// count entries in DB for $record_ref.
$count_record_ref =  mysql_num_rows($get_records_with_record_ref);
}
// */
return $record_ref;
}
?>

I want to do an sql query, but I want it to happen only after my user has clicked on a confirmation link.  The link will be sent to their email address.  What is the usual procedure for this?

For the time being Ive chucked what ive got into 1 php file, but I pressume I will need a couple of php files, and some how pass some variables from  1 page to the next???

$first = $_GET['first'];
$last = $_GET['last'];
$age = $_GET['age'];
$$emailad = $_GET ['emailad']
$query =mysql_query
("INSERT INTO treesurgeons (FirstName, LastName, Age) VALUES ('$first', '$last', '$age')");
echo mysql_error();
echo "<p>Thankyou for submiting your details.\r\n Please check your inbox and click on your confirmation link.</p>";

$message = "The following details have been submited to the tree directory and are awaiting confirmation;
$first $last, $age. \r\n Please click on the link below to confirm these details are correct"; //Do I include a link to an html file or php file?
$subject = "Your tree directory details";
$to = "$email";
$email = "$emailad";

mail( "$to", "$subject","$message", "$headers"); //How do I trigger this email upon confirmation
?></body></html>