URL friendly from DB, php and .htaccess

Question

can help me? I've a site url like:

http://www.example.com/episodio/ID

ID = row number from Database.

I want to display the page title.

I've this:

.htaccess file:

RewriteEngine on
RewriteRule ^episodio/(\w+)/?$ episodio.php?id=$1

php file:

$sql = "SELECT * FROM "episodios" WHERE serie = ".$id." AND temporada = ".$i." ORDER BY "episodio" ASC";
            $result = $conn->query($sql);
                if ($result->num_rows > 0) {
                while($row = $result->fetch_assoc()) {
                    if ($row['episodio'] == 0) {
                        echo '<a href="episodio/'.$row["id"].'"><li><strong>Episodio doble:</strong> '.$row["nombre"].'<img src="http://www.example.net/img/play.png" class="img-play"></li></a>';
                    }else{
                        echo '<a href="episodio/'.$row["id"].'"><li><strong>Episodio '.$row['episodio'].':</strong> '.$row["nombre"].'<img src="http://www.example.net/img/play.png" class="img-play"></li></a>';
                    }
            ?>
            <?php } ?>

Dimas Pante · Accepted Answer · 2015-01-23 22:49:35Z

1

You're using $_GET in your ID anywhere before this code?

I mean, $_GET['id'].

Most PHP versions (since 4...) doesn't catch the var just for its name.

edited Jan 23, 2015 at 22:49

answered Jan 23, 2015 at 21:52

Dimas Pante

2,53124 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Ferrmolina Over a year ago

I must get the id first?

Dimas Pante Over a year ago

Yep. Your problem may be on WHERE serie = ".$id.", probably the var wasn't stored.

Dimas Pante Over a year ago

Another thing, be careful using variables right into your sql. As you seems to be using MySQLi, might want to use prepare first.

Nadav S. Over a year ago

"Some PHP versions"? Is there any PHP version that does?

Dimas Pante Over a year ago

Yes. PHP 4 had some versions that accepted this... Sure, nobody uses it anymore, just had to be sure :P

Kevin_Kinsey · Accepted Answer · 2015-01-23 21:55:17Z

0

I'd recommend getting all your variables from the DB first, and then printing out the HTML (perhaps from a template file). We assume that $row contains more than just an ID? Perhaps an "título del episodio", also?

if ($result->num_rows > 0) {
    $episodios = array();
    $x = 0;
    while($row = $result->fetch_assoc()) {
        $episodios[$x]['id'] = $row['id'];
        if ($x == 0) {
            $PageTitle = $row['title'];
        }
        $x++;
    }

Then your template can use $PageTitle (from the first episode), and you can loop through the $episodios array to construct the links for the other episodes.

answered Jan 23, 2015 at 21:55

Kevin_Kinsey

2,3101 gold badge24 silver badges23 bronze badges

Collectives™ on Stack Overflow

URL friendly from DB, php and .htaccess

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related