PHP - Want Seo Friendly Url ,

Here is what I am trying to do.   Get from this http://mysite.com/po...&title=postname   to this http://mysite.com/post/12/postname/     here’s the rewrite rule.

Options +FollowSymLinks

RewriteEngine On

RewriteRule ^post/([a-zA-Z]+)/([0-9]+)/$ post.php?id=$1&title=$2

This is my html link that links to the post.php page.

<a href="post.php?id=12&amp;title=postname">
	Click here to see the post!
</a> 

It does not change the url.      I have also tried it like below and it gives me an internal error.

<a href="post/12/postname">
	Click here to see the post!
</a> 

Can you see what I have done wrong?  Also if the above method for the linking is correct, how do I get the "id" and "title" using the $_GET?    

I don't usually post on "introduce yourself" type areas of forums. But I'm glad I found this place. It's nice to find a community not overrun by trolls and attitudes (ie, Stackoverflow). That's getting sadly rarer lately.   I've been writing/editing PHP for the past 8+ years now, but I still find things I've never done before. Hey, we can't know it all!   Before PHP, I mostly did ASP -- all the way back to my NT4 days.   I see a lot of hosting-related questions around here -- one of my areas of expertise -- so I think I'll stick around to help others.
Edited by kpmedia, 20 December 2014 - 02:16 PM.

Rather than me have all my pages as domain.com/index.php?id=1 etc I would like to pull the id's title from the database to create the URL so that they will look like domain.com/this-is-the-page-name/

Wordpress does it exactly how I want i just need a nudge in the right direction.

Anyone know how to do it or now of a guide to help me.

Thanks

Here's my search form:

    <form action="search" method="get" enctype="multipart/form-data">
      <input type="text" name="string" maxlength="100" /><br /><br />
      <input type="submit" value="Search" />
    </form>

When I submit it, the URL is search.php?string=Bleh

What I would like is for the URL to be search/string/Bleh

I'm already doing this with some other variables, like search/tag/Bleh and search/author/Bleh, instead of search.php?tag=Bleh and search.php?author=Bleh. However, those ones are passed via a link, not a form.

Any ideas?

Can anyone please help me with my code.
I would like to display the data from another column instead of the id in the url generated by the scirpt.

Code: [Select]
<?php
include('/home/arts/public_html/shows/includes/config.db.php');
if ($link){
$rpp = 10; // results per page
$adjacents = 4;
$page = intval($_GET["page"]);
if(!$page) $page = 1;

$reload = $_SERVER['PHP_SELF'];

$sql = "select * from craft_shows WHERE venue_state='MD' order by start_date ";
$result = mysql_query($sql) or die(mysql_error());

// count total number of appropriate listings:
$tcount = mysql_num_rows($result);
    $date = strftime("%b %d, %Y", strtotime($row['start_date']));

echo "<table class='table7' width='100%' cellpadding='5' cellspacing='1'>";
echo "<tr><td>&nbsp;</td><td>Date</td><td>City</td><td>Show Name</td><td>Attendance</td></tr>";
echo "<tr><td colspan='7'><hr></td></tr>";

// count number of pages:
$tpages = ($tcount) ? ceil($tcount/$rpp) : 1; // total pages, last page number
$date = strftime("%b %d, %Y", strtotime($row['start_date']));
$count = 0;
$i = ($page-1)*$rpp;
while(($count<$rpp) && ($i<$tcount)) {
mysql_data_seek($result,$i);
$row = mysql_fetch_array($result);

     $id = $row['id'];
echo "<tr><td>";
    echo "<a href=\"/show_submits/show_detail.php?id=$id\">Details</a>";
echo "</td><td>";
echo strftime('%b %d, %Y', strtotime($row['start_date']));
echo "</td><td>";
echo $row['venue_city'];
echo "</td><td>";
echo $row['show_name'];
echo "</td><td>";
echo $row['num_visitors'];
echo "</td></tr>";
$i++;
$count++;
}
echo "</table>";
echo "<br>";
// call pagination function:
include("pagination1.php");
echo paginate_one($reload, $page, $tpages, $adjacents);
}
?>

I'm currently runing an classifieds ads site, Php + Mysql (no frameworks) Basically i have the ads listing page (ads.php) and the ads details page (ad_detail.php) This is my current .htaccess:

# disable directory browsing
Options All -Indexes

ErrorDocument 400 /error.php
ErrorDocument 401 /error.php
ErrorDocument 403 /error.php
ErrorDocument 404 /error.php
ErrorDocument 500 /error.php
ErrorDocument 502 /error.php
ErrorDocument 504 /error.php

RewriteEngine on

RewriteRule ^(.*)-da([0-9]+)$ ad_detail.php?ad=$2
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule ^([^\.]+)$ $1.php [NC,L]

RewriteRule ^([^\.]+)$ $1.php [NC,L]

The final result is something like this: www.mysite.com/this-is-the-ad-detail-da50555 (the number is the ad id)   What i need is to get this: www.mysite.com/ads/another-ad-detail-da50777 + What can i do in others urls to show like www.mysite.com/about/ instead of www.mysite.com/about (without the /)     I already tried this but doesn't work:

RewriteEngine on
RewriteBase /

RewriteRule -da([0-9]+)/?$ ad_detail.php?ad=$1 [L,QSA]

RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{DOCUMENT_ROOT}/$1\.php -f [NC]
RewriteRule ^(.+?)/?$ $1.php [L]

Edited by asanti, 22 November 2014 - 05:16 PM.

hey guys basically i have a form which searches my news


<form action="" method="GET">
<label for="search">Search: </label><input name="search" id="search" type="text" />
<input value="Search" type="submit" />
</form>


and im not sure the best way around this or if im going around this the right way but when i access

http://localhost/news/seach   (search form)

and press submit after entering a query i want the action to be

http://localhost/news/seach/search query value here

i hope ive explained well enough and someone could help me with this...thank you

Hey everyone,

I am attempting to find the best method to dynamically create seo friendly urls. This is my plan:

Original url:
Code: [Select]
http://www.example.com/index.php?comp=article&view=category&id=1
Make slug from the page's title and add it to url:
Code: [Select]
http://www.example.com/index.php?comp=article&view=category&id=1&/this-title-was-converted-to-a-slug
Finally remove "index.php?comp=article&view=category&id=1&/" from the url using .htaccess:
Code: [Select]
http://www.example.com/this-title-was-converted-to-a-slug
My questions a
Is there a better strategy/technique for accomplishing this? I have done a lot of research and this seems to be the most popular method.

Also since I couldn't do directly put a forward slash right after "&id=1", like so "&id=1/this-title-was-converted-to-a-slug",
I went ahead and added a "&" right after the id number, like so "&id=1&/this-title-was-converted-to-a-slug".
Is this the correct way of doing this?

Any suggestions are appreciated, thank you!

OK, Here is the code

$sql = "SELECT
TrialListing.listingID AS Trial, TrialClass.classID AS Class, place.place_name AS Place,
CONCAT_WS(
' ',
pedigree.pretitle,
pedigree.`Name`) AS Hound,
CONCAT_WS(
' ',
ped2.pretitle,
ped2. NAME
)AS Sire,
CONCAT_WS(
' ',
ped3.pretitle,
ped3. NAME
)AS Dam,
pedigree.Breeder,
pedigree.`Owner`,
CASE
WHEN placement.place_id < 5 THEN
TRUNCATE(TrialClass.number_of_entrants / placement.place_id,2)
WHEN placement.place_id  = 5 THEN
''
ELSE
0
END

AS Score
FROM
TrialListing
Left Join TrialClass ON TrialListing.listingID = TrialClass.listingID

JOIN placement ON placement.event_id = TrialClass.trialClassID
JOIN pedigree ON pedigree.PedigreeId = placement.hound_id
LEFT OUTER JOIN pedigree AS ped2 ON pedigree.SireId = ped2.PedigreeId
LEFT OUTER JOIN pedigree AS ped3 ON pedigree.DamId = ped3.PedigreeId
LEFT JOIN place ON place.place_id = placement.place_id

WHERE
TrialListing.listingID = 11
ORDER BY Class, FIELD(place.place_id, '1', '2', '3', '4', '0')


";      // Database Query  

$result = mysql_query("$sql");  // Database Query result

$num_rows = mysql_num_rows($result);





// Starts the table
echo "<table class=\"clubList\">\n
<tr>
<th>trialID</th>
<th>ClassID</th>
<th>Place</th>
<th>Hound</th>
<th>Sire</th>
<th>Dam</th>
<th>Score</th>

</tr>";

// Create the contents of the table.
for( $i = 0; $i < $row = mysql_fetch_array($result); $i++){




echo "<tr>\n"
        ."<td>".$row["Trial"]."</td>\n" 
        ."<td>".$row["Class"]."</td>\n" 
        ."<td>".$row["Place"]."</td>\n"  
        ."<td>".$row["Hound"]."</td>\n"  
        ."<td>".$row["Sire"]."</td>\n"                
        ."<td>".$row["Dam"]."</td>\n"
        ."<td>".$row["Score"]."</td>\n"  
        ."</tr>";}



echo "</TABLE>";


Here is the output, I added the TrialID & ClassID for informational purposes, they do not need to be displayed in the live table.

trialID ClassID Place Hound Sire Dam Score 11 1 1st Eaton Brook Tug Hill Tatonka Eaton Brook Hickety Hawk Eaton Brook Gunner's Beulah 43.00 11 1 2nd FC North Bend Igloo FC DFJ Murphy White IFC Brad-Ju's Bella Donna 21.50 11 1 3rd FC North Bend Igloo FC DFJ Murphy White IFC Brad-Ju's Bella Donna 14.33 11 1 4th Rail Road Spike VI Elwell's Mike Elwell's Hannah 10.75 11 1 NBQ FC Fish Creek Spike Fish Creek Bull II Fish Creek Susie [H849395] 11 2 1st Enman Hill Sweet Poppy FTCH Straight Arrow Lucky of Coos 32.00 11 2 2nd Fishflakes Penny At Harehaven FTCH Jill's Fair-Isle Spud FTCH Millbridge Brownie 16.00 11 2 3rd Line Elm Flakers IFC Flakers Rex IFC Line Elm Ginger 10.66 11 2 4th FTCH Fareast Mookie FTCH Mellowrun Sly FTCH Cape Breton Maude 8.00 11 2 NBQ FTCH Mellowrun Sly Mellowrun Skylighter FTCH Mellowrun Becka 11 3 1st Bojangle V Lee Otworth Half Acre's Cocoa Candy 23.00 11 3 2nd Gay Doll Gay Roll II Gay Idol 11.50 11 3 3rd Bruce's Blue Lady FC Kilsock's Blue Creek Bart Bishopville's Zippy 7.66 11 3 4th FC Pearson Creek Barbin FC Pearson Creek Barbarian FC B-Line Stubby 5.75 11 3 NBQ Sims Creek Cricket Ronnie Joe Sims Creek Tiny 11 4 1st FTCH Fareast Mookie FTCH Mellowrun Sly FTCH Cape Breton Maude 26.00 11 4 2nd FTCH Mellowrun Sly Mellowrun Skylighter FTCH Mellowrun Becka 13.00 11 4 3rd Fishflakes Penny At Harehaven FTCH Jill's Fair-Isle Spud FTCH Millbridge Brownie 8.66 11 4 4th Enman Hill Sweet Poppy FTCH Straight Arrow Lucky of Coos 6.50 11 4 NBQ Line Elm Flakers IFC Flakers Rex IFC Line Elm Ginger
Below is what I would like to generate. How do I word or nest the proper PHP code/loops to accomplish this?

ClassID

Place Hound Sire Dam Score 1st Eaton Brook Tug Hill Tatonka Eaton Brook Hickety Hawk Eaton Brook Gunner's Beulah 43.00 2nd FC North Bend Igloo FC DFJ Murphy White IFC Brad-Ju's Bella Donna 21.50 3rd FC North Bend Igloo FC DFJ Murphy White IFC Brad-Ju's Bella Donna 14.33 4th Rail Road Spike VI Elwell's Mike Elwell's Hannah 10.75 NBQ FC Fish Creek Spike Fish Creek Bull II Fish Creek Susie [H849395]

ClassID

Place Hound Sire Dam Score 1st Enman Hill Sweet Poppy FTCH Straight Arrow Lucky of Coos 32.00 2nd Fishflakes Penny At Harehaven FTCH Jill's Fair-Isle Spud FTCH Millbridge Brownie 16.00 3rd Line Elm Flakers IFC Flakers Rex IFC Line Elm Ginger 10.66 4th FTCH Fareast Mookie FTCH Mellowrun Sly FTCH Cape Breton Maude 8.00 NBQ FTCH Mellowrun Sly Mellowrun Skylighter FTCH Mellowrun Becka

ClassID

Place Hound Sire Dam Score 1st Bojangle V Lee Otworth Half Acre's Cocoa Candy 23.00 2nd Gay Doll Gay Roll II Gay Idol 11.50 3rd Bruce's Blue Lady FC Kilsock's Blue Creek Bart Bishopville's Zippy 7.66 4th FC Pearson Creek Barbin FC Pearson Creek Barbarian FC B-Line Stubby 5.75 NBQ Sims Creek Cricket Ronnie Joe Sims Creek Tiny

ClassID

Place Hound Sire Dam Score 1st FTCH Fareast Mookie FTCH Mellowrun Sly FTCH Cape Breton Maude 26.00 2nd FTCH Mellowrun Sly Mellowrun Skylighter FTCH Mellowrun Becka 13.00 3rd Fishflakes Penny At Harehaven FTCH Jill's Fair-Isle Spud FTCH Millbridge Brownie 8.66 4th Enman Hill Sweet Poppy FTCH Straight Arrow Lucky of Coos 6.50 NBQ Line Elm Flakers IFC Flakers Rex IFC Line Elm Ginger

Hi all,

I am looking a developing a script that instead of using something like mysite.com/showproduct.php?id=1 I would like it to appear as mysite.com/php-editor

Is their a simple way of doing this? I would still need to pull info from a database so the page would still need to be dynamic, I just want it to appear static!

I am used to using the get id function of php, what would the workaround be? would the id be hidden from the url but still usable in a query?

I have had a look at the apache mod_rewrite, but quite frankly, I dont understand it!

Cheers