Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
0 votes
in Q2A Core by

I'm fairly new to php and I'm having problems understanding how to grab content from the DB using qa functions.

I'm trying to display a random user on the homepage and have sucsessfully connected and displayed content from the database using the following code in the qa-theme.php

Can you tell me of any protential problems connecting to the DB in this way, security e.t.c

Thanks in advance

function main(){
          $con = mysqli_connect("localhost","user","password","database");
          // Check connection
          if (mysqli_connect_errno()) {
          echo "Failed to connect to MySQL: " . mysqli_connect_error();
     $result = mysqli_query($con,"SELECT * FROM qa_users");
     echo "<table border='1'>
     <th>User ID</th>
     while($row = mysqli_fetch_array($result)) {
          echo "<tr>";
          echo "<td>" . $row['userid'] . "</td>";
          echo "<td>" . $row['handle'] . "</td>";
          echo "</tr>";
     echo "</table>";
     else {
Q2A version: 1.6.2
Is this "homepage" a Q2A page, or is it outside of Q2A?
I have added the code to the qa-theme.php file so, I guess yes it is within a Q2A page.

1 Answer

+2 votes
There is no need of mysql connection if you are writing in qa-theme.php

Use built in function for query such as qa_db_query_sub () etc.

Something like..

$query = "SELECT * FROM ^users....";

qa_db_query_sub ($query);
Thanks but, that's what I'm having trouble with :) reading other peoples code confuses me at the level I'm currently at. I can't figure out how to convert the code in my question into something you have posted.
Would the way I did it cause any problems?