PHP - Using Href

I'm using the code from Chapter 12 in Beginning PHP4 to display my data. For some reason, the hyperlinks that are suppose to sort columns do not work neither does the "View Record" function. The "Next" button also fails to load the next set of data.  I also set register_global=on in the php.ini. Below is the code:
Code: [Select]
<?php
include "./common_db.inc";
function list_records() {
   global $default_dbname, $user_tablename;
   global $default_sort_order, $default_order_by, $records_per_page;
   global $sort_order, $order_by, $cur_page;
   global $PHP_SELF;
   
   $link_id = db_connect($default_dbname);
   if(!$link_id) error_message(sql_error());

   $query = "SELECT count(*) FROM $user_tablename";

   $result = mysql_query($query);
   if(!$result) error_message(sql_error());
      
   $query_data = mysql_fetch_row($result);
   $total_num_user = $query_data[0];
   if(!$total_num_user) error_message('No User Found!');
   $page_num = $cur_page + 1;

   $total_num_page = $last_page_num 
                   = ceil($total_num_user/$records_per_page);
   
   html_header();
   
   echo "<CENTER><H3>$total_num_user records found. Displaying the page
                     $page_num out of $last_page_num.</H3></CENTER>\n";
   
   if(empty($order_by)) {
      $order_by_str = "ORDER BY $default_order_by";
      $order_by = $default_order_by;
   }
   else $order_by_str = "ORDER BY $order_by";
   if(empty($sort_order)) {
      $sort_order_str = $org_sort_order = $default_sort_order;
      $sort_order = 'DESC';
   }
   else {
      $sort_order_str = $org_sort_order = $sort_order;
      if($sort_order == 'DESC') $sort_order = 'ASC';
      else $sort_order = 'DESC';
   }

   if(empty($cur_page)) {
      $cur_page = 0;
   }
     $limit_str = "LIMIT ". $cur_page * $records_per_page . 
                                     ", $records_per_page";
   $query = "SELECT project, route, config FROM $user_tablename
                                  $order_by_str $sort_order_str $limit_str";
   
   $result = mysql_query($query);   
   if(!$result) error_message(sql_error());
?>

<DIV ALIGN="CENTER">
<TABLE BORDER="1" WIDTH="90%" CELLPADDING="2">
   <TR>
      <TH WIDTH="25%" NOWRAP>
         <A HREF="<?php echo "$PHP_SELF?action=list_records&sort_order=$sort_order&order_by=route"; ?>">
         Route
         </A>
      </TH>
      <TH WIDTH="25%" NOWRAP>
         <A HREF="<?php echo "$PHP_SELF?action=list_records&sort_order=$sort_order&order_by=project"; ?>">
         Project
         </A>
      </TH>
      <TH WIDTH="25%" NOWRAP>
         <A HREF="<?php echo "$PHP_SELF?action=list_records&sort_order=$sort_order&order_by=config"; ?>">
            Config
         </A>
      </TH>
      <TH WIDTH="25%" NOWRAP>Action</TH>
   </TR>
<?php

   while($query_data = mysql_fetch_array($result)) {
      $route = $query_data["route"];
      $project= $query_data["project"];
      $config = $query_data["config"];
      echo "<TR>\n";
      echo "<TD WIDTH=\"25%\" ALIGN=\"CENTER\">$route</TD>\n";
      echo "<TD WIDTH=\"25%\" ALIGN=\"CENTER\">$project</TD>\n";
      echo "<TD WIDTH=\"25%\" ALIGN=\"CENTER\">$config</TD>\n";
      echo "<TD WIDTH=\"25%\" ALIGN=\"CENTER\">
            <A HREF=\"javascript:open_window('$PHP_SELF?action=view_record&
project=$project');\">View Record</A></TD>\n";
      echo "</TR>\n";
   }
?>
</TABLE>
</DIV>
<?php      
   echo "<BR>\n";
   echo "<STRONG><CENTER>";
   if($page_num > 1) {
      $prev_page = $cur_page - 1;

      echo "<A HREF=\"$PHP_SELF?action=list_records&sort_order=$org_sort_order&
  order_by=$order_by&cur_page=0\">[Top]</A>";

      echo "<A HREF=\"$PHP_SELF?action=list_records&sort_order=$org_sort_order&
  order_by=$order_by&cur_page=$prev_page\">[Prev]</A> ";
   }
   if($page_num <  $total_num_page) {
      $next_page = $cur_page + 1;
      $last_page = $total_num_page - 1;

      echo "<A HREF=\"$PHP_SELF?action=list_records&sort_order=$org_sort_order&
  order_by=$order_by&cur_page=$next_page\">[Next]</A> ";

      echo "<A HREF=\"$PHP_SELF?action=list_records&sort_order=$org_sort_order&
  order_by=$order_by&cur_page=$last_page\">[Bottom]</A>";
   }

   echo "</STRONG></CENTER>"; 
   html_footer();
}

function view_record() {
   global $default_dbname, $user_tablename;
   global $project;
   global $PHP_SELF;
   
   if(empty($project)) error_message('Empty User ID!');
   
   $link_id = db_connect($default_dbname);
   
   if(!$link_id) error_message(sql_error());

   $query = "SELECT route, project, config, 
                    opfieldc, opfieldrd, mod FROM $user_tablename
                    WHERE project = '$project'";
   $result = mysql_query($query);
   
   if(!$result) error_message(sql_error());
      
   $query_data = mysql_fetch_array($result);
   $route = $query_data["route"];
   $project = $query_data["project"];
   $config = $query_data["config"];
   $mod = $query_data["mod"];
   

   html_header();
   echo "<CENTER><H3>
         Record for User No.$route - $project($config)
         </H3></CENTER>";

?>


   </TR>
</TABLE>
</DIV>
<?php

   }
   
   html_footer();   

switch($action) {
   case "view_record";
      view_record();
   break;
   default: 
      list_records();
   break;
}
?>


Appreciate any insight you can offer

Hi, im trying to create a link where it takes the row reference number and direct user to the revelant page, however i can get it work, this is my URL HREF

can u please tell me what im doing wrong? thanks

<td><?php echo $reference; ?><?php echo "a href='display.php?reference=".$row['reference']."'?>View Here</a>"</td>

Good day:

Im trying to get the image of an article, which is stored in a folder, and href it with a page and the article id, which is the variable to be passed to the next page. I had href it but when I add the id to be passed I get an error. Here is the code:

Code: [Select]
<?php
  $connection = mysql_connect("localhost",
        "username",
        "password");

    mysql_select_db("articles", $connection); 
$query="SELECT imagename, description, articledid FROM article_description ORDER BY visits DESC LIMIT 0,9";
$result=mysql_query($query);

$num=mysql_numrows($result);


mysql_close();

?>

<table width ="1000" border="1" cellspacing="2" cellpadding="2">



</tr>

<?php

$j=0;
$f6='articles.php';
while ($j < $num) {


$f8=mysql_result($result,$j,"articleid");
$f9=mysql_result($result,$j,"imagename")
?>

<td><a href="<?php echo $f6?aid=$f8; ?>">
<img src="articleimages/<?php echo $f9; ?>"alt="" name="picture" width="100" height="70" border="1" />
</a>
</td>

<?php
$j++;
}
?>

Any help will be appreciated.

Hey there. Firstly may I apologise if this is the wrong forum for this question. I wasn't overly sure. I'm currently developing an aplication within php which allows a user to upload a file which is saved to a directory and information on the file which is saved to a databse (including the file name). This information is then displayed in a table along with the directory location concatinated with the file name to provide a file location. My only issue is that being new to PHP I am unsure how to change this address to a workable link using a href. Any help in adapting the below script would be much apreciated. Thanks, Rick.

echo "<table border='1'><tr>";
for($fieldIterator = 1; $fieldIterator < $numFields; $fieldIterator++)
{  echo "<th>".mysql_field_name($result, $fieldIterator)."</th>";
}
echo "</tr>";

while($row = mysql_fetch_array($result))
  {    echo "<tr>";
  echo "<td>" . $row[1] . "</td>";
  echo "<td>" . $row[2] . "</td>";
  echo "<td>" . $row['Price'] . "</td>";
  echo "<td>" . $row['Genre'] . "</td>";
  echo "<td>" . $row['Category'] . "</td>";
  echo "<td>$ref= C:\wamp\www/.$row[ImageAddress] </td>";
 
 
  echo "</tr>";
  }
echo "</table>";

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
}
?>

how to echo href id value  Thanks !

Code: [Select]
if (isset($_GET['edit']) && $_GET['edit'] == 'textupdate') {
echo " {$_GET['id']}  ! <br>" ;
}

<a href= \"{$_SERVER['PHP_SELF']}?edit=textupdate\" id=\"edit{$row['id']}\" >Edit</a>

how can i pass more then one value via href 

with this kind of method

echo "<a href=\"submit_docs.php?prop_id=".$prop_id."\">Click </a>";


tnx

Hello everybody, I have a question about changing variables.

In a website template I've created, I would like to only include some code from another file into the page if the variable changes. Example:

Code: [Select]
<?php 
$load_page1 = 0; 
?>
<a href="index.php#!/page1" onClick="<?php $load_page1 = 1; ?>">Page 1</a>

<?php 
if($load_page1 == 1)
{ 
include('pages/page1.php'); 
} 
?>
The problem I'm having is Code: [Select]
onClick="<?php $load_page1 = 1; ?>" always sets the variable to "1" even if not clicked. So the question is, how would I make it so the default is "0" and only after clicking the link, the variable is set to "1" and then the new code from the other file is included into the page.

Please let me know if I need to clarify anything and thanks for any help in advance.

How can I set a variable when <a href="#">Link</a> is clicked?

for example to set $variableX as integer of 1?

Hi guys,

I'm trying to add this link <a href="<?php CONFIG_SITE_PATH ?>/settings.php"> to somewhere in the red text below. 

Can someone please show me how/where I would do this. 


$userObj->_userId = $_SESSION['G_userId'.CONFIG_SITE_NAME];
$userObj->getUserDetails();
echo '.$userObj->_name.'</span>&nbsp;&nbsp;/&nbsp;&nbsp;<a href="logout.php" >Logout</a></span>'; 

Hello
I have a website that I am trying to upgrade so that all the data can be placed into a MySql database.
I know what I need but I do not know if it is possible with PHP and MySql.

I need to insert into a Href link a variable so that when the link is clicked it would initiate a MySql search for data.

The variable would contain the Key id of the person whose name was clicked. This is very difficult to explain so a visit to the static website may help understand what I am trying to achieve, www.westonheritage.co.uk
If you go to the second page by clicking the key then click on any of the surnames listed.

I have the database setup on localhost and can get out the data I require.

Kind regards

Hi, I have a directory page the displays all names beginning with B across 3 columns, that part works fine but when I try to add a link on each of the results the link doesn't work. It's not picking up the $id or $name variables for some reason, can anyone tell me why this is? Any help would be very much appreciated.

Code: [Select]
<?php
$data = mysql_query("SELECT id, name FROM new WHERE name LIKE 'B%' ORDER by name ASC LIMIT 30");
$prev_row ='';

echo '<table width="690px">';
while($info = mysql_fetch_array( $data )) {

$letter = strtoupper(substr($info['name'],0,1));
if ($letter != $prev_row) {

if($count % 3) {

for ($i = ($count % 3); $i < 3; $i++) echo '<td>&nbsp;</td>';
echo '</tr>';
$count =0;

}
$prev_row = $letter;

echo '<tr><td class="directory-letter" colspan="3">',$letter,'</td></tr>';
}
$id = $row['id'];
$name = $row['name'];
if ($count % 3 == 0) echo '<ul><tr>';
$count++;
echo '<td width="230px"><li class="directory-store-name"><a href="directory/name.php?id=$id" title="$name" />', $info['name'],"</li></td>\n";
if ($count % 3 == 0) echo '</tr></ul>';
}
if($count % 3) {
for ($i = ($count % 3); $i < 3; $i++) echo '<td>&nbsp;</td>';
echo '</tr>';
}
echo '</table>';
?>

Howdy,

I'm in trouble here. Does someone know how to wrap a url which is in the string with href tag without writing like a few hundred line long code? Example:
Befo "This is a url http://www.domain.com and then some text"
After: "This is a url <a href="http://www.domain.com">http://www.domain.com</a> and then some text"

 

the string is to be received by a flash application right after.

Im fairly new to PHP and have a quick question.

I am creating a mail system from scratch and I have two main SQL rows, ID and read. I need to put a link around the ID so that it only pops up in a pop up window that message.

This is the coding I have so far, feel free to point out where I have gone wrong:
<?

include('../config/config.php');

$Query = sprintf("SELECT * FROM qa LEFT JOIN EmployeeInfo ON(qa.Agentsname = EmployeeInfo.Name) WHERE EmployeeInfo.Name LIKE '%s'", mysql_real_escape_string($_SESSION['SESS_NAME']));
$result = mysql_query($Query);
$num_rows = mysql_num_rows($result);

echo "<table border='0' cellspacing='10' cellpadding='10'>";
  echo "<tr>";
  echo "<td><strong>Message ID</strong></td><td><strong>Team Lead</strong></td><td><strong>Unread/Read</strong></td><td><strong>Score</strong></td>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr><td><a href='http://10.0.11.5/form/employees/attendance/qaview.php?id='". $row['ID'] . ">" . $row['ID'] . "</a></td><td>" . $row['Name'] . "</td><td>" . $row['read'] . "</td><td>" . $row['Score'] . "</td></tr>"; 
  }
echo "</table>";

?>


and this is the qaview.php page
<?

include('../config/config.php');

    $query = doquery("SELECT * FROM qa WHERE ID='$ID'");
$update_query=doquery("UPDATE qa SET read='1' WHERE ID='$ID'");
    $row = mysql_fetch_array($query);

  echo "<td><strong>" . $row['Name'] . "</strong></td></tr>";

?>

This topic has been moved to HTML Help.

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