Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

PHP Forum


You are currently viewing our PHP Forum as a guest. Please register to participate.
Login



Freelance Jobs

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

Posts: 39
Name: Kaloyan Banev
Trades: 0
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...
__________________

Please login or register to view this content. Registration is FREE


Please login or register to view this content. Registration is FREE
dartdesign is offline
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 04-18-2007, 05:52 AM Re: Meta tags in MySQL
chrishirst's Avatar
Missing! presumed drunk.

Posts: 42,385
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
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. ->>
Please login or register to view this content. Registration is FREE
<<-

A foolish consistency is the hobgoblin of little minds
Thought for today:- Is SEO the only industry where all the cowboys are Indians?
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
Trades: 0
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 ?
__________________

Please login or register to view this content. Registration is FREE


Please login or register to view this content. Registration is FREE
dartdesign is offline
Reply With Quote
View Public Profile
 
Old 04-19-2007, 03:09 PM Re: Meta tags in MySQL
chrishirst's Avatar
Missing! presumed drunk.

Posts: 42,385
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
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. ->>
Please login or register to view this content. Registration is FREE
<<-

A foolish consistency is the hobgoblin of little minds
Thought for today:- Is SEO the only industry where all the cowboys are Indians?
chrishirst is online now
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Reply     « Reply to Meta tags in MySQL
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

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

BB 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.33043 seconds with 12 queries