Reply
Meta tags in MySQL
Old 04-18-2007, 04:03 AM Meta tags in MySQL
dartdesign's Avatar
Experienced Talker

Posts: 39
Name: Kaloyan Banev
Hello,

I am working over a website that uses a CMS, but this CMS seems to be not search engine friendly. Is it possible to add meta tags in MySQL database and if it is how can i do it ?

King regards...
dartdesign is offline
Reply With Quote
View Public Profile
 
When You Register, These Ads Go Away!
Old 04-18-2007, 05:52 AM Re: Meta tags in MySQL
chrishirst's Avatar
Super Moderator

Posts: 13,517
Location: Blackpool. UK
Obviously it is very simple in MYSQL, just add the required tables to the database.
My method is to have a table comprising of a keywords column and an ID column with a mapping table of document ID to word ID (one to many relation)
For descriptions the same applies, description text and ID with a map table for document to descript. But here I can use either a one to one relation or a many to one.

But I suspect the question you are really asking is "How can I add it to my CMS"?
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
Indifference will be the downfall of mankind, but who cares?
Code Samples | People Counting System
chrishirst is online now
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 04-18-2007, 11:23 AM Re: Meta tags in MySQL
dartdesign's Avatar
Experienced Talker

Posts: 39
Name: Kaloyan Banev
Thanks for the reply,
I really appreciate it.
Yes the question is "How to put it in my CMS ?"


The main page uses a database and all other sub pages are populated from a php file called content. The biggest part of the content in pages is taken from database. My problem is that i dont know how to put a page titles, because everything is take from the database and content php page. May be i will need a string and additional table in database.

Here is an example from content.php file

<?php
include "mysqlconnect.php";
$lid=$_GET['lid'];
if(isset($lid))
{

$result=mysql_query("select * from mainlinks where lid=$lid");
$row=mysql_fetch_array($result);
$title=$row['linkname'];
$contents=$row['contents'];
}

if($title=="HOME")
{
header("location: index.php");
}
$result1=mysql_query("select * from mainlinks order by orderno");

?>
<HTML>
<HEAD>
<TITLE>finesh finish:: <?php echo $title;?></TITLE>

and this is an example of MySQL database:


INSERT INTO `contents` VALUES ('HOME', NULL, '<P dir=ltr><SPAN style="COLOR: #ffffff">Traditional French Polishing &amp; Decorating Contractors</SPAN></P>');
INSERT INTO `contents` VALUES ('PAINTING AND DECORATING', NULL, NULL);
INSERT INTO `contents` VALUES ('FRENCH POLISHING', NULL, NULL);
INSERT INTO `contents` VALUES ('COMMERCIAL WORK', NULL, NULL);
INSERT INTO `contents` VALUES ('PORTFOLIO', NULL, '<DIV align=center><SPAN style="COLOR: #ffa500; FONT-FAMILY: Arial Black">This Page is Under Construction</SPAN></DIV>');
INSERT INTO `contents` VALUES ('FAQs', NULL, NULL);
INSERT INTO `contents` VALUES ('TESTIMONIALS', NULL, NULL);

Where and how to make this if it is possible ?
dartdesign is offline
Reply With Quote
View Public Profile
 
Old 04-19-2007, 03:09 PM Re: Meta tags in MySQL
chrishirst's Avatar
Super Moderator

Posts: 13,517
Location: Blackpool. UK
It will mainly need the tables setting up then some "JOIN" queries coding to pull in and save the extra data.

Then adding the fields into the display loops.

More of a PHP issue than anything, (I'll move this thread there)

Have you checked if there is something already coded for the CMS you are using ?
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
Indifference will be the downfall of mankind, but who cares?
Code Samples | People Counting System
chrishirst is online now
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Reply     « Reply to Meta tags in MySQL
 

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off




   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML

 


Page generated in 0.12561 seconds with 12 queries