Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You could do it the way that you showed above, but for security's sake you would probably want to do it a little different (your way would allow significant opportunity for XSS).</p> <p>Essentially, you will need to set the <code>$_SESSION</code> global variable to have the style, and that should come directly from the database. If it were me, I would do this:</p> <pre><code>&lt;?php echo "&lt;form&gt;"; echo "&lt;select name=\"theme\" id=\"select-theme\"&gt;"; $sql = "select * from theme"; foreach ($dbh-&gt;query($sql) as $row) { ?&gt; &lt;option value="&lt;?php $row['id'] ?&gt;"&gt;&lt;?php echo $row['th_name'] ?&gt;&lt;/option&gt; &lt;?php } echo "&lt;/select&gt;"; echo "&lt;/form&gt;"; ?&gt; </code></pre> <p>Then, on your postback script, do this:</p> <pre><code>&lt;?php if (isset($_POST['theme']) { // Perform query here to get the link's file, using PDO - watch out for XSS // Note - you may have to call session_start() // depending on your php.ini's settings $_SESSION['style'] = $link; } </code></pre> <p>If you are wanting to do this on the fly with jQuery, you can see the information here: <a href="https://stackoverflow.com/questions/7846980/how-do-i-switch-my-css-stylesheet-using-jquery">How do I switch my CSS stylesheet using jQuery?</a></p> <p>In addition, you would want to persist your changes like this:</p> <pre><code>&lt;script type="text/javascript"&gt; $("#select-theme").on("change", function() { $.post({ url:'yoururl.php', data: { theme: $(this).find("option:selected").value() }); }); </code></pre> <p></p>
    singulars
    1. This table or related slice is empty.
    1. POuser chose css file as theme for webpage using SESSION
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USJoseph at SwiftOtter
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTDownMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COyou and I were writing the same answer at the same time, thus, I don't need to post it here. No downvote required.
      singulars
      1. PO
      1. USSithu
    2. COWhat would be XSS prevent in your code? I could not see any difference yours and mine.
      singulars
      1. PO
      1. USSithu
    3. COOh. I just see yours was downvoted. It was not me.
      singulars
      1. PO
      1. USSithu
 

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