PHP - Meta Description Help

Hi.

I'm making a website where users can upload files along with title, description and image.

I can get them making the page (str replace) but I only know how to list the files with just the file title in a basic links directory.
Any ideas how I could include title, description and a picture (as well as the link to the page). Sort of like with Youtube search results or engine001.com/games.htm?

Any help would be greatly appreciated.

Thanks

I have a website here [redacted] and it is an affiliate website where I just find products and promote them. All I have to do is give product a title, affiliate url, the description, an image and a price. I am trying to make the product description area hold more text than it does now, because at the moment in the admin side of my website it says "product description 275 max characters" That is really a short sentence. Can anyone please help me I have no php skills but really wish I did, if you need more info I will be happy to share anything I need to. 

Edited October 27, 2019 by requinix
removed link

Hi,

I have a little problem that I can't seem to solve myself. My coding skills are very limited, just wanted to mention that  .

I have a list of rows, bascially banners that members submit. They have to be manually approved by me before they are put on air. So to quicken up
this process I made this little code in my admin panel.


$bq = mysql_query("SELECT id, usrid, bname, burl, btarget  FROM ban_rotator WHERE status = 'Waiting'");
$pb = mysql_num_rows($bq);
if ($_GET['ap']) 
{ 
$bid = $_GET['ap'];
  mysql_query("UPDATE ban_rotator SET status = 'Active' WHERE id = '$bid'");


It works perfectly except for one thing. It will always show the banner I just approved in addition to the remaining ones that are waiting. Any tips would be appreciated. I have to add that this code is a part of a fairly large admin panel php file.

Just realized i need a bit more explanation. If I hit refresh in the browser the one I just approved will be gone. As I would like it to be after hitting Approve on the banner in question. If I just approve the second banner (after approving the first), the first will be gone from the list of waiting and the second will still show until I either hit approve on the third or hit refresh in the brower.

Alka

G'day all, i've got this script that I found on the net some time back but not entirely sure where, however it works well except I want to add a feature so it shows the image details from a txt file. Here is the gallery script:

<?php

function getDirectory( $path = '.', $level = 0 ){ 
    $ignore = array( 'cgi-bin', '.', '..' ); 
    $dh = @opendir( $path ); 
    while( false !== ( $file = readdir( $dh ) ) ){ 
        if( !in_array( $file, $ignore ) ){ 
            if( is_dir( "$path/$file" ) ){ 
$dir = $path . $file; 
                echo "<h2>$file</h2><p>"; 
                $dh1 = @opendir( $dir ); 
                while( false !== ( $image = readdir( $dh1 ) ) ){ 
                    if( !in_array( $image, $ignore ) ){ 
                        if( !is_dir( "$dir/$image" ) ){ 
      if (preg_match("/.jpg/", $image)) {
echo "<a href=\"$dir/$image\" rel=\"lightbox\"><img src=\"gallery-thumbnail.php?file=$file/$image\" border=2 style='border-color: #981C1E'></a>\n"; 
}
                        } 
                    } 
                } 
echo "</p>";
                $level++; 
            } 
        } 
    } 
    closedir( $dh ); 
} 
getDirectory('gallery/'); 
?>


Now, what i'm wanting is to read a txt file either in the root or 'gallery' directory, where it has the file name, title, description, photographer. (something like filename.jpg|title of image|description about image|J King).
so when the image is displayed, a script reads the text file and will show the image info beside it.

Now i've got this bit of snippet from an old script I used once, but can't seem to get it to work anywhere, so any help is greatly appreciated.

$text = "gallery.txt";

$fh=fopen($text, "r"); 

while(!feof($fh)) 
{ 
  $temp = explode("|", $line); 
  $title[$temp[0]] = $temp[1];
  $description[$temp[0]] = $temp[2];
  $photographer[$temp[0]] = $temp[3];
  $line=fgets($fh); 
  unset($temp); 
} 

hi all,   Firstly I am new to the php language, hopefully this is not a silly question or a no brainer.   I have looked over my code.. and for some reason when I insert data from a cms into a mySql database thers two fields that swop around..   HERES THE CODE IM WORKING WITH :

<?php

//if form has been submitted process it
if(isset($_POST['submit'])){

		$_POST = array_map( 'stripslashes', $_POST );

		//collect form data
		extract($_POST);

		//very basic validation
		if($title ==''){
			$error[] = 'Please enter the title.';
		}


		if(!isset($error)){

			try {

				//insert into database
				$stmt = $handler->prepare('INSERT INTO event_calendar (title,event_date,description) VALUES (:title, :description, :event_date)') ;
				$stmt->execute(array(
					':title' => $title,
					':description' => $description,
					':event_date' => date('Y-m-d')
				));

				//redirect to index page
				header('Location: index.php?action=added');
				exit;

			} catch(PDOException $e) {
			    echo $e->getMessage();
			}

		}

	}

	//check for any errors
	if(isset($error)){
		foreach($error as $error){
			echo '<p class="error">'.$error.'</p>';
		}
	}
	?>
	<form action='' method='post'>

		<p><label>Title</label>	<input type='text' name='title' value='<?php if(isset($error)){ echo $_POST['title'];}?>'></p>

		<p><label>Description</label><br />
		<textarea name='description' cols='50' rows='5'><?php if(isset($error)){ echo $_POST['description'];}?></textarea></p>

		<p><label>Date of Event : (y-m-d) :</label><input name="event_date" type="date" value='<?php if(isset($error)){ echo $_POST['event_date'];}?>'></p>

		<p><input type='submit' name='submit' value='Submit'></p>

	</form>

Could anyone please just look through it.. My database structure is simple.. id, title, description, event_date Thanks in advance  

I would like to be able to have my meta data pick out the information of a page and insert it into the meta tags.
I have a controller class which has the coding to get the data, which is this:
controller.class.php
Code: [Select]
function get_title(){

$title='';

if (isset($this->_params['item']['meta_title'])  && !empty($this->_params['item']['meta_title'])){

$title=$this->_params['item']['meta_title'];


}

$title=strip_tags($title);

$title=str_replace('"', '\'', $title);

$title=trim($title);

if (strlen($title)>150){

$end_of_last_sentence=strpos($title, '.', 150)+1;

if ($end_of_last_sentence<150){

$end_of_last_sentence=150;

}

$title=substr($title, 0, $end_of_last_sentence);

}

return $title;
}


function get_description(){


$description='';

if (isset($this->_params['item']['meta_description'])  && !empty($this->_params['item']['meta_description'])){

$description=$this->_params['item']['meta_description'];

}

$description=strip_tags($description);

$description=str_replace('"', '\'', $description);

$description=trim($description);

if (strlen($description)>150){

$end_of_last_sentence=strpos($description, '.', 150)+1;

if ($end_of_last_sentence<150){

$end_of_last_sentence=150;

}

$description=substr($description, 0, $end_of_last_sentence);

}

return $description;

}


function get_keywords(){

$keyword='';

if (isset($this->_params['item']['meta_keyword'])  && !empty($this->_params['item']['meta_keyword'])){

$keyword=$this->_params['item']['meta_keyword'];


}

$keyword=strip_tags($keyword);

$keyword=str_replace('"', '\'', $keyword);

$keyword=trim($keyword);

if (strlen($keyword)>150){

$end_of_last_sentence=strpos($keyword, '.', 150)+1;

if ($end_of_last_sentence<150){

$end_of_last_sentence=150;

}

$keyword=substr($keyword, 0, $end_of_last_sentence);

}

return $keyword;
}


Then I have a pages.controller which has the coding for the home page

pages.controller.php
Code: [Select]
public function home(){
//instantiate a model
$galleries_model = new galleries_model('galleries');
$galleries = $galleries_model -> get_all();


foreach($galleries as $gallery){


//how to loop through an image so that only the first
//image is selected
$sql = "SELECT image_path FROM gallery_images
WHERE
gallery_id = {$gallery['id']}
ORDER BY order_by";

$image = $this->_model->get_one($sql);

$gallery['image'] = $image;
$this->_params['list'][] = $gallery;

}

$this->_params['item'] = $this->_model->get(array("pages.name = 'home'"));

}

Code: [Select]
galleries.controller.php
public function galleries(){

$galleries = $this->_model->get_all();


$this->_params['list'] = $galleries;


}

public function view($gallery_id){

$this->_params['item'] = $this->_model->get($gallery_id);

$this->_params['item'] ;
//die;

}
   

This is my default page where I want the meta tags to echo out the relevent information

default.php
Code: [Select]
!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title><?php echo $this->get_title(); ?></title>
<meta name="Description" content="<?php echo $this->get_description(); ?>" />
<meta name="Keywords" content="<?php echo $this->get_keywords(); ?>" />
<title>Welcome to the Framework</title>
<?php
$this->_page->add_javascript('/vendor/lightbox/js/jquery.lightbox-0.5.min.js');
$this->_page->add_stylesheet('/vendor/lightbox/css/jquery.lightbox-0.5.css');
echo $this->page('stylesheets');
echo $this->page('javascripts');
?>

</head>
<body>


<h1>
Welcome to the My site
</h1>


<?php echo $this->page('view');?>
</body>
</html>

In the pages.controller.php  I managed to get it to work using $this->_params['item'] = $this->_model->get(array("pages.name = 'home'"));

I want to be able to do the same thing on different pages but I can't get it to work.

I hope I explained it clearly.

Thank you

Ok so i'm not a programmer of any kind however I'm trying to enter what I believe is HTML generated metadata into the header.php of my wordpress theme

here is how the wordpress header reads

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" <?php language_attributes(); ?>>
<head profile="http://gmpg.org/xfn/11">
    <title><?php
   if ( is_single() ) { single_post_title(); }       
        elseif ( is_home() || is_front_page() ) { bloginfo('name'); print ' | '; bloginfo('description'); get_page_number(); }
        elseif ( is_page() ) { single_post_title(''); }
        elseif ( is_search() ) { bloginfo('name'); print ' | Search results for ' . wp_specialchars($s); get_page_number(); }
        elseif ( is_404() ) { bloginfo('name'); print ' | Not Found'; }
        else { bloginfo('name'); wp_title('|'); get_page_number(); }
    ?></title>
      
   
   <meta http-equiv="content-type" content="<?php bloginfo('html_type'); ?>; charset=<?php bloginfo('charset'); ?>" />

AND HERE IS WHAT I WANT TO PLACE I just don't know where I put it.  It gives me Syntax errors when I paste just above the last title tag....does it need to be in php form and if so how do i change it?  thanks for anyones help, sorry if this is a lame question but I've been slapping my head against a wall for 4 hours now

Page: http://www.dylanpatrickarts.com/
<title>NYC Headshots, Lifestyle Portraits, Corporate, PR, Live Music</title>
<meta name="description" content="Providing quality affordable NYC Headshots to the working actor, as well as Lifestyle Photography, Corporate Photography, Public Relations Photography, and much more!  I strive to push my creative potential at all times, while having fun doing it!">
<meta name="keywords" content="photography,wedding photography,headshots,headshot,actors headshot,headshots nyc,nyc headshots,new york city headshot photography,headshot photographers in new york city,portraits,portrait,portrait photographer,hospitality photography,live music photography,public relations photography">

====================================================================================================================
Page: http://www.dylanpatrickarts.com/galleries/headshots/
<title>NYC Headshots</title>
<meta name="description" content="A collection of NYC Headshots for actors, dancers, and models">
<meta name="keywords" content="headshots,headshot,good headshots examples,actors headshots,actors headshot,headshots nyc,nyc headshots,new york city headshot photography,headshot photographers in new york city,new york headshots,actors,headshot photography,headshot photography in nyc,affordable headshots,affordable headshots nyc">

====================================================================================================================
Page: http://www.dylanpatrickarts.com/galleries/
<title>Portfolio</title>
<meta name="description" content="A collection of NYC Headshots, People Photography, Live Music Photography, Scenic Photography, and Public Relations Photography, as well as a gallery for you to buy prints!">
<meta name="keywords" content="headshots,actors headshots,actors headshot,headshots nyc,headshot photographers in nyc,portrait photography,abstract photography,scenic stock photography,live music photography,music photography,hospitality photography,hotel photography,public relations,cocktail photography,buy print photography">

====================================================================================================================
Page: http://www.dylanpatrickarts.com/galleries/people/
<title>People</title>
<meta name="description" content="A collection of Portraits, Candids, and Outtakes">
<meta name="keywords" content="people photography,people stock photography,black white photography of people,portrait photography,family portrait photography,headshots,headshot,actors headshot,actors headshots,photographers in new york city,new york city corporate photographer,headshot photographers in new york city,dylan,candids">

====================================================================================================================
Page: http://www.dylanpatrickarts.com/galleries/live-music/
<title>Live Music</title>
<meta name="description" content="A collection of Live Music work in NYC">
<meta name="keywords" content="music photography,photography,live music photography,live music nyc,new york city live rock music,bleecker street">

====================================================================================================================
Page: http://www.dylanpatrickarts.com/galleries/pr-work/
<title>PR Work</title>
<meta name="description" content="A collection of public relations and hospitality work.  ">
<meta name="keywords" content="public relations,public relations photography,hospitality,hospitality photography,cocktails,cocktail,dylan,bentley,clients,empire">

====================================================================================================================
Page: http://www.dylanpatrickarts.com/galleries/tear-sheets/
<title>Tear Sheets</title>
<meta name="description" content="A collection of published work">
<meta name="keywords" content="tear sheets,photography,actors headshots,actors headshot,headshot,headshots,headshots nyc,nyc headshots">

====================================================================================================================
Page: http://www.dylanpatrickarts.com/galleries/scenic-artistic/
<title>Scenic & Artistic</title>
<meta name="description" content="A collection of scenic and artistic work.  Certain photos also available for purchase!">
<meta name="keywords" content="scenic stock photography,scenic photography,scenic photography for sale,abstract photography,artistic photography,hdr photography,hdr photography galleries,examples of hdr photography,scenic,new york city,new york city skyline,san francisco,idaho">

====================================================================================================================
Page: http://www.dylanpatrickarts.com/galleries/buy-prints/
<title>Buy Prints</title>
<meta name="description" content="A collection of available prints for purchase.">
<meta name="keywords" content="web site shopping cart,shopping cart,buy photography,buy scenic photography">

====================================================================================================================
Page: http://www.dylanpatrickarts.com/your-shoot/
<title>Your Shoot</title>
<meta name="description" content="Details about your headshot session.">
<meta name="keywords" content="headshots nyc,nyc headshots,headshots,headshot,actors headshots,actors headshot,information,clients,consultation,dylan,people,portfolio,testimonials">

====================================================================================================================
Page: http://www.dylanpatrickarts.com/pricing/
<title>Pricing</title>
<meta name="description" content="Pricing information for headshot sessions">
<meta name="keywords" content="headshot pricing,pricing information,nyc headshots,headshots,headshot,actors headshot,photography prices,digital photography prices,prices for photography,headshot photography prices,nyc headshot photography prices,wardrobe,session">

====================================================================================================================
Page: http://www.dylanpatrickarts.com/testimonials/
<title>Testimonials</title>
<meta name="description" content="Testimonials from some of my wonderful clients!">
<meta name="keywords" content="testimonials,testimonial,photographer testimonials,headshots,headshot,actors headshots,actors headshot,headshot photographers in nyc,headshot photography in nyc,nyc headshot photographers,headshots nyc,nyc headshots,photographer,dylan,amazing">

====================================================================================================================
Page: http://www.dylanpatrickarts.com/resources/
<title>Resources</title>
<meta name="description" content="A few links to photographers, and some cool places">
<meta name="keywords" content="photography links,headshots,headshot,actors headshot,actors headshots,headshot photographers in nyc,nyc headshot photographers,acting schools links,the empire hotel,the empire hotel new york">

====================================================================================================================
Page: http://www.dylanpatrickarts.com/blog/
<title>Blog</title>
<meta name="description" content="Official Blog for Dylan Patrick Photography">
<meta name="keywords" content="blog,photography blogs,blogs on photography,photography,portraits,portrait,portrait photographer,portrait photographers,headshot photographers in nyc,headshot photographers in new york city,nyc headshot photographers,headshots nyc,nyc headshots,headshots,headshot">

====================================================================================================================
Page: http://www.dylanpatrickarts.com/about/
<title>About Dylan</title>
<meta name="description" content="A short bio about Dylan Patrick">
<meta name="keywords" content="nyc headshots,dylan patrick arts,dylan patrick photography,headshot photographers in nyc,headshot photographers in new york city,nyc headshot photographers,headshot,headshots,actors headshot,actors headshots">

====================================================================================================================
Page: http://www.dylanpatrickarts.com/contact/
<title>Contact</title>
<meta name="description" content="Contact information for Dylan Patrick">
<meta name="keywords" content="contact info,headshot photographers in nyc,headshot photographers in new york city,nyc headshot photographers,portraits,portrait,portrait photographers">

====================================================================================================================
Page: http://www.dylanpatrickarts.com/shopping-cart/
<title>Shopping Cart</title>
<meta name="description" content="Your Shopping Cart">
<meta name="keywords" content="web site shopping cart,shopping cart,buy photography,buy scenic photography">

Hi there,

Please forgive my ignorance as i am a noob.

I have a website and the page title, keywords and description are taken from this .conf file:


base = /home/websitem/public_html/worms/
url = http://www.websitemakeover.co.za/worms/

host = localhost
user = websitem_worms
pass = *****
data = websitem_worms

subject = The Organic Grow Shop
shop_email = do-not-reply@organicgrowshop.co.uk
shop_name = The Organic Grow Shop
domain = websitemakeover.co.uk
admin_email = ron@rondarby.com
subjectToClient = Your Purchase from The Organic Grow Shop
subjectToAdmin = A purchase was made on the website

pay_email = ron_1320155944_biz@rondarby.com
pay_currency = GBP
#pay_url = https://www.paypal.com/cgi-bin/webscr
pay_url = https://www.sandbox.paypal.com/cgi-bin/webscr

[home]
title = Buy worm castings, perlite, vermiculite, clay pebbles
keywords = Worm castings, perlite, guano, organic gardening, hydroponic growing media, soil mixes, plagron, bio bizz, all-mix, organic fertilisers, organic nutrients, hydroponics.
description = We sell organic fertilisers, worm castings, guano, perlite, vermiculite, clay pebbles, soil enhancers and conditioners to make your own soil mixes

[about]
title = About Us
keywords = Worm castings, perlite, guano, organic gardening, hydroponic growing media, soil mixes, plagron, bio bizz, all-mix, organic fertilisers, organic nutrients, hydroponics.
description = We sell organic fertilisers, worm castings, guano, perlite, vermiculite, clay pebbles, soil enhancers and conditioners to make your own soil mixes

[contact]
title = Contact Us
keywords = Worm castings, perlite, guano, organic gardening, hydroponic growing media, soil mixes, plagron, bio bizz, all-mix, organic fertilisers, organic nutrients, hydroponics.
description = Contact The Organic Grow Shop here. An organic grow shop representative will be in touch shortly.

[casting]
title = Worm Castings - Buy worm castings, organic soil mix at The Organic Grow Shop. Made in the UK!
Keywords = Worm castings, worm tea, worm poop for hydroponics, soil mixes, plagron bat mix, organic fertiliser, vermicompost, worm castings uk, organic soil mix cannabis, organic soil, worm cast, organic soil mix, soil mixes, organic soils, natural fertilisers.
description = Worm castings - mmm, wormy goodness. We've teamed up with our local worm farm to bring your this fantastic 100% natural organic plant fertilser and soil conditioner to make your own soil mixes.

[perlite]
title = Perlite - Buy Perlite, Vermiculite. 

[cart]
title = Shopping Basket

[checkout]
title = Details to Checkout

[paypal]
title = Redirect to PayPal


I have tried editing it but the titles don't change??  Do i need to do something else to get this to change?

Your help would be really appreciated, desperately need to get this sorted!

Matt

hi guys

what is the difference between setting the php charset header, and setting the html meta charset?

I am using a script that get the field names from a table in a database. It works, however, when I try to remove the underscore(_) from the name. I get an error message.

Quote

Parse error: syntax error, unexpected '=' in C:\xampp\htdocs\CMS\admin\includes\get_table.php on line 76


This is the section of code that I am using it with
Code: [Select]
$i = 2;
        while ($i < mysql_num_fields($fieldnamesquery_result)) {
            $meta = mysql_fetch_field($fieldnamesquery_result, $i);

// This is the line of code that I am having problems with
$meta.name = str_replace("_", " ", $meta.name);

            if (!$meta) {
                echo "No information available";
            }

            $tablecolumn .= "<p>" . $meta->name . ":<input type='text' name='" . $meta->name . "' id='" . $meta->name . "'/></p>";
            $i++;

hello guys, i have a php website, which is: www.hireasunbed.co.uk

the middle is like an iframe but im wondering how can i get each catagory have diffrent meta keywords and descriptions. Is this possible?

Hi Everyone,

I need some help which I think should not take long to figure out but I need help with it regardless. This is through wordpress.

My issue is that my navigation has categories. Like Web design, Web Marketing, and Graphic design.

I downloaded All in one SEO pack and everything is great up to the point where I can't add a title to the categories.

When you click on the categories in the navigation the title doesn't change to what I set it to. But the description and all other meta tags are fine.

I do have:

Code: [Select]
<head profile="http://gmpg.org/xfn/11">
<link rel="shortcut icon" href="http://www.newmediasources.ca/images/pt-logo.png"/>
<title><?php wp_title('&laquo;', true, 'right'); ?> <?php bloginfo('name'); ?></title>
<?php wp_head(); ?>
<link href="<?php bloginfo('template_directory'); ?>/style.css" rel="stylesheet" type="text/css" />
<link href="<?php bloginfo('template_directory'); ?>/css/ddsmoothmenu.css" rel="stylesheet" type="text/css" />
<link href="<?php bloginfo('template_directory'); ?>/css/prettyPhoto.css" rel="stylesheet" type="text/css" />
<link href="<?php bloginfo('template_directory'); ?>/css/nivo-slider.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="<?php bloginfo('template_directory'); ?>/js/jquery-1.4.2.min.js"></script>
<script type="text/javascript" src="<?php bloginfo('template_directory'); ?>/js/jquery.form.js"></script>
<script type="text/javascript" src="<?php bloginfo('template_directory'); ?>/js/ddsmoothmenu.js"></script>
<script type="text/javascript" src="<?php bloginfo('template_directory'); ?>/js/jquery.nivo.slider.pack.js"></script>
<script type="text/javascript" src="<?php bloginfo('template_directory'); ?>/js/jquery.prettyPhoto.js"></script>
<script type="text/javascript" src="<?php bloginfo('template_directory'); ?>/js/custom.js"></script>
<script type="text/javascript" src="<?php bloginfo('template_directory'); ?>/js/cufon-yui.js"></script>
<script type="text/javascript" src="<?php bloginfo('template_directory'); ?>/js/Museo_Slab_500_400.font.js"></script>
<!-- Cufon init -->
<script type="text/javascript">
<?php if(get_option('boldy_cufon')!="no"):?>
Cufon.replace('h1',{hover: true})('h2',{hover: true})('h3')('.reply',{hover:true})('.more-link');
<?php endif ?>
</script>
<script type="text/javascript">
$(document).ready(function(){
  $('#quickContactForm').ajaxForm(function(data) {
if (data==1){
$('#success').fadeIn("slow");
$('#bademail').fadeOut("slow");
$('#badserver').fadeOut("slow");
$('#contact').resetForm();
}
else if (data==2){
$('#badserver').fadeIn("slow");
  }
else if (data==3)
{
$('#bademail').fadeIn("slow");
}
});
});
</script>
<link rel="pingback" href="<?php bloginfo('pingback_url'); ?>" />
<?php wp_get_archives('type=monthly&format=link'); ?>
<?php //comments_popup_script(); // off by default ?>

</head>
in header.php so it should be okay. I tried removing the title tag thinking it will add it itself but it didn't. Any ideas?

Thank you for your time.

Hello again:]

I am wondering where should i put valid doctype
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
and meta tags
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

in a php file like this.

Code: [Select]
<?php

session_start(); // Session starts here
if(!isset($_SESSION['username'])) // If there is no session then...
{
    die ("<div align='center'><img src='images/LOGINKITTEN.jpg'/><br /><a href='index.php'><img src='images/Login.jpg'/></a></div>"); // ...Die!
} 

$id = $_GET['id'];

?>
<html>
<head>

<link rel="stylesheet" type="text/css" href="jamcss.css" />

</head>
<body>

<img src="images/jamspace.jpg" />
<div id="jamcontainer">
<b><a href="main.php">Home</a>  ||  <a href="members.php">Members</a>  ||  <a href="jams.php">Jams</a>  ||  <a href="uploadjamform.php">Upload Jam</a>  ||  <a href="myprofile.php">My profile</a>  ||  <a href="about.php">About</a>  ||  <a href="adminindex.php">Moderators</a> ||  <a href="logout.php">Logout</a></b> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; You are logged in as <?php echo $_SESSION['username']; ?>
<br /><br />

<?php

$connection = mysql_connect("lol.com", "loldb", "lol00") or die ("Could not connect");
mysql_select_db("loldb", $connection) or die("Could not connect");

// mysql query to get the username
$query = mysql_query("SELECT * FROM news ORDER BY id DESC");
$numrows = mysql_num_rows($query);



if ($numrows!=0)
{
// fetching data from the database to variable
while ($row = mysql_fetch_assoc($query))
{
$title = $row['title'];
$post_owner = $row['post_owner'];
$post = $row['post'];
echo "<b>" . $title . "</b><br />";
echo "Posted by <b>" . $post_owner . "</b><br /><br />";
echo $post . "<hr></hr><br /><br />";
}
}

?>
</div>
</body>
</html>

Hello Every one
 
 
Please see my code

<?php
include ("includes/config.php");
$afurl = $_SERVER['REQUEST_URI'];
$afurl = preg_replace('/\/+/', '', $afurl);
$afurl = preg_replace('/\;+/', '', $afurl);
$afurl = preg_replace('/\&+/', '', $afurl);
$afurl = preg_replace('/\#+/', '', $afurl);
$afurl = preg_replace('/\|+/', '', $afurl);
$afurl = preg_replace('/\@+/', '', $afurl);
$afurl = preg_replace('/\%5B+/', '', $afurl);
$afurl = preg_replace('/\%5D+/', '', $afurl);
$afurl = preg_replace('/\%27+/', '', $afurl);
$afurl = preg_replace('/\%C2+/', '', $afurl);
$afurl = preg_replace('/\%BB+/', '', $afurl);
$afurl = preg_replace('/quot+/', '', $afurl);
$afurl = preg_replace('/\%E2+/', '', $afurl);
$afurl = preg_replace('/\%80+/', '', $afurl);
$afurl = preg_replace('/\%93+/', '', $afurl);
$afurl = preg_replace('/\$+/', 'c', $afurl);
$afurl = preg_replace('/\"+/', '', $afurl);
$afurl = preg_replace('/\?+/', '', $afurl);
$afurl = preg_replace('/\.html+/', '', $afurl);
$afurl = preg_replace('/\-+/', ' ', $afurl);
$queryArray = explode(" ", $afurl);
for ($i=0; $i< count($queryArray); $i++) {
$keyworddd = mysql_real_escape_string($queryArray[$i]).",";
echo $keyworddd;
}
?>

I Want Set $keyworddd at he       <meta name="keywords" content="$keyworddd">     Can anyone tell me how to do this please?