Ad:

PHP Discussion Thread
Unsolved
Views: 29189

Jan 14th, 2005

Newbie Question. how to put url into echo $row

Expand Post »

Hi there.

I'm very very new to php. :o so i hope i'm posting in the right forum.
and i really can't figure this out. probably really simple but i need to place a url into:

while ($row = mysql_fetch_array($result)) {
echo $row['login'];
echo " " . $row['age'] . "<br>";

everytime i place <a href= etc i get errors.

I need the login to link to the user's profile page.

Please could anybody help??

Kind Regards
Ross

rosslad2004

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

6 posts
since Jan 2005

Permalink

Jan 14th, 2005

Re: Newbie Question. how to put url into echo $row

Suppose you have the code:

PHP Syntax (Toggle Plain Text)

echo "$value";

Everything within the quotes is printed out. However, now take the following code:

PHP Syntax (Toggle Plain Text)
echo "<a href="$value">";
echo "<a href="$value">";

PHP gets confused where you have quotes within quotes. Therefore, if you want to print out a real quote inside an echo statement, you have to escape the " character with a backlash. Like this ...

PHP Syntax (Toggle Plain Text)
echo "<a href=\"$value\">";
echo "<a href=\"$value\">";

cscgal

Administrator

Staff Writer

Reputation Points: 1422

Solved Threads: 162

The Queen of DaniWeb

Online

13,646 posts
since Feb 2002

Permalink

Jan 14th, 2005

Re: Newbie Question. how to put url into echo $row

so it would be something like:

echo "<a href=member.php?mid=$m[id]\"$row['login']\">";

?

said i'm new at this, sorry :o

Thanks for the quick reply

Kind Regards
Ross

rosslad2004

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

6 posts
since Jan 2005

Permalink

Jan 14th, 2005

Re: Newbie Question. how to put url into echo $row

unfortunatly none of the ways i try seem to work.

i don't think i'm cut out for this php thing.

Ross

rosslad2004

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

6 posts
since Jan 2005

Permalink

Jan 14th, 2005

Re: Newbie Question. how to put url into echo $row

Practice makes perfect.

PHP Syntax (Toggle Plain Text)
echo "<a href=\"member.php?mid=$row[mid]\">$row[login]</a>";
echo "<a href=\"member.php?mid=$row[mid]\">$row[login]</a>";

I'm not exactly sure what $m[id] is ? Where are you fetching that $m[] array from?

cscgal

Administrator

Staff Writer

Reputation Points: 1422

Solved Threads: 162

The Queen of DaniWeb

Online

13,646 posts
since Feb 2002

Permalink

Jan 14th, 2005

Re: Newbie Question. how to put url into echo $row

generally when u pull it from mysql you would reference the item you want by column number, so....
if your query was something to this effect:

PHP Syntax (Toggle Plain Text)
$result = mysql_query("SELECT login,age FROM some_table WHERE user_name='".$user.'");
$row = mysql_fetch_row($result);
 
$login = $row[0];
$age = $row[1];
 
$link = "<a href=\"members.php?mid=".$login."\">".$age."</a>
 
$result = mysql_query("SELECT login,age FROM some_table WHERE user_name='".$user.'");
$row = mysql_fetch_row($result);

$login = $row[0];
$age = $row[1];

$link = "<a href=\"members.php?mid=".$login."\">".$age."</a>

paradox814

Reputation Points: 13

Solved Threads: 4

Posting Whiz

Offline

351 posts
since Oct 2004

Permalink

Jan 14th, 2005

Re: Newbie Question. how to put url into echo $row

Hello. thanks for all your help, both of you,

what i currently have is:

PHP Syntax (Toggle Plain Text)
<?php
$result = mysql_query("select P.id
     , M.login
     , dayofmonth(P.birthdate) as birth_day
     , month(P.birthdate)      as birth_month
     , year(current_date) 
      -year(P.birthdate)       as age
  from profiles  as P
inner
  join members as M
    on P.id = M.id  
 where dayofmonth(current_date) = dayofmonth(P.birthdate)
   and month(current_date)      = month(P.birthdate)") or die("Query failed: " . mysql_error());
while ($row = mysql_fetch_array($result)) {
echo "<a href=\"member.php?mid=$row[mid]\">$row[login]</a>";
echo "&nbsp;" . $row['age'] . "<br>";
}
 
?>
<?php
$result = mysql_query("select P.id
     , M.login
     , dayofmonth(P.birthdate) as birth_day
     , month(P.birthdate)      as birth_month
     , year(current_date) 
      -year(P.birthdate)       as age
  from profiles  as P
inner
  join members as M
    on P.id = M.id  
 where dayofmonth(current_date) = dayofmonth(P.birthdate)
   and month(current_date)      = month(P.birthdate)") or die("Query failed: " . mysql_error());
while ($row = mysql_fetch_array($result)) {
echo "<a href=\"member.php?mid=$row[mid]\">$row[login]</a>";
echo "&nbsp;" . $row['age'] . "<br>";
}

?>

which does give me the linked login name that i was after

but the link doesnt point to the users profile

I wanted it as a todays birthdays list with login name and age, but the tables for login and birthdate was in seperate locations so i ended up with the above.

can you see what i am doing wrong here? :cry:

Kind Regards
Ross

rosslad2004

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

6 posts
since Jan 2005

Permalink

Jan 15th, 2005

Re: Newbie Question. how to put url into echo $row

i don't know, maybe it's a problem with your sql query?
can you login via ssh/telnet and double check to see if that works?

if not here is a PHP interface:

PHP Syntax (Toggle Plain Text)
<!-- Program Name: mysql_send.php
     Description: PHP program that sends an SQL query to the
                  MySQL server and displays the results.
-->
<html>
<head>
<title>SQL Query Sender</title>
</head>
<body>
<?php
 $user="root";
 $host="localhost";
 $password="";
 
 /* Section that executes query */
 if (@$form == "yes")
 {
   mysql_connect($host,$user,$password);
   mysql_select_db($database);
   $query = stripSlashes($query) ;
   $result = mysql_query($query);
   echo "Database Selected: <b>$database</b><br>
          Query: <b>$query</b>
          <h3>Results</h3>
          <hr>";
   if ($result == 0)
      echo("<b>Error " . mysql_errno() . ": " . mysql_error() . "</b>");
 
   elseif ( <email protected>($result) == 0)
      echo("<b>Query completed. No results returned.</b><br>");
   else
   {
     echo "<table border='1'>
           <thead>
            <tr>";
             for ($i = 0; $i < mysql_num_fields($result); $i++)
             {
                 echo("<th>" . mysql_field_name($result,$i) . "</th>");
             }
     echo " </tr>
           </thead>
           <tbody>";
             for ($i = 0; $i < mysql_num_rows($result); $i++)
             {
                echo "<tr>";
                $row = mysql_fetch_row($result);
                for ($j = 0; $j < mysql_num_fields($result); $j++)
                {
                  echo("<td>" . $row[$j] . "</td>");
                }
                echo "</tr>";
             }
             echo "</tbody>
                  </table>";
   }
   echo "<hr><br>
         <form action=$PHP_SELF method=post>
          <input type=hidden name=query value=\"$query\">
          <input type=hidden name=database value=$database>
          <input type=submit name=\"queryButton\" value=\"New Query\">
          <input type=submit name=\"queryButton\" value=\"Edit Query\">
         </form>";
   unset($form);
   exit();
 }
 
 /* Section that requests user input of query */
 @$query = stripSlashes($query);
 if (@$queryButton != "Edit Query")
 {
   $database = " ";
   $query = " ";
 }
?>
 
<form action=<?php echo $PHP_SELF ?>?form=yes method="post">
 <table>
  <tr>
   <td align="right"><b>Type in database name</b></td>
   <td>
     <input type=text name="database" value=<?php echo $database ?> >
   </td>
  </tr>
  <tr>
   <td align="right" valign="top"><b>Type in SQL query</b></td>
  <td><textarea name="query" cols="60" rows="10"><?php echo $query ?></textarea>
   </td>
  </tr>
  <tr>
   <td colspan="2" align="center"><input type="submit" value="Submit
Query"></td>
  </tr>
 </table>
</form>
 
</body>
</html>
<!-- Program Name: mysql_send.php
     Description: PHP program that sends an SQL query to the
                  MySQL server and displays the results.
-->
<html>
<head>
<title>SQL Query Sender</title>
</head>
<body>
<?php
 $user="root";
 $host="localhost";
 $password="";

 /* Section that executes query */
 if (@$form == "yes")
 {
   mysql_connect($host,$user,$password);
   mysql_select_db($database);
   $query = stripSlashes($query) ;
   $result = mysql_query($query);
   echo "Database Selected: <b>$database</b><br>
          Query: <b>$query</b>
          <h3>Results</h3>
          <hr>";
   if ($result == 0)
      echo("<b>Error " . mysql_errno() . ": " . mysql_error() . "</b>");

   elseif ( <email protected>($result) == 0)
      echo("<b>Query completed. No results returned.</b><br>");
   else
   {
     echo "<table border='1'>
           <thead>
            <tr>";
             for ($i = 0; $i < mysql_num_fields($result); $i++)
             {
                 echo("<th>" . mysql_field_name($result,$i) . "</th>");
             }
     echo " </tr>
           </thead>
           <tbody>";
             for ($i = 0; $i < mysql_num_rows($result); $i++)
             {
                echo "<tr>";
                $row = mysql_fetch_row($result);
                for ($j = 0; $j < mysql_num_fields($result); $j++)
                {
                  echo("<td>" . $row[$j] . "</td>");
                }
                echo "</tr>";
             }
             echo "</tbody>
                  </table>";
   }
   echo "<hr><br>
         <form action=$PHP_SELF method=post>
          <input type=hidden name=query value=\"$query\">
          <input type=hidden name=database value=$database>
          <input type=submit name=\"queryButton\" value=\"New Query\">
          <input type=submit name=\"queryButton\" value=\"Edit Query\">
         </form>";
   unset($form);
   exit();
 }

 /* Section that requests user input of query */
 @$query = stripSlashes($query);
 if (@$queryButton != "Edit Query")
 {
   $database = " ";
   $query = " ";
 }
?>

<form action=<?php echo $PHP_SELF ?>?form=yes method="post">
 <table>
  <tr>
   <td align="right"><b>Type in database name</b></td>
   <td>
     <input type=text name="database" value=<?php echo $database ?> >
   </td>
  </tr>
  <tr>
   <td align="right" valign="top"><b>Type in SQL query</b></td>
  <td><textarea name="query" cols="60" rows="10"><?php echo $query ?></textarea>
   </td>
  </tr>
  <tr>
   <td colspan="2" align="center"><input type="submit" value="Submit
Query"></td>
  </tr>
 </table>
</form>

</body>
</html>

this has always proved a big help in my dire times of need with SQL debugging

paradox814

Reputation Points: 13

Solved Threads: 4

Posting Whiz

Offline

351 posts
since Oct 2004

Permalink

Jul 31st, 2005

Re: Newbie Question. how to put url into echo $row

you saved my life with this thread, , thanks !

escolta

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

6 posts
since Jul 2005

Permalink

Feb 25th, 2010

-1

Re: Newbie Question. how to put url into echo $row

you can use this tested ok

PHP Syntax (Toggle Plain Text)
echo '<a href="'."/yourlink.php?id=".$row['id'].'">'.$row['type'].'</a>';
echo '<a href="'."/yourlink.php?id=".$row['id'].'">'.$row['type'].'</a>';

Last edited by Ezzaral; Feb 25th, 2010 at 1:21 pm. Reason: Added code tags. Please use them to format any code that you post.

mhelmyh

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Feb 2010

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Validating the textbox entry

Next Thread in PHP Forum Timeline: on click url submit form without refresh?

DaniWeb Message

Cancel Changes

User Name
Password