PHP - How To Convert The Link To Href Link From Text Description

Hi all, I find myself in need again on PHP coding and the support last time was outstanding (no creeping here) so I am trying my luck again!

I am trying to use a HREF link (lots of individual ones) to search a Mysql database and return the results in a PHP page.

Example of HREF links on the page are he

https://flighteducation.co.uk/Create.html

and in theory you click a career and it 'gets' and 'shows' the data from the database he

https://flighteducation.co.uk/Careers.php

so, you click the 'Animator' link ->it goes to my database and drags back all the data to the Careers.php page

 

So far this is what I have managed to not get right:

HTML (screen shot added/attached Links.png)

 

 <a href="Careers Results.php?jobTitle=Animator">

PHP

     

$id = $_GET['jobTitle'];


if( (int)$id == $id && (int)$id > 0 ) {
	
    $link = mysqli_connect('localhost','MYUSERNAME','MYPASSWORD','MYDATABASE');      // Connect to Database
	
	if (!$link) {
    die('Could not connect: ' . mysqli_connect_error());
}
     
    $sql='SELECT * FROM careers WHERE jobTitle=' .$id;
     
    $result = mysqli_query($link,$sql);

    $row = mysqli_fetch_array($result);
   
     echo $row['jobTitle'];
	 echo $row['jobDescription'];
  
}

else {

   echo "Record NOT FOUND";
}

Up to now the code returns "Record NOT FOUND" so it is passing through the php to the end.

I am new to PHP and trying to get my head around it all, and in theory this is the kind php code that I should be looking at, but I am still very new to it!!

Any help or advice very much appreciated again!!!

 

Thanks

I have a line like this it prints text link but I prefer image link how should i edit it I would appreciate some feedback
Code: [Select]
$templates['etiket'] = array('name' => t('ETİKET'), 'module' => 'uc_invoice_pdf', 'path' => $templates_uc_invoice_pdf_path, 'pdf_settings' => $pdf_settings);

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.

Hello everybody.
Have a good day.
I'm Lam, I have problem hope you help me.

1. This is content html
Quote

<img src="http://example.com/logo.png" /> anti http://google.com<br /> and http://bing.com


I want convert to Code: [Select]
<img src="http://example.com/logo.png" /> anti <a href="http://google.com">http://google.com</a><br /> and <a href="http://bing.com">http://bing.com</a>

and this code php
Code: [Select]
preg_replace("/(http:\/\/[a-zA-Z-0-9._?\/\s]+)/", "<a href=\"$1\">$1</a>", $content);

but result
Code: [Select]
<img src="[color=red]<a href="http://example.com/logo.png">http://example.com/logo.png</a>[/color]" /> anti <a href="http://google.com">http://google.com</a><br /> and <a href="http://bing.com">http://bing.com</a>
I can help me 
I speak English not well hope u ignoring
thanks.

Hello. I have a bit of a problem. When I fetch the link field from the database.i don't see an actual link on the page.  One more thing, what type of field should I use to store the link in the database? Probably there is where I went wrong. All help is 

Hi

I've got this database I created with fields

ProductId   ProductName  Image

I've managed to get it to list the ID,productname, and Image urls
in a list.

My next step is to have the image field actually display
an image and make it clickable:

heres what I've done so far:

Code: [Select]
<?php
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("productfeed", $con);

$result = mysql_query("SELECT * FROM productfeeds");

echo 
"<table border='0'>
<tr>
<th>Firstname</th>
<th>Lastname</th>
<th>Image</th>
</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['ProductID'] . "</td>";
  echo "<td>" . $row['ProductName'] . "</td>";
  echo "<td>" . $row['ImageURL'] . "</td>";
  echo "</tr>";
  }
echo "</table>";

mysql_close($con);
?>
Heres what I want to do:

Code: [Select]
while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['ProductID'] . "</td>";
  echo "<td>" . $row['ProductName'] . "</td>";

 // my changes beneath
  echo "<td>" . <a href="<?php echo $row['ImageURL'];?>"> <img src="<?php echo $row['LinkURL']; ?>"> </a>. "</td>";
  echo "</tr>";
  }
echo "</table>";

mysql_close($con);
?>
Can you guys point me in the right direction?

Many thanks

hi hope you all are fine.

i have been working on a Email Form (like user fills up the form which send the information to our email)
but i was having problem with (URL field i created)

link of form is (http://services.shadowaura.com/allquotations/static.php)
field which is not working is "Inspirational Website:"

when i submit the form it says (Forbidden

You don't have permission to access /allquotations/staticworking.php on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.)

Can some one help me out ?????????????

code behind this form is:

Code: [Select]
<?php

/* Email Variables */

$emailSubject = 'Shadow Aura Contact Info!';
$webMaster = '*****@shadowaura.com';


/* Data Variables */

$Name = $_POST['Name'];
$email = $_POST['email'];
$Cell = $_POST['Cell'];
$Phone = $_POST['Phone'];
$CompanyName = $_POST['CompanyName'];
$TypeOfBusiness = $_POST['TypeOfBusiness'];
$Address = $_POST['Address'];
$YourBudget = $_POST['YourBudget'];
$HaveDomain = $_POST['HaveDomain'];
$RunningWeb = $_POST['RunningWeb'];
$WebLink = $_POST['WebLink'];
$Inspiration1 = $_POST['Inspiration1'];
$Inspiration2 = $_POST['Inspiration2'];
$NumberPages = $_POST['NumberPages'];
$UseFlash = $_POST['UseFlash'];
$TimeFrame = $_POST['TimeFrame'];
$Provided = $_POST['Provided'];
$Comments = $_POST['Comments'];


$body = <<<EOD

<h1> Static Website Quotation </h1> <br>
<b>Name of Client:</b>$Name<br>
<b>Your Email:</b>$email<br>
<b>Cell Number:</b>$Cell<br>
<b>Line Phone Number:</b>$Phone<br>
<b>Company Name:</b>$CompanyName<br>
<b>Type of Business:</b>$TypeOfBusiness<br>
<b>Address:</b>$Address<br>
<b>Your Budget:</b>$YourBudget <br>
<b>Do you have Domain:</b>$HaveDomain<br>
<b>Your Site is Running:</b>$RunningWeb <br>
<b>Website Link:</b><a href="$WebLink">$WebLink</a><br>
<b>Inspiration:</b>$Inspiration1<br>
<b>2nd Inspiration:</b>$Inspiration2<br>
<b>Number of Pages:</b>$NumberPages<br>
<b>Use Flash:</b>$UseFlash <br>
<b>Time Frame:</b>$TimeFrame<br>
<b>You will provide:</b>$Provided<br>
<b>Comments:</b>$Comments<br>



EOD;

$headers = "From: $email\r\n";
$headers .= "Content-type: text/html\r\n";
$success = mail($webMaster, $emailSubject, $body,
$headers);


/* Results rendered as HTML */

$theResults = <<<EOD
<html>
<head>
<title>sent message</title>
<meta http-equiv="refresh" content="3;URL=http://services.shadowaura.com/">
<style type="text/css">
<!--
body {
background-color: #8CC640;
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 20px;
font-style: normal;
line-height: normal;
font-weight: normal;
color: #fec001;
text-decoration: none;
padding-top: 200px;
margin-left: 150px;
width: 800px;
}

-->
</style>
</head>
<div align="center">Your email will be answered soon as possible!
You will return to <b>Shadow Aura Services</b> in a few seconds !</div>
</div>
</body>
</html>
EOD;
echo "$theResults";
?>

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?

Is there a way to add an HTML link in a Text E-mail that was generated by PHP?

I am trying to create an e-mail that looks like this...

Quote

Dear Member,

Your password was re-set, and the following Temporary Password has been assigned:

Use this temporary password to Log In.




Debbie

change link text
Code: [Select]
<?php 
require 'connect.php';
?>
<html>
<head><title>Admin</title>
<link rel="stylesheet" type="text/css" href="tab_style.css">
<script type="text/javascript">

function getXMLHTTP() {
var xmlhttp=false;
try{
xmlhttp=new XMLHttpRequest();
}
catch(e) {
try{
xmlhttp= new ActiveXObject("Microsoft.XMLHTTP");
}
catch(e){
try{
xmlhttp = new ActiveXObject("Msxml2.XMLHTTP");
}
catch(e1){
xmlhttp=false;
}
}
}

return xmlhttp;
    }

function approve(e) {
var req = getXMLHTTP();
if (req) {

req.onreadystatechange = function() {
if (req.readyState == 4) {
// only if "OK"
if (req.status == 200) {
document.getElementById("appr <?php echo $fet['s_id']; ?>").innerHTML=req.responseText;
} else {
alert("There was a problem while using XMLHTTP:\n" + req.statusText);
}
}
}
req.open("GET", "approve.php?stu="+e, true);
req.send(null);
}
}

function block(b) {
var req = getXMLHTTP();
if (req) {

req.onreadystatechange = function() {
if (req.readyState == 4) {
// only if "OK"
if (req.status == 200) {
document.getElementById('blok').innerHTML=req.responseText;
} else {
alert("There was a problem while using XMLHTTP:\n" + req.statusText);
}
}
}
req.open("GET", "block.php?blo="+b, true);
req.send(null);
}
}
</script>
</head>
<body>
<?php
$admin_err='';
$pass_err='';
if (isset ($_REQUEST['submit'])) {
require 'connect.php';

$admin = $_REQUEST['admin'];
$pass = $_REQUEST['password'];
    $err=0;

if($admin=="") {
          $admin_err="enter username";
          $err=1;
}
    if($pass=="") {
          $pass_err="enter password";
          $err=1;
    }
if ($err == 0) {

$check = mysql_query("SELECT admin FROM admin_login WHERE admin='".$admin."' and password='".$pass."' ");
$exi = mysql_num_rows ($check);

if($exi == 0) $err_msg = "Username/password combination incorrect.";
else {
$sel = mysql_query("SELECT * FROM stud");
echo "<h4 class='table-caption'>Students</h4>";
while ($fet = mysql_fetch_array($sel)) {
?>
<div class="base-layer">
<div class="table-row">

<div class="c_one"><p class="text"> <? echo $fet['name']; ?></p></div>

<div class="c_two"><p class="text"> <? echo $fet['email']; ?></p></div>

<div class="c_three"><p class="text"> <? echo $fet['school']; ?></p></div>

<div class="c_four"><p class="text"> <? echo $fet['subject']; ?></p></div>

<div class="c_five"><p class="text"> <? echo $fet['class']; ?></p></div>

<div class="c_six"><p class="text"> <? echo $fet['teacher']; ?></p></div>

<div class="c_seven" id="appr <?php echo $fet['s_id']; ?>"><p class="text">
<?php if ($fet['approve'] == 0) ?>
<a href="#" onClick="return approve(<?php echo $fet['s_id']; ?>);"
style="text-decoration:none">
Approve</a>
</p>
</div>

<div class="c_eight" id="block"><p class="text">
<?php if($fet['approve'] == 1) ?>
<a href="#" onClick="block(<?php echo $fet['s_id']; ?>);" style="text-decoration:none">
Block
</a>
</p>
</div>
<div class="space-line"> </div>
</div>
</div>
<?php
}
die(mysql_error());
}
}
}
?>
<form  id="formid" method="post" name="myform" action="">
<p>
<label for="username">Admin:</label>
<input name="admin" type="text" size="20" value="<?php if(isset($admin)) echo $admin; ?>" />
<?php echo $admin_err; ?>
</p>

<p>
<label for="pass">Password:</label>
<input name="password" type="password" value="<?php if(isset($pass)) echo $pass;?>" />
<?php echo $pass_err; ?>
</p>

<p>
<input name="submit" type="submit" value="Log in" >
</p>

<?php if(isset($err_msg)) echo $err_msg; ?>
</form>
</body>
</html>

approve.php
Code: [Select]
<?php
require_once 'connect.php';
$id = $_REQUEST['stu'];
$upd = mysql_query ("UPDATE stud SET approve = '1' WHERE s_id = ".$id." ");
if (!$upd)
die(mysql_error());
//header("Location:administrator.php");
echo "Approved";
//echo "<h3>Student Approved</h3>";
?>

I am trying to wrap a string with an anchor tag if it finds a match with a block of text. Here is an example text block:

CONOCO 1'10x8 VC DF TP SGN||PRINCIPAL ILLUMINATION||ENG: CO3028TP_0VPR||DWG: CO200428||TO BE: DYED DIESEL (SPEC)||

The string I would want to wrap with a link would be "CO200428". 

The next problem is the drawings (what I'm searching the text for) has over 115,000 possibilities. The text blocks to search are over 1300.

I have the drawing names stored in a simple mysql table...but doing a foreach takes forever...I imagine it will take even longer when looking in the text blocks...

Is there a way to easily to do the anchor wrap? I don't know regex very well...

Hello,

I am having a problem with a link text when ever there is a text that has multiple words.
(e.g. 2 Cor prints out with the white space but when I click on the text the url is printed without the text as 2Cor and so it doesn't find a match)

here is my code:
Code: [Select]
<?php 
if($_GET['book'] == ''){
$books = $wpdb->get_results("
SELECT book_name 
FROM {$wpdb->prefix}sb_books_sermons 
LEFT JOIN {$wpdb->prefix}sb_books ON {$wpdb->prefix}sb_books_sermons.book_name = name 
GROUP BY book_name 
ORDER BY {$wpdb->prefix}sb_books.id 
ASC 
");

foreach($books as $book){
echo '<li><div class="droidlist"><a href="bible/?book='.htmlentities($book->book_name).'">'.$book->book_name.'</a></div></li>'."\n\t";
}
}

Hello all! I am somewhat new to PHP and SQL, but I think I have a basic understanding of how the language works. I have read through a million different websites and forums, and have tried a million different ways but am just not getting anywhere!

This is what I am trying to do... I have a text link that I want to click through to an outside URL from my website. This outside URL was already entered into an SQL database, and I just cant seem to get the text link to bring up the outside URL from the database. This is what I have so far...

1.) My webpage that I am working on is www.mywebsite.com/articles.php
2.) I want the text "Read more..." on this webpage to click through to an outside URL, like "http://www.google.com", which was already entered into an SQL database under the title of "article_link" in a new window
3.) So I would like for "Read more..." to click through the outside URL that was entered into "article_link" in the database

Code: [Select]
<?php
echo <p><a href="\' . $article_link . '\" target="_blank">Read more...</a></p>;
?>
Nothing I have tried has worked so far, nothing clicks through to the outside URL in the "article_link" entry from the database. Sorry if I am being redundant, I have been at this all day! Please help and thank you in advance!!

I am in the middle of a project on my own website and want to add a filter on it, the results are displayed in a HTML table and are pulled in from a mysql database using php and want to add a text filter on the site. I want the filter to work by clicking on a status text link such as open, pending or closed and it filters the results that match that on the same page for that relevant text value. I was not sure if it's more a php question or if can be done with ajax/javascript