PHP - How To Make Certain Words An Automnatic Link?

Hi People.

I am doing quite well with my www.airfieldcards.com website which is information for pilots in the UK and ireland should they wish to visit another airfield.

It is in the form of a flight guide for free.

Each card is held in a database and the cards are shown on the site by loading the following script
/php/results.php?id=132

In the above example the card for c-moor in Ireland would be loaded.

I want to be able to add a link within the cards that will give the user "the code" to enter that card within their own website.

Sort of a "click here to get the code to add to your website"

Then opening a separate box in a new window that had something like this in it.

Copy and Paste the following code into your website
Code: [Select]
<iframe width="720" height="1500" frameborder="0" scrolling="no" marginheight="0" marginwidth="0" src="http://airfieldcards.com/php/results.php[b][i]"what goes here?"[/i][/b]
What would I put into the bit "what goes here?" to dynamically load that specific card? and give the user the correct code to add into their own site?

Thanks in advance, you guys on here have always been brilliant.

I have a table where it displays some data. How do I make this Code: [Select]
echo "<td>" . $row['title'] . "</td>"; into a link?

I basically have a PHP Search Form, and when a user fills in a form it outputs the results. Each result displays a image of a property, how could i make them images have their own unique link which will take them directly to the page of the property being shown?

Im using PHP and mySQL tables

Any help is appreciated,

Thank You.

Heres the PHP that outputs the results:
Code: [Select]

<?php
require_once 'mstr_ref.php';
function san($input){
if(get_magic_quotes_gpc()){
$input=stripcslashes($input);
}
$output = mysql_real_escape_string($input);
return $output;
}
if(isset($_POST['submit'])){
$pVars = array('area'=>$_POST['areas'], 'propType'=>$_POST['prop_type'], 'saleType'=>$_POST['ptype'], 'minB'=>$_POST['min_bedrooms'], 'maxB'=>$_POST['max_bedrooms'], 'minP'=>$_POST['min_price'], 'maxP'=>$_POST['max_price']);
foreach ($pVars as $k=>$v){
$v = san($v);
}
$sql = new makeQuery();
$sql->manAdd('location_id', $pVars['area']);
if($pVars['propType'] != 'Any'){
$sql->manAdd('catagory_id', $pVars['propType']);
}
if ($pVars['maxB'] > 0){
$sql->manAdd('bedrooms', $pVars['maxB'], '<=');
}
if($pVars['minB'] > 0){
$sql->manAdd('bedrooms',$pVars['minB'],'>=');
}
if($pVars['saleType'] != 'Any'){
if($pVars['saleType'] == "forsale"){
$sql->manAdd('market_type', 'sale');
if($pVars['minP'] != 0){
$pVars['minP'] = $pVars['minP'] * 1000;
}
if($pVars['maxP'] != 0){
$pVars['maxP'] = $pVars['maxP'] * 1000;
}
}
if($pVars['saleType'] == 'forrent'){
$sql->manAdd('market_type', 'rent');
}
}

$qry = $sql->sqlStart.$sql->stmt.'Group By property.id';
$results = mysql_query($qry) or die (mysql_error()."<br />|-|-|-|-|-|-|-|-|-|-|-|-<br />$qry");
if(mysql_num_rows($results) < 1){
die ("Sorry, No Results Match Your Search.");
}
while($row = mysql_fetch_assoc($results)){
echo '<div class="container" style="float:left;">';
echo '<div class="imageholder" style="float:left;">';
echo "<img class='image1' src='{$row['image_path']}' alt='{$row['summary']}'> <br />";
echo '</div>';
echo '<div class="textholder" style="font-family:helvetica; font-size:14px; float:left; padding-top:10px;">';
echo "{$row['summary']}";
echo "<span style=\"color:#63be21;\"><br><br><b>{$row['bedrooms']} bedroom(s) {$row['bathrooms']} bathroom(s) {$row['receptions']} reception room(s)</b></span>";
if($row['parking'] != null){
echo "<span style=\"color:#63be21;\"><b> {$row['parking']} parking space(s)</b></span>";
}

echo '</div>';
echo '<div style="clear:both"></div>';
}

}
else{
echo "There was a problem, please click<a href='index.php'> Here </a>to return to the main page and try again";
}
?>

I have a site, and there is an image with a link to another page, how can I make it so this is the only way to get to that page is by clicking on that image, and not by typing www.mywebsite.com/page.php into the address bar in a browser?

Seems to be a basic question, but I couldn't find an answer nor figure it out on my own.

Basically I have a script that takes out specific data out of the database, the script works on its own, now I just need a way to make the user execute it with a link or a button.

Example:
Category: [Smileys] - [Category2] - [Category3] - etc.

As soon as the user clicks on [Smileys] all data in the database which contains the word smileys in the category field gets selected and outputted as a list.

Again the script works, I just need to be able to execute it with a button.

If I understood it correctly I have to run the script by adding a
if (isset($_POST['Smileys'])) {
in front of the script.

But how do I build the connection with the text link?

I would like to know how to make my links show that it's active. For example if I click on a link that says overview then that link has to be highlighted.

This is the code that I have:

Code: [Select]
<?php 
if (isset($this->_params['submenus']) && is_array($this->_params['submenus'])){
foreach ($this->_params['submenus'] as $submenu){
?>
<li class="active"><a href="<?php echo $this->get_uri("/{$submenu['controller']}/{$submenu['action']}") ?>" onclick="javascript:return setSubMenu(<?php echo $submenu['id'] ?>);"><?php echo strtoupper($submenu['name'])?></a></li>
<?php
}
}
?>

Unfortunately with this code all the links are selected as active.

Hi I would like to know how to make a link select certain stuff from the database. For example the link called cape town with the id 11 is selected then the link must search through the events table for the city_id 11 and take that information and display it in another page.

I would like to know how to do that or can you let me know of place that I can look. I have tried google but I don't know how to put what I'm looking for in words

This is the code I have now however when you click next to view more results it says please enter a search..., (there is more code above this however I thought that the problem would be within the code provided.)

$currPage = (($s/$limit) + 1);

//break before paging
  echo "<br />";

  // next we need to do the links to other results
  if ($s>=1) { // bypass PREV link if s is 0
  $prevs=($s-$limit);
  print "&nbsp;<a href=\"$PHP_SELF?s=$prevs&q=$var\">&lt;&lt;
  Prev 10</a>&nbsp&nbsp;";
  }

// calculate number of pages needing links
  $pages=intval($numrows/$limit);

// $pages now contains int of pages needed unless there is a remainder from division

  if ($numrows%$limit) {
  // has remainder so add one page
  $pages++;
  }

// check to see if last page
  if (!((($s+$limit)/$limit)==$pages) && $pages!=1) {

  // not last page so give NEXT link
  $news=$s+$limit;

  echo "&nbsp;<a href=\"$PHP_SELF?s=$news&q=$var\">Next 10 &gt;&gt;</a>";
  }

$a = $s + ($limit) ;
  if ($a > $numrows) { $a = $numrows ; }
  $b = $s + 1 ;
  echo "<p>Showing results $b to $a of $numrows</p>";
 
?>

: : NEW Problem

I want to replace bad words which someone has inputted into my HTML textarea, with something like [CENSORED].
Here's what I've got so far:
note: $review is the posted textarea name.
Code: [Select]

$words_text = 'badwords.txt';
$bad_words = file($words_text);
               
$good_words = str_ireplace($bad_words,'[CENSORED]',$review);
         
echo $good_words;


The thing is, if I type bad words in the textarea, I still get bad words when I echo $good_words.

I don't know why I'm getting this, any ideas

Hello dear friends,

I've an idea so let us say we have paragraph with bad words 

Code: [Select]
$para = "Hello shit oh shit what the hell this is shit day";
Now let say we create textarea

Code: [Select]
<textarea id="badword" name="badword">
</textarea>
and let us say we have database table as following

Code: [Select]
CREATE TABLE `banned` (
 `id` varchar(50) NOT NULL default '',
 `badwords` text NOT NULL,
 PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

consider we have connetion and can update mysql table badwords

1- now how we can enter word per line in this textarea

example we entered in this textarea per line
shit
hell
die
death

then by click on submit it stored in an database table 'banned' as

INSERT INTO `banned` VALUES ('1', 'shit,hell,die,death');


2- if we called `badwords` from table 'banned' how then can put 'shit,hell,die,death' into array so we can exclude it from $para

 
can someone please help me in this , how to store textarea per line as sperated words in database table and how then call it back as array to exclude it form our paragraph

Or

it there any other simple way doing the same 

thank you

I'm trying to pull in data using a particular word from a mysql db (it's like a search facility).

But this code only picks if the db has got the exact same word.
E.g. if fincom = "DALLS" it pulls the data only when "searchwords" has DALLS. It ignores if "searchwords" has BARBIE DALLS. How can I fix this. I need to pick all records which contains the search word 'fincom' anywhere in  searchwords.

Hope this makes scene.

$SomeVar = $_POST['fincom'];
$query = "SELECT * FROM  news_home WHERE searchwords = '".$SomeVar."' ORDER BY timestamp DESC";
$results = mysql_query($query);

hi,

now i have something like this:

$pizza  = "piece1 piece2 piece3 piece4";
$one_word = explode(" ", $pizza);

but i want to get 2 words together, like that:

$two_words[0]='piece1 piece2';
$two_words[1]='piece3 piece4';
$two_words[2]='piece2 piece3';
$two_words[3]='piece1 piece4';

if it's impossible with explode, then it's fine if you use some other function, i don't care as long as it works.

thank you, tastro

Hi, having a really strange problem, i have a form like this:

<form method='post' action='addcart.php'>
echo $name //prints both parts of name separated by space
<input type='hidden' value='$name' name='na'

and then in the addcart.php
echo $_POST['na']   //only prints first half of name

So for example, if $name was "Product One" when i print the value in first script it prints Product One fine but when i print in the other script it only prints "Product".  This then leads onto only half the name being copied into a database. 
I'm sure this was working fine before, not sure what the problem here is...

I'm pretty sure the problem is starring me in the face, but I can't seem to locate it.


function filter($string)
{
//swear words pulled from bannedwordlist.com
$f = fopen('../badwords.txt', 'r');
$bad_words = fread($f, filesize('../badwords.txt'));
$bad_words = explode('\n', $bad_words);

$input = strtolower($string);

foreach($bad_words as $value)
{
$string = str_replace($value, '****', $input);
}

return $string;
}


UPDATED CODE

function filter($string)
{
//swear words pulled from bannedwordlist.com
$f = fopen('../badwords.txt', 'r');
$bad_words = fread($f, filesize('../badwords.txt'));
$bad_words = explode('\n', $bad_words);

$input = strtolower($string);
$string = str_replace($bad_words, '****', $input);

return $string;
}


I've already echoed out $value in the foreeach loop, and it does correctly retrieve the bad words and put them into an array. My only problem is, the returned string is still in strtolower() form, and the words aren't censored. :/

Hi there,

I'm making an online clothing store for the brick and mortar shop we have and would like the customer to be able to refine their search by size, colour etc.

The size options will be XS, S, M etc etc where XS is 0, S is 1 and so on. So when they select XS it will add ?size=0 to the URL, if they select XS and S it will be ?size=0;1

What I need to know is how to make some PHP code which can recognise the ; is a break and know that both sizes are selected.

Hope that makes sense and thanks in advance