PHP - Dynamic Href Link Only Working Once

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 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>
";

}


?>

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...

This works:
Code: [Select]
form action="http://localhost/mysite/css/screen.css" method="post">
This does not work:
Code: [Select]
<?php
$link_1 = "http://localhost/mysite/css/screen.css" ;
$link_2 = '"' . "http://localhost/mysite/css/screen.css" .'"' ;
?>

<form action=<?php echo $link_1;?>  method="post">
<form action=<?php echo $link_2;?>  method="post">
Why do neither of the PHP variables work?

Thanks!

here's my code that i've used to send an email.

Code: [Select]
$link = "<a href=\"http://www.example.com/" . $num . "\">" . $num . "</a>";

$query = "SELECT content FROM emails";
$result = mysql_query($query) or die();
$email_content = mysql_result($result, 0);
$email = sprintf($email_content, $first, $name, $from, $link, $record, $rec, $inc, $max);
$email_body = stripslashes(htmlentities($email, ENT_QUOTES, 'UTF-8'));

// this is sent to another php script via post....

$subject = $_POST['subject'];
$message = nl2br(html_entity_decode($_POST['email_body']));
$to = "me@whatever.com";
$charset='UTF-8';
$encoded_subject="=?$charset?B?" . base64_encode($subject) . "?=\n";
$headers="From: " . $userEmail . "\n"
. "Content-Type: text/html; charset=$charset; format=flowed\n"
. "MIME-Version: 1.0\n"
. "Content-Transfer-Encoding: 8bit\n"
. "X-Mailer: PHP\n";
mail($to,$encoded_subject,$message,$headers);
   

in the db, emails.content is of the text type and contains several lines of text with %4$s which inserts the value of $link into the body.  when the email arrives, there is a link and it appears fine, with the value of $num hyperlinked.  however when you click on it it doesn't go anywhere.  when copying the link location from the email it gives me

x-msg://87/%22http://www.example.com/16

what is x-msg?  how can i get this to work properly?

This topic has been moved to mod_rewrite.

http://www.phpfreaks.com/forums/index.php?topic=321416.0

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!

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

Hi,
I have a problem with an RSS Feed. the error im getting on the W3C validator is this:
This feed does not validate.

    *

      line 1, column 0: XML parsing error: <unknown>:1:0: syntax error [help]

          Query couldn't be executed

In addition, interoperability with the widest range of feed readers could be improved by implementing the following recommendation.

    *

      "text/xml" media type is not specific enough [help]



.htaccess
AddType application/x-httpd-php .xml

rss.php
<?


//Set XML header for browser
header('Content-type: text/xml');

//Create the heading/channel info for RSS Feed
 $output = '<rss version=\"2.0\">';
 $output .= '<channel>';
 $output .= '<title>Muzo Feed</title>';
 $output .= '<description>Your RSS Feed Description</description>';
 $output .= '<link>http://mi-linux.wlv.ac.uk/~0703272</link>';

//Individual Items of our RSS Feed
//Connect to a database and and display each new item in our feed    

//Connect to DB
$host = "localhost";          //Name of host
$user = "0703272";            //User name for Database
$pass = "rachel123";             //Password for Database
$db = "db0703272";          //Name of Database
mysql_connect($host,$user,$pass);

//Create SQL Query for our RSS feed
$sql = "SELECT `title`, `webaddress`, `message`, `date_added` FROM `messages`ORDER BY `date_added` DESC LIMIT 0 , 15";
$result = mysql_query($sql) or die ("Query couldn't be executed");  

//Create Loop for the individual elements in the RSS item section
while ($row = mysql_fetch_array($result))
{
$output .= '<item>';
$output .= '<title>'.$row['title'].'</title>';
$output .= '<link>http:/mi-linux.wlv.ac.uk/~0703272/blog.php'.$row['link'].'</link>';
$output .= '<message>'.$row['message'].'</description>';
$output .= '<date_added>'.$row['date'].'</pubDate>';
$output .= '</item>';
}

//Close RSS channel
$output .= '</channel>';
$output .= '</rss>';
 
//Display output in browser
echo $output;
?>

any ideas?

I'm trying to create a dynamic option menu with one alert selected based on the first query to the db. Any help would be greatly appreciated. 

Code: [Select]
//function to get alerts and create select menu with current alerts pre-selected
function getALERTS1($id){
    require('db.php');
    $alert = mysqli_query($conn, "SELECT alert1 FROM visit_data WEHERE patientid = $id AND discharged IS NULL");
    $row = mysqli_fetch_array($alert);
   
    $selects=null;
    $query = mysqli_query($conn, "SELECT alertid, name FROM alerts");

while($row1 = mysqli_fetch_array($query)) {
    $selects .= "<option value=\"" . $row1['alertid'] . "\">
    if($row1['alertid']==$row['alert1'])
            {
                echo ' selected';
            }
   
    ".$row1['name']."</option>";
  }
  return $selects;
}

Hi all

I have a page which has the following link on it:

<a href="view-listings.php?live&id=<?php echo $showlistings['id'] ?>" title="Click here to make this listing live"><img src="../images/not-live.gif" width="20" title="Click here to make this listing live" alt="Click here to make this listing live" /></a>

Which runs this part of the script:

if (isset($_GET['live'])) {
$liveid = $_GET['id'];
   mysql_query("UPDATE `listings` SET live = 1 WHERE id = '".$liveid."'");
   header ("Location: view-listings.php");
}

Which works great on Safari but it says "Page cannot be displayed" on a PC running Internet Explorer 8?

Please help!

Pete

The link in the email is showing up as plain text and not as a link.  How do I fix this?

if($notify === true)
   {
      $sender = fetch_user_info(fetch_username_by_id ($user_info['uid']));
      $receiver = fetch_user_info(fetch_username_by_id ($uid));
      
      $sender['displayName']       = ucwords("{$sender['firstname']} {$sender['lastname']}");
      $receiver['displayName']   = ucwords("{$receiver['firstname']} {$receiver['lastname']}");
      
      $body = "<table>Hi ${receiver['firstname']},\n
      \n
      <a href=\"http://mysite.com/u/{$sender['username']}\" title=\"Go to {$sender['displayName']}'s profile\">{$sender['displayName']}</a> would like to be.\n
      Please sign in to .\n
      \n
      The who</table>";
   
   mail($receiver['email'], 'fssd', $body, 'From: noreply@site.com');
   // return $sender;
   }

Hello all,

I'm new to any kind of coding, but I recently graduated college with an English degree and decided to try to become a technical writer, but quickly realized I would need to learn some basic coding to publish stuff as many companies are moving away from paper.  Anyway, that's the background to why I'm about to ask a really simple question:

I wrote a login script, and it rejects people correctly who don't have the correct credentials, and it accepts the people that do, but while the failed attempts send the appropriate alert (the alert also pops up when u first open the page, which if you all can figure out why and stop it, that would be awesome, but its not the main problem), for those who do log in it does not send them to the link that I'm trying to send them to upon log in.  Instead, they stay on the same page, but the login text boxes are gone.  Any help would be appreciated, thanks.  Here is the code:
<html>
<body style="background-color:rgb(240,230,200);font-family:Times;font-size:110%;">
<p style="text-align:center;font-family:Arial;font-size:250%"> ///text removed for privacy///</p>
<p style="text-align:center;font-family:Arial;font-size:200%"> ////text removed for privacy </p>
<CENTER><img src="////removed for privacy/////" width="700" height="500"/></Center>
<p style="text-align:center;"> To access the site, please use enter your User ID and Password. </p>
<center>
<?php error_reporting (E_ALL ^ E_NOTICE); ?>
<?php
session_start();
include("passwords.php");
if ($_POST["ac"]=="log") { 
     if ($USERS[$_POST["username"]]==$_POST["password"]) {
          $_SESSION["logged"]=$_POST["username"];
     } else {
          echo 'Please enter a vaild Username and Password';
     };
};
if (array_key_exists($_SESSION["logged"],$USERS))   
    header("index.html");
    else {
    echo "<script>alert('Please enter valid Username and Password')</script>";
     echo '<form action="login.php" method="post"><input type="hidden" name="ac" value="log"> ';
     echo 'Username: <input type="text" name="username" /><br />';
     echo 'Password: <input type="password" name="password" /><br />';
     echo '<input type="submit" value="Login" />';
     echo '</form>';
   }
?>
</center>
</body>
</html>

I have to make a calendar which can go back & forth between years and months. when you click on the month it is supposed to show the calendar of that month and the year you clicked.

you can view the site where i can put the php.
http://helios.ite.gmu.edu/~easad/lab7.php

Thanks a bunch!

Code: [Select]

 
 if ($_GET["year"]=="")
{
$year=date("Y");
$previousYear = $year-1;
$nextYear = $year+1;
}
else
{
$year=$_GET["year"];
$previousYear = $year-1;
$nextYear = $year+1;

}

 if ($_GET["month"]=="")
{
$month=date("n");

}
else
{
$month=$_GET["month"];


}