Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <pre><code>RewriteRule ^([A-Za-z0-9\-]+)/([A-Za-z0-9\-]+)/([0-9]+)/?$ $1.php?$2=$3 </code></pre> <p>The above code would redirect <a href="http://www.mydomain.com/index/eventid/3/" rel="nofollow">http://www.mydomain.com/index/eventid/3/</a> to <a href="http://www.mydomain.com/index.php?eventid=3" rel="nofollow">http://www.mydomain.com/index.php?eventid=3</a></p> <p>htaccess is very flexible, and creating variations of the above is pretty easy once you understand the syntax. You will want to read up on the regular expressions you can use, and the myriad of options the Rewrite module has to offer. Most of my redirects look like the above though, real simple.</p> <p>EDIT: An example of what you're looking for is Wordpress, which uses slugs to identify pages based on something more semantic than an ID number. You would have to url encode the name of the item from the database and either store it in the database as the slug, or find some other way of making it usuable in the database query that retrieves the content of the page. Then your htaccess would look something like this:</p> <pre><code>RewriteRule ^([A-Za-z0-9\-]+)/([A-Za-z0-9\-]+)/?$ $1.php?slug=$2 </code></pre> <p>In your PHP you will need to create slugs and store them in the db so they can be used as IDs in your queries. </p> <p>EDIT2: Try changing your entire htaccess file to just this:</p> <pre><code>&lt;IfModule mod_rewrite.c&gt; RewriteEngine on RewriteCond %{HTTP_HOST} ^www\.yourdomain\.com$ [NC] RewriteRule ^(.*)$ http://yourdomain.com/$1 [R=301,L] RewriteRule ^([A-Za-z0-9\-]+)/([A-Za-z0-9\-]+)/([0-9]+)/?$ $1.php?$2=$3 &lt;/IfModule&gt; </code></pre> <p>I have tested it and it works. Something else in your htaccess is messing it up. </p>
    singulars
    1. This table or related slice is empty.
    1. PORemoving .php extension in URLs
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USEric
    1. USEric
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PORemoving .php extension in URLs
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COYa. I worked with it in Python framework - Django. It was really simple in that one. But now, I'm doing it in PHP, so was having problems. I also wanted to know how can i change my `../index.php?eventid=3` part to `../index/thateventname`[where `thateventname` could be access from the database].
      singulars
      1. PO
      1. USxan
    2. COYour first code (without the slug one), is not working. IF I try `www.mydomain.com/events/eventid/8` instead of `www.mydomain.com/events.php?eventid=8`, it is not opening the page.
      singulars
      1. PO
      1. USxan
    3. COThat is because I forgot to add a question mark after the last trailing slash to make it optional. While flexible, htaccess is also strict. I edited my code above.
      singulars
      1. PO
      1. USEric
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload