PHP - Can You Please Correct My 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

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.

Hi, my PHP skills are kinda weak and I've been trying to get this to work, but for some reason, the href isn't linking properly.  Can anyone help me with this?

Code: [Select]
  $titlehigh = preg_replace ( "'($var)'si" , "<strong> \1</strong>" , $row_linkcat[ 'sid' ] );
  $linkhigh = preg_replace ( "'($var)'si" , "<strong> \1</strong>" , $row_linkcat[ 'title' ] );
  $linkdesc = preg_replace ( "'($var)'si" , "<strong> \1</strong>" , $row_linkcat[ 'creator' ] );
  $filehigh = preg_replace ( "'($var)'si" , "<strong> \1</strong>" , $row_linkcat[ 'file' ] );
  $linkpic = preg_replace ( "'($var)'si" , "<strong> \1</strong>" , $row_linkcat[ 'parent' ] );

foreach($trimmed_array as $trimm){
    if($trimm != 'b' ){
        $titlehigh = preg_replace( "'($trimm)'si" ,  "<strong> \1</strong>" , $titlehigh);
     }
//end highlight

?>
 <p>

<center>

<?php echo "<a href='http://www.wootability.com/WootStrips/newstrips.php?id='" . $linkpic . "'>$linkhigh</a>"; ?><br />
For some reason, the href is just a blank id.  I'd be very appreciate if anyone could help.  Thanks!

Hi there! I'm trying to put 2 variables using href.
Ive got it already, but when I tried to insert the page=1, which is the the variable for my paginated code.It doesn't work.

When I used the codes below, from other page (I don't used variable) it works
Code: [Select]
<a href='module_viewpaginated.php?page=1'

but when I used this code, I've got the variable $course and $program, but I don't know how to insert page for my pagination
Code: [Select]
<a href='module_viewpaginated.php?course=".$courseid."&program=".$program." '


I hope my problem is clear. I want to combine the two. Any help would be greatfull!!

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

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>

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

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

I'm new to php and was wondering how I would be able to do the following:

-I have a search page that allows someone to search for a particular user in the database
-In the results, I want to have a <a href> link to another page which will run a sql query based on which user's link was clicked and list their posts.


So right now I have been trying this code to build that href link:

Code: [Select]
  echo '<td><a href="viewuser.php?username='.urlencode($row['username']).'>View user</a></td>';
However on the following page it is unable to retrieve the 'username' field.

This topic has been moved to HTML Help.

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

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>';
?>

I wanted to store a link in the db and display the same link on the front end which will take me to the site.

i tried with href but i get some string error.

Also i wanted to add a youtube embed tag to display it again on query to the db.

in short is  possible to store the url in the db  and display the same url.

thanks

Im looking to change my page ever so slightly to fit in with my .htaccess file.  However I have a syntax issue.
Can anybody explain how to fix the below syntax and what i have done wrong so that I can learn from it.

Code: [Select]

<?php
$query = mysql_query("SELECT DISTINCT subtype FROM business WHERE type ='Cars and Travel' AND confirmed ='Yes' ORDER BY name");
echo mysql_error();
while($ntx=mysql_fetch_row($query)) $nt[] = $ntx[0];
$i = -1;
foreach($nt as $value)
{$i++;
$FileName = str_replace(' ','_',$nt[$i]);
$FileUsed = str_replace('_',' ',$nt[$i]);
echo "<a href="str_replace(' ','_',$nt[$i])">" . ucwords(strtolower (($nt[$i]))) . "</a>" . "<br/>";
/*THE SYNTAX ERROR Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' IS IN THE ABOVE LINE*/
$FileHandle = fopen($FileName, 'w') or die("cant open file");
$pageContents = file_get_contents("header.php");
fwrite($FileHandle,"$pageContents");}
fclose($FileHandle);
?>

This is how it was before;

<?php
$nt = array();
$query = mysql_query("SELECT DISTINCT subtype FROM business WHERE type ='Legal' AND confirmed ='Yes' ORDER BY name");
echo mysql_error();
while($ntx=mysql_fetch_row($query)) $nt[] = $ntx[0];
$i = -1;
foreach($nt as $value)
{$i++;
$FileName = str_replace(' ','_',$nt[$i]) . ".php";
$FileUsed = str_replace('_',' ',$nt[$i]);
echo "<a href='" . str_replace(' ','_',$nt[$i]) . ".php?subtype=$FileUsed'>"  . ucwords(strtolower (($nt[$i]))) . "</a>" . "<br/>";
$FileHandle = fopen($FileName, 'w') or die("cant open file");
$pageContents = file_get_contents("header.php");
fwrite($FileHandle,"$pageContents");}
fclose($FileHandle);
?>

The reason ive altered the top script is that i want my links to be like

mysite.com/solicitor

opposed to

mysite.com/solicitor.php?subtype=solicitor

The error is on line 47 which I have labelled in comments

PS.  I know my php is a bit of a wreck but when I get this syntax issue fixed Ill be working on it.

ok so I just want to get the username into the url after the button is clicked

Code: [Select]
<?php
$val = 123;
?>

<a  href="index.php>Button</a>
How do I get the href to be Code: [Select]
index.php?user=123
all help greatly appreciated. thanks