PHP - Display Link In Href

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.

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

My code:

Code: [Select]
<?php
$username = $_SESSION['loggedin'];
$extract_user_rank = mysql_query("SELECT `rank` FROM users WHERE username='$username'");

if($extract_user_rank['rank'] > 0)
{
echo "<a href='control_panel.php'>Admin Control Panel</a>";
}
else
{
//return nothing
}
?>

I have my rank in the database set to 1. Why doesn't it output the ACP link?

I have a "Members" page that displays my organizations members info via My SQL. Currently, the database displays "State" quick links at the top and has the members organized by State down the page. If you click on one of the State links at the top, it will navigate to the section of the page with that state and associated members. I want the members associated with a specific state to be displayed only once I click the associated state link -- instead of all of the information showing at once like it is now. The page I am referring to can be seen at this link: http://homesforhorse...rs.com/members/

<?php

update_option('image_default_link_type','none');

include("/home/cingen/config_admin.php");


function listMembers() {

    $sql = mysql_query("SELECT c.*, s.*
	    FROM (".TABLE_MEMBERS." c LEFT JOIN ".TABLE_STATE." s on c.state = s.state_abbr)
        WHERE c. status = '1'
	    ORDER BY c.country, c.state, c.organization ASC");

    while ($row = mysql_fetch_array($sql)) {
        $display_members = false;

    	$organization = stripslashes($row['organization']);
	    $website = stripslashes($row['website']);

    	if ($website) {
	    	$link = "<a href='http://".$website."' target='_blank'>";
		    $endlink = "</a>";
    	} else {
	    	$link = "";
		    $endlink = "";
    	}

	    $display_members .= $link.$organization.$endlink."<br />";

    	if ($row['address'])    $display_members .= stripslashes($row['address'])." ".stripslashes($row['address2'])."<br />";
        if ($row['city'])       $display_members .= stripslashes($row['city']).", ";
        if ($row['state'])      $display_members .= stripslashes($row['state'])."";
        if ($row['zip'])        $display_members .= "  ".$row['zip'];

        $display_members .= "<br />";

    	if ($row['contact_name'])       $display_members .= "Contact: ".stripslashes($row['contact_name']);
	    if ($row['contact_title'])      $display_members .= ", ".stripslashes($row['contact_title']);
    	if ($row['phone']) 	    	    $display_members .= "<br />Tel: ".stripslashes($row['phone']);
	    if ($row['email']) 		        $display_members .= "<br />".$row['email'];
	    if ($row['website']) 	        $display_members .= "<br /><a href='http://".$row['website']."' target='_blank'>".$row['website']."</a><br/>";
	    if ($row['year_est'])           $display_members .= "Founded in ".$row['year_est'].".";
		if ($row['org501c3'] == "1")    $display_members .= " A 501(c)3 non-profit.";
	    if ($row['gfas'] == "1")   		$display_members .= "<br />GFAS: Accredited Sanctuary.";
	    if ($row['gfas'] == "2")        $display_members .= "<br />GFAS: Verified Sanctuary.";
		if ($row['member_category'])    $display_members .= "<br />".$row['member_category'];

      $display_members .= "<br /><br />";

      $entries[$row['country']][$row['state_name']][] = $display_members;
    }

    $countrylinks = false;
    $statelinks   = false;
    $display      = false;



    if(is_array($entries)){
        $display .= '
        <div class="memberlist">';
        foreach($entries as $country=>$state_members){
            $countrylinks .= '<a href="#'.$country.'">'.$country.'</a> &nbsp;&nbsp;&nbsp;';

            $display .= '
            <h2 id="'.$country.'">'.strtoupper($country).'</h2>
            <div class="country">';


            if(($state_members)){
                foreach($state_members as $state=>$members){
                   $statelinks .= '<a href="#'.$state.'">'.$state.'</a> ';

                    $display .= '
                    <h3 id="'.$state.'">'.strtoupper($state).'</h3>
                    <div class="state">';
                    if(is_array($members)){
                        foreach($members as $key=>$member){
                            $display .= '
                            <div class="member">
                                '.$member.'
                            </div>';
                        }
                    }
                    $display .= '
                    </div>';
                }
            }
            $display .= '
            </div>';
        }
        $display .= '
        </div>';
    }
    $statelinks1 = '
    <h2>Members List</h2>
    <strong>Quick Links</strong><br /><br />
    '.$statelinks.'<br /><br />'
    .$display;


    return $statelinks1;
}



 add_shortcode('memberlist', 'listMembers');


function listRescueStandards() {

    $display_members = '';
    $sql = mysql_query("SELECT vc.*, s.*, m.*
	    FROM ".TABLE_COMPLIANCE." vc, ".TABLE_STATE." s, ".TABLE_MEMBERS." m
    	WHERE vc.member_id = m.cid
	    AND m.status = '1'
    	AND m.state = s.state_abbr
	    ORDER BY m.state, m.organization ASC");

    while ($row = mysql_fetch_array($sql)) {
	    $organization = stripslashes($row['organization']);

    	if ($row['website']) {
	    	$link = "<a href='http://".$row['website']."' target='_blank'>";
		    $endlink = "</a>";
    	} else {
	    	$link = "";
		    $endlink = "";
    	}

	    if($x!=$row['state_name']){
            $display_members .= "<br /><strong>".strtoupper($row['state_name'])."</strong><br />";
            $x = $row['state_name'];
        }

    	$display_members .= $link.$organization.$endlink."<br />
	       ".stripslashes($row['address'])." ".stripslashes($row['address2'])."<br />
    	   ".stripslashes($row['city']).", ".stripslashes($row['state'])."  ".$row['zip']."<br />";

	    if ($row['contact_name']) $display_members .= "Contact: ".stripslashes($row['contact_name']);
    	if ($row['contact_title']) 	$display_members .= ", ".stripslashes($row['contact_title']);
	    if ($row['phone']) 		$display_members .= "<br />Tel: ".stripslashes($row['phone']);
    	if ($row['fax']) 	$display_members .= "<br />Fax: ".stripslashes($row['fax']);
	    if ($row['email']) 	$display_members .= "<br />".$row['email'];
    	if ($row['website']) 		$display_members .= "<br /><a href='http://".$row['website']."' target='_blank'>".$row['website']."</a>";
	    if ($row['year_est']) 		$display_members .= "<br />Founded in ".$row['year_est'].".";
    	if ($row['org501c3'] == "1") 		$display_members .= "<br />This organization IS registered with the IRS as a 501(c)3.";
        if ($row['org501c3'] != "1") 	$display_members .= "<br />This organization is NOT registered with the IRS as a 501(c)3.";

    	$display_members .= "<br /><br />";
    }

            return "<div class='memberlist'>" . $display_members . "</div>";

}
add_shortcode('standardslist', 'listRescueStandards');

 

Greetings!
I have a website www.lanceronlinejobs.com/our_franchises.php I have a franchise images. I want to display each franchise record from database whenever a user click on franchise link. Here is my code.
ourfranchises.php  code:

Code: [Select]
<?php 
include('fconnection.php');

$sql = mysql_query("SELECT * FROM tbl_franchise ORDER BY id DESC") or die(mysql_error());
$row3 = mysql_fetch_array($sql); 
?>
<a href="franchiseDetails.php?city=<?php echo $row3['city'];?>"><img src="images/lbatkhela.jpg" width="150" height="150" alt="Batkhela" /></a>----------------------------------------------------------------------

franchiseDetails.php code:

Code: [Select]
<?php
$id = $_GET['id'];

$query = "SELECT * FROM tbl_franchise WHERE id = '$id' ORDER BY id DESC LIMIT 1";

$result = mysql_query($query);

if (!$result) {
echo "NO RECORD FOUND";
} else {

while($row3 = mysql_fetch_array($result)):
?>

Manager Name: <?php echo $row3['manager_name'];?>
Please help me. Any help would be appreciated.

Thanks.

Hello guys,

I want to make an xml feed into my webpage, but the xml is generated from an .asp file on another website, so it's not actually an xml file, but xml output.
Now, I want to retrieve this xml output on my webpage, but I'm having difficulties while doing this.

What I've tried so far:

- With PHP:
Code: (php) [Select]
<?php
echo file_get_contents("http://link-on-other-website.asp?XML=1");
?>

- With javascript:
Code: (javascript) [Select]
<script type="text/javascript">
if (window.XMLHttpRequest)
  {// code for IE7+, Firefox, Chrome, Opera, Safari
  xmlhttp=new XMLHttpRequest();
  }
else
  {// code for IE6, IE5
  xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
  }
xmlhttp.open("GET","http://link-on-other-website.asp?XML=1", false);
xmlhttp.send();
xmlDoc=xmlhttp.responseXML;

document.write("<table border='1'>");
var x=xmlDoc.getElementsByTagName("RECORD");
for (i=0;i<x.length;i++)
  {
  document.write("<tr><td>");
  document.write(x[i].getElementsByTagName("NAME")[0].childNodes[0].nodeValue);
  document.write("</td><td>");
  document.write(x[i].getElementsByTagName("DATE")[0].childNodes[0].nodeValue);
  document.write("</td></tr>");
  }
document.write("</table>");
</script>


When using the PHP code, I can retrieve it obviously, but I get an <?xml ... > declaration within my body, which is not allowed.
When using the Javascript code, I can't even retrieve anything.

And the goal is to style this xml output to match my website. That's the whole purpose of this xml link, because I couldn't style the iframe I had earlier.

Can someone help me on this, on how to properly embed this asp generated xml output, within my HTML5 document?

ps: I've asked for the xml-feed link from that other website, so using the above PHP code is legit in my case.

Trying to figure out how to make it so name is a link to the profile when its echo
anyone know how to do this?

im at a huge stand still


Code: [Select]
<?php 

                                                $sql = "SELECT name FROM users WHERE DATE_SUB(NOW(),INTERVAL 5 MINUTE) <= lastactive ORDER BY id ASC"; 
$query = mysql_query($sql) or die(mysql_error());
$count = mysql_num_rows($query);
$i = 1;
while($row = mysql_fetch_object($query)) {
 $online_name = htmlspecialchars($row->name);


   echo '<a href="Inbox.php">"'[$goauld]'</a>"'; ?>

how can i do this pls?

i just want to display a link "Free Chat" when i click on it, it must display a dropdown with options "yes" and "no"
the link must not go anywhere yet, only when yes is selected it must go to a page
i have the code:
Code: [Select]
<a href="" id="link" name="link" onClick="yesnolist(1)">Free Chat</a>

then i have javascript:
Code: [Select]
<script type="text/JavaScript">
  function yesnolist()
  {
      var e = document.getElementById("link");
      var strUser1 = e.options[e.selectedIndex].value;
      if (strUser1 == "1")
      {
          window.location.href = "http://.........";
      }
      return strUser1;
  }
</script>

the above is not correct, can some-one help me please?
thanks

This is my script I want to display but it does not show in the page just blank.


<td><object width="220" height="148"><param name="movie" value="http://www.youtube.com/user/THEWORLDOFTRAVEL#p/search/2/uX9nd3xM_MY=1&amp;h1=enUS&amp;color1=0x234900&amp;color3=34900&amp;"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/user/THEWORLDOFTRAVEL#p/search/2/uX9nd3xM_MY=1&amp;h1=enUS&amp;color1=0x234900&amp;color3=34900&amp;" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="220" height="148"></embed></object></td>

I am displaying rows from a database onto a page using:

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

echo $row['name'];

}

I need to figure out how to limit the rows shown to the page to 100. And if there are 100 rows on the page, a link will be displayed at the bottom, that says "Next 100". Then this will display the next 100 rows.
Can you give an example how to do this please?

Thanks

Hi all,
I have written a piece of code querying the database to display the last ten posts from different users on a forum/blog. This is displaying the titles of the posts but I am unsure how to create a link (complete novice) to read the content of those posts. I get the syntax etc but can't really get my head around the target, if you catch my drift. I have created a new php file called recentposts but am unsure of how to take it from there. The code for both is below. The first piece of code works fine but when I click read more I am getting an undefined variable message on line 11 (I'm guessing there should be a link between the two pieces of code) and I am getting mysqli_fetch_array() expects parameter 1 to be mysqli_result on line 12. Any thoughts/hints/suggestions welcome. Thanks in advance.

Code: [Select]
<?php
$connection = @mysqli_connect('localhost','root','','BLOG_PROJECT') //Make a connection to the database
or die(mysqli_connect_error("Could not connect to the server")); //If it doesn't connect give the error message
$latestposts= mysqli_query($connection,"SELECT author_id, title FROM blogposts ORDER BY timeofpost DESC LIMIT 9");//Query the database
while($displayposts=@mysqli_fetch_array($latestposts)){ //go and get the information
echo "{$displayposts['title']}</br>";
echo "<a href='recentposts.php'>Read more</a></br>";
} 
?>

And the recentposts.php is

Code: [Select]
<?php
$connection = @mysqli_connect('localhost','root','','BLOG_PROJECT')
or die(mysqli_connect_error("Could not connect to the server"));
$detail= mysqli_query($connection,"SELECT * FROM blogposts WHERE 'title', 'content', 'timeofpost' = $content");
while($singlepage = mysqli_fetch_array($connection,$detail)){
extract($singlepage);
echo "<h2>{$singlepage['title']}</h2></br>";
echo "{$singlepage['content']}</br>";
echo "{$singlepage['timeofpost']}";
}
?>

Hello,

I have created a webpage that essentially generates an sql query and then puts the results into a table that is displayed.
On one of the columns in this displayed table, I want to allow the user to click on each of the values which will in turn execute a php function. I have the hyperlink working but this is to a separate page.
What I actually need to do is firstly - just ran a php function that will create a new table beneath the currently displayed one.
Secondly, once this is achieved, I need to pass some value to the function so that the generated table is dependent on the value that was clicked.

I've tried a few things and researched but I am struggling. I am a beginner.

Any help would be greatly appreciated.

Here is an extract of the code used for inputting data into the original table - showValuesSR is the function name
<?php
while (!$rsMetrics->EOF) {
?>
<tr>
<?php
for ($x=0; $x<$numberOfFields; $x++) {

if ($fieldNames[$x] == "Values_SR"){ ?>
<td><a href= ?showValuesSR><?php echo $rsMetrics->fields[$fieldNames[$x]]->Value?></a></td>
<?php }
else{ ?>
<td><?php echo $rsMetrics->fields[$fieldNames[$x]]->Value?></td>
<?php
}
}
?>
</tr>
<?php
$rsMetrics->MoveNext();
}

?>

</table>

<?php
function showValuesSR(){

?>
<table border="0" cellpadding="5" width="100%">
<tr><td
background="../images/table_toolbar_bkg.gif" align="center"><font color="Blue" face="verdana" size="2"><strong>function working</strong></td></tr>
</table>

<?php
}
?>

this one is form2 .php and there is action link button where im want the target to open new browser for example now m using google chrome so when im click the action link it will open another browser which is




bit actually the photo is in one im dont know how to combine that why im splitted but how to target like that

How do I post data when a user clicks a link?

I know that for a submit button you just use the name attribute, but I'm not sure how to do it with a link.