PHP - Two Near Identical Scripts. One Works, One Doesn't

Hi,

My site was working fine, but I just switched servers/web hosts and now I'm getting the following errors (in blue). The thing is, I don't get the error if I try to run the query loop after just using 'mysql_select_db' once, but if I use it again to select a different database and then run the query loop, I start getting the error.

Code: [Select]
mysql_select_db ("database1", $mysql_con);

$mysql_query = mysql_query ("SELECT ID FROM someTable1", $mysql_con);
$someVar1 = 0;

while ($mysql_array = mysql_fetch_array ($mysql_query))
{
$someVar1 ++;
}


////// The above code gives me no error. But If I then try to select a different database and run a loop in the same way (in the same file), I start getting the below error...


mysql_select_db ("database2", $mysql_con);

$mysql_query = mysql_query ("SELECT ID FROM someTable2", $mysql_con);
$someVar2 = 0;

while ($mysql_array = mysql_fetch_array ($mysql_query))
{
$someVar2 ++;
}
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/snubby5/public_html/coozymcmillan.com/view.php on line 86

So I looked it up and somewhere it told me to add some extra code to handle errors better:

Code: [Select]
if ($mysql_query === FALSE) {
    die (mysql_error ()); // TODO: better error handling
}
But when I do that, I get a different error:

Table 'database1.someTable2' doesn't exist

It doesn't seem to recognize that I switched databases, and it says 'database1.someTable2' doesn't exist (because it doesn't), when really it should be checking for 'database2.someTable2' (which exists).

So to reiterate, I can run the query loop fine after selecting database1, but after that if I select database2, it either gives me the first error, or If I add the 'die' code it gives me the second error.


Thanks much!

PS: I can get it working if I put everything into one database, but I have multiple websites (which sometimes need to call eachothers' databases) and it would be a huge hassle to cram them all into one database unless I have to.

Hello everyone,

I'm having this problem which is really annoying, tried to solve it but couldn't, I write that code in PHPMyAdmin and it works great, but it doesn't work in the website it self

ok long story short, there are three tables, hotels, cities, countries
hotels include in addition to hotel info, 2 columns (city_id) and (country_id)
Cities include id and name and also countries include id and name

what I was trying to do, that when a person inputs a city or country name in the search form, it should get the hotels that exists in this city or country, but unfortunately it shows all the hotels in all cities and countries, although the pagination code for number of pages works just fine, it count the number of hotels in that city or country and show the number of pages correctly

so here is the code for both

for hotel search

Code: [Select]
class hotelManager
{


public function getHotel($where)
{
$where = isset($_POST['where']) ? $_POST['where'] : "";
$dbObj = new DB();
$sql = "select * from hotels where city_id = (select id from cities where name = '$where' ) or country_id = (select id from countries where name = '$where' )";
$result = MYSQL_QUERY($sql);
$arr = array();
echo "<table>";
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td valign=\"top\" width=\"120px\">";
$rowid = $row['id'];
$imageqry=mysql_query("SELECT * FROM `hotelphotos` where hotel_id='$rowid' LIMIT 1");
$image=mysql_fetch_array($imageqry);
$imagename=$image['attachmentName'];
echo "<img src=\"foxmaincms/webroot/files/small/$imagename\"/>";
echo "</td>";
echo "<td valign=\"top\">";

echo "<table>
<tr>
<td valign=\"top\">
<a href=\"hotels.php?id=".$row['id']."\" class=\"titleslink\">".$row['name']."</a>
</td>
</tr>
<tr>
<td class=\"text\" valign=\"top\">
".$row['location']."
</td>
</tr>
</table>";

echo "</td>";
echo "</tr>";
}
echo "</table>";

for hotel pagination

Code: [Select]
<?php
  include("includes/hotelsManager.php");
  $hotelObj = new hotelManager();
  $where = isset($_POST['where']) ? $_POST['where'] : "";
  if(isset($_POST['where']))
  {
    
$hotelObj -> getHotel($where);


$per_page = 9;

//Calculating no of pages
$sql = "select * from hotels where city_id = (select id from cities where name = '$where' ) or country_id = (select id from countries where name = '$where' )";
$result = MYSQL_QUERY($sql) or die("<br />No Hotels found in this city, please check the city name and try again");
$count = mysql_num_rows($result);
$pages = ceil($count/$per_page)
?>


<div id="loading" ></div>
<div id="maincontent" ></div>
<ul id="pagination">
thank you in advance

Hello,
The following is my situation where I seem to get a 500 error code from the linux server:

i have an 'index' file like this:
Code: [Select]
<?php
require("includes/config.php");

$a = $_REQUEST['a'];

switch ($a)
{
   case "home":
      include("frontpage/main.php");
   case "user-process":
      include("user-process.php");
}
?>
config.php is something like this:
Code: [Select]
<?php

require(includes/classes/session.class.php);
require(includes/classes/user.class.php);
require(includes/classes/db.class.php);
...
?>
Now if we fall into the case "home" it works fine. Instead, if we fall into user-process it writes to the logs file Fatal Error: Class User does not exist bla bla bla. Why doesn't it exist ? every class is included in the config.php file then index.php includes first config.php ( which has all the classes) and then includes the requested page.

I also have a .htaccess file which is as follows:
Code: [Select]
RewriteEngine On
RewriteRule ^([^/\.]+)?/?([^/\.]+)?/?([^/\.]+)?/?([^/\.]+)?/?([^/\.]+)?/?([^/\.]+)?/?([^/\.]+)?$ index.php?a=$1&b=$2&c=$3&d=$4&e=$5&f=$6&g=$7 [NC,L]
which is used to access in a SEO friendly way the pages that users request.

Hi, this query runs fine when I run it from PHPMyAdmin:
 

UPDATE `tran_term_taxonomy` SET `description` = (SELECT keyword from `good_keywords` ORDER BY RAND() LIMIT 1,1) WHERE `tran_term_taxonomy`.`taxonomy` = 'post_tag' AND `tran_term_taxonomy`.`description` = "" LIMIT 1

However, when I run the same query in a PHP file on my server, the page doesn't load at all. The message I get is: www.somesite.com is currently unable to handle this request. HTTP ERROR 500. This is my PHP code:

<?php 
include("/database/connection/path/db_connect.php"); 

$result4 = mysqli_query($GLOBALS["___mysqli_ston"], "UPDATE `tran_term_taxonomy` SET `description` = (SELECT keyword from `good_keywords` ORDER BY RAND() LIMIT 1,1) WHERE `tran_term_taxonomy`.`taxonomy` = 'post_tag' AND `tran_term_taxonomy`.`description` = "" LIMIT 1");
echo $result4;

?>

So how do I make this query work please? Thanks for your guidance.

I'm trying to update every record where one field in a row is less than the other. The code gets each row i'm looking for and sets up the query right, I hope I combined the entire query into one string each query seperated by a ; so it's like
UPDATE `table` SET field2= '1' WHERE field1= '1';UPDATE `table` SET field2= '1' WHERE field1= '2';UPDATE `table` SET field2= '1' WHERE field1= '3';UPDATE `table` SET field2= '1' WHERE field1= '4';UPDATE `table` SET field2= '1' WHERE field1= '5';
this executes properly if i run the query in phpMyAdmin, however when I run the query in PHP, it does nothing... Any advice?

Ok, so I have grabbed a free template and attempted to put a dynamic table into one of the div's.  I've got it to work on on my index.php, but I copied and pasted the entire code into member2.php and only changed the query and altered the table just a little bit  For some reason though my table doesn't show up on the member2.php even though 90% of the code is the same.

Here are the pages and codes...

http://www.royalfamilyhosting.com/test/index.php

<div id="layoutBodyContent">
         <h1>Aces Guild Donations Page </h1>
            <h2>Are you on top of your game? WE are!</h2>

           <?PHP


require_once('./mylib.php');
$rank = 1;
$olddate = strtotime(date("Y-m-d"));
$newdate;
$datecounter = 1;

//connects to db
dbconnect();


$query="SELECT name, date, SUM(amount) as total_money, SUM(bricks) as total_bricks FROM Aces_Donations GROUP BY Name ORDER BY total_money DESC, total_bricks DESC";
$result=mysql_query($query);


//Opens the table
echo "<table border = '3' width = 40% bgcolor=#A85045><caption><center>30 Day Rankings".'</center></caption>';

//Loop to run until eof

while($row = mysql_fetch_array($result)){

//turns date into a comparable string
$newdate = strtotime($row['date']);

/*checks to see if date of new record matches date of previous record. If dates dont match the table is closed and a new table is opened for the new date. Rank is reset to reflect rankings for each specific date*/
if($newdate !== $olddate){
$olddate = $newdate;
$datetracker++;
if($datetracker == 30){

echo "<center><tr><td alignment = 'center'>".$rank."</td> <td alignment = 'center'>".$row['name']. "</td><td  alignment = 'center'>". $row['total_money']."</td><td alignment= 'center'>".$row['total_bricks']."</tr></table></center>";
break;
}
}
echo "<center><tr><td alignment = 'center'>".$rank."</td> <td alignment = 'center'>".$row['name']. "</td><td  alignment = 'center'>". $row['total_money']."</td><td alignment= 'center'>".$row['total_bricks'].'</td></tr>';

echo '<br />';
$rank++;

}
echo '</table>';

?>


<br /><br /></p>
        </div>


http://www.royalfamilyhosting.com/test/member2.php?member=Zneve08

<div id="layoutBodyContent">
         <h1>Aces Guild Donations Page </h1>
            <h2>Are you on top of your game? WE are!</h2>

           <?PHP


require_once('./mylib.php');
$membername = $_GET['member'];
$rank = 1;
$olddate = strtotime(date("Y-m-d"));
$newdate;
$datecounter = 1;

//connects to db
dbconnect();


$query = sprintf("SELECT * FROM `Aces_Donations` WHERE `name` = '%s'",
$membername);

//sets the results to a variable
$result = mysql_query($query) or die(mysql_error());

//opens table, sets width, color, border and headers

echo '<table bgcolor=#A85045 border = "3" width = 40%>';
echo "<tr><th alignment = 'center'>Member</th>
<th alignment = 'center'>Amount</th><th alignment = 'center'>Date</th></tr>";

while($row = mysql_fetch_array($result)){
echo "<center><tr><td alignment = 'center'>".$row['name']. "</td><td alignment = 'center'>". $row['amount']."</td><td alignment  = 'center'>".$row['date']."</td></tr></center>";
var_dump ($row['name']);
var_dump ($row['amount']);
echo "<br />";
}
echo '</center></table>';

?>


<br /><br /></p>
        </div>

I'm dying here and would love even shot in the dark at this point.  The php code on member2.php works just fine when executed on its own page, so I don't really understand how this is happening.  I put the var_dump in there just to make sure the data was being retrieved from the database, but the table should be positioned where the var_dump displays on the page

When a file is uploaded, I wish to determine whether an existing identical file (regardless of what it is named or what extension it has) already exists and if so don't save the newly uploaded file but just point it to the existing one.  My primary reason for doing so is not really to save hard drive space but to be able to manage duplicate documents.

One option is to store a hash of the documents in the DB and when a new document is uploaded, query the DB to see if an identical hash exists.  How certain can one be that two hashes will never be duplicated?

Another option is to compare the byte stream.  For this, I would first query the DB to see if a file with same size and media type exists, and then compare the document to all existing files which have that same criteria.

Or many some other approach?

Recommendations?

Thanks

 

<?php

error_reporting(E_ALL);
ini_set('display_startup_errors', 1);
ini_set('display_errors', 1);

function compareFilesTest(string $file_a, string $file_b)
{
    $time = microtime(true);
    display($time, $file_a, $file_b, 'compareFilesTest', compareFiles($file_a, $file_b));
}
function compareFilesTest2(string $file_a, string $file_b)
{
    $time = microtime(true);
    display($time, $file_a, $file_b, 'compareFilesTest2', identical($file_a, $file_b));
}

function compareFilesHashTest(string $file_a, string $file_b, string $algo = 'md5')
{
    $time = microtime(true);
    display($time, $file_a, $file_b, 'compareFilesHashTest', hash_file($algo, $file_a)===hash_file($algo, $file_b), $algo);
}

function display(float $time, string $file_a, string $file_b, string $test, bool $status, string $algorithm=null)
{
    printf("\n%s\nFile1: %s\nFile2: %s\nStatus: %s\nTime (uS): %d\n", $test.($algorithm?" ($algorithm)":''), $file_a, $file_b, $status?'EQUAL':'NOT EQUAL', 1000000*(microtime(true) - $time));
}

function compareFiles(string $file_a, string $file_b):bool
{
    if (filesize($file_a) == filesize($file_b))
    {
        $fp_a = fopen($file_a, 'rb');
        $fp_b = fopen($file_b, 'rb');

        while (!feof($fp_a) && ($b = fread($fp_a, 4096)) !== false) {
            $b_b = fread($fp_b, 4096);
            if ($b !== $b_b)
            {
                fclose($fp_a);
                fclose($fp_b);
                return false;
            }
        }

        fclose($fp_a);
        fclose($fp_b);

        return true;
    }

    return false;
}

function identical($fileOne, $fileTwo)
{
    if (filetype($fileOne) !== filetype($fileTwo)) return false;
    if (filesize($fileOne) !== filesize($fileTwo)) return false;

    if (! $fp1 = fopen($fileOne, 'rb')) return false;

    if (! $fp2 = fopen($fileTwo, 'rb'))
    {
        fclose($fp1);
        return false;
    }

    $same = true;

    while (! feof($fp1) and ! feof($fp2))
        if (fread($fp1, 4096) !== fread($fp2, 4096))
        {
            $same = false;
            break;
        }

        if (feof($fp1) !== feof($fp2)) $same = false;

    fclose($fp1);
    fclose($fp2);

    return $same;
}

$path = __DIR__.'/test_documents/';

//print_r(hash_algos());

compareFilesHashTest($path.'602a9c07af00c_IMG_1225.jpg', $path.'602a9c07af00c_IMG_1225.jpg');
compareFilesHashTest($path.'602a9c07af00c_IMG_1225.jpg', $path.'602a9c1c96440_MasterFormat-2016.pdf');
compareFilesHashTest($path.'602a9c07af00c_IMG_1225.jpg', $path.'x602a9c07af00c_IMG_1225.jpg');
compareFilesHashTest($path.'602a9c07af00c_IMG_1225.jpg', $path.'602a9c07af00c_IMG_1225.jpgx');
compareFilesHashTest($path.'file1.txt', $path.'file2.md');
compareFilesHashTest($path.'file1.txt', $path.'file3.txt');

compareFilesHashTest($path.'602a9c07af00c_IMG_1225.jpg', $path.'602a9c07af00c_IMG_1225.jpg', 'sha256');
compareFilesHashTest($path.'602a9c07af00c_IMG_1225.jpg', $path.'602a9c1c96440_MasterFormat-2016.pdf', 'sha256');
compareFilesHashTest($path.'602a9c07af00c_IMG_1225.jpg', $path.'x602a9c07af00c_IMG_1225.jpg', 'sha256');
compareFilesHashTest($path.'602a9c07af00c_IMG_1225.jpg', $path.'602a9c07af00c_IMG_1225.jpgx', 'sha256');
compareFilesHashTest($path.'file1.txt', $path.'file2.md', 'sha256');
compareFilesHashTest($path.'file1.txt', $path.'file3.txt', 'sha256');

compareFilesTest($path.'602a9c07af00c_IMG_1225.jpg', $path.'602a9c07af00c_IMG_1225.jpg');
compareFilesTest($path.'602a9c07af00c_IMG_1225.jpg', $path.'602a9c1c96440_MasterFormat-2016.pdf');
compareFilesTest($path.'602a9c07af00c_IMG_1225.jpg', $path.'x602a9c07af00c_IMG_1225.jpg');
compareFilesTest($path.'602a9c07af00c_IMG_1225.jpg', $path.'602a9c07af00c_IMG_1225.jpgx');
compareFilesTest($path.'file1.txt', $path.'file2.md');
compareFilesTest($path.'file1.txt', $path.'file3.txt');

compareFilesTest2($path.'602a9c07af00c_IMG_1225.jpg', $path.'602a9c07af00c_IMG_1225.jpg');
compareFilesTest2($path.'602a9c07af00c_IMG_1225.jpg', $path.'602a9c1c96440_MasterFormat-2016.pdf');
compareFilesTest2($path.'602a9c07af00c_IMG_1225.jpg', $path.'x602a9c07af00c_IMG_1225.jpg');
compareFilesTest2($path.'602a9c07af00c_IMG_1225.jpg', $path.'602a9c07af00c_IMG_1225.jpgx');
compareFilesTest2($path.'file1.txt', $path.'file2.md');
compareFilesTest2($path.'file1.txt', $path.'file3.txt');

 

Hello, Experts! Need you advice.

Here is the code:

<?php

if ($var == "")  {
        echo "text";
   }
     if ($var == "*")  {
        echo "text"; }
   else if ($var != "")
   {
        
$query = "SELECT * FROM bd WHERE ....."; 
$data = mysql_query($query) or die(mysql_error());
       $anymatches=mysql_num_rows($data);
        if ($anymatches != 0) {
       echo "text";
        while($row = mysql_fetch_array($data))
        {
            echo "text";      
        }    
         } 
        if ($anymatches == 0) {      
         $query2 = "SELECT * FROM bd WHERE....."; 
      $data2 = mysql_query($query2) or die(mysql_error());
       $anymatches2=mysql_num_rows($data2);
       if ($anymatches2 != 0) {             
 echo "text"
       else
       {
              
          mysql_query("INSERT INTO notfound (notfound) VALUES ('$var')") or die(mysql_error());    
           } }  } ?>

The last line adds two identical lines to my table. Do I run it twice? Thanks in advance!

I'm surely doing something wrong here, but I just cannot see it.  Any assistance will be greatly appreciated.

In a login script I read the following two variables from an SQL database.  Both fields are defined as int.

$this->ScheduleA = $rs->fetchCol('ScheduleA');
$this->SchedConst = $rs->fetchCol('SchedConstant');



Later, I retrieve these variables and attempt to compare them.

$schA = $sess['ScheduleA'];
$schC = $sess['SchedConst'];

if ($schA == $schC) {
   require('Testing.php');
   }
else {
   require('NotAllowed.php');
   }


They never compare as equal, even though they contain the same value.  What, pray tell, am I missing?

So on a cloud computing platform such as AWS, how would one keep the /html folder in Apache identical?   I can FTP into one "instance" and modify code easily enough, but how would I push reversions to multiple servers at once?   It seems like such a simple question, but the answer eludes me.
Edited by arbitrageur, 20 November 2014 - 04:43 PM.

Well, the title says it all, I do have a class named Database and one Users with multiple methods (code below). When i do try to use one user method (find_all) it returns 2 identical results from the database (and there is only one record in the DB). I tried to spot some mistake in the code but i couldn't find it, if you find something please tell...

Database Class:
Code: [Select]
<?php

/**
 * Class Name: MySQLDatabase
 * 
 * Most of the methods in this class are 
 * database-neutral methods for code reusability.
 * 
 * Author: hisk
 */

require_once("config.php");

class MySQLDatabase {
private $connection;
private $last_query;
private $magic_quotes_active;
private $real_escape_string;

function __construct() {
$this->open_connection();
$this->magic_quotes_active = get_magic_quotes_gpc();
$this->real_escape_string = function_exists("mysql_real_escape_string"); 
}

public function open_connection() {
$this->connection = mysql_connect(DB_SERVER, DB_USER, DB_PASS);
if(!$this->connection) {
die("Database connection failed: " . mysql_error());
} else {
$db_select = mysql_select_db(DB_NAME, $this->connection);
if (!$db_select) {
die("Database selection failed: " . mysql_error());
}
}
}

public function close_connection() {
if(isset($this->connection)) {
mysql_close($this->connection);
unset($this->connection);
}
}

public function query($sql) {
$this->last_query = $sql;
$result = mysql_query($sql, $this->connection);
$this->confirm_query($result);
return $result;
}

private function confirm_query($result) { // usable only in query() function (private)
if(!$result) {
echo "DB Query Failed: " . mysql_error();
// The last query that might got us the problem
echo "Last Query Was: " . $this->last_query;
}
}

// agnostic
public function num_rows($result) {
return mysql_num_rows($result);
}

public function affected_rows($result)
{
return mysql_affected_rows($result);
}

public function insert_id($result) {
return mysql_insert_id($result);
}

public function fetch_array($result) {
return mysql_fetch_array($result);
}


public function escape_value($value) {
if($this->real_escape_string) {
// undo any magic quote effect so mysql_real_esc_str can work
if($this->magic_quotes_active) {  $value = stripslashes($value);}
$value = mysql_real_escape_string($value);
} else {
if (!$this->magic_quotes_active) { $value = addslashes($value); }
}
return $value;
}
}

$database = new MySQLDatabase();

?>

User Class:
Code: [Select]
<?php
// smart to include the database class
require_once("database.php");

class User {
public static function find_by_id($id=0) {
global $database;
$result_set = self::find_by_sql("SELECT * FROM users WHERE id = {$id}");
$result = $database->fetch_array($result_set);
return $result;
}

public static function find_all() {
global $database;
$result_set = self::find_by_sql("SELECT * FROM users");
return $result_set;
}

public static function find_by_sql($sql="") {
global $database;
$result_set = $database->query($sql);
return $result_set;
}

}
?>

TEST FILE:
Code: [Select]
<?php
       require_once("../includes/database.php");
   require_once("../includes/user.php");
   
   $users = User::find_all();
   $result = $database->fetch_array($users);
   foreach($result as $user) {
    echo "<pre>" . $user . "</pre>";
   }

        ?>

I am building online dictionary with php. The following code allows the user to search a word and display the definition results from the database. The problem is the user has to input the identical words only. If the words are not exactly similar to the database words it returns error message. But in this case I need it to give a suggestion along with the error message based on the few beginning words of the submitted word. eg. if the user type a word "suggestion", and the word "suggestion" is not available in the database .... instead of just the error message to also search and include other stored data closer to the submitted word ... like "TRY the word SUGGEST".

can any one help me on this please.
Thank you in advance.

here is the code
Code: [Select]
<?php

$script = $_SERVER['PHP_SELF'];

if(isset($_POST['sbm']) && isset($_POST['word']) ) {
  submited();
} else {
  show_form();
}

function show_form() {
?>
<p><center> Type <span style='font-weight:bold;'>ENGLISH</span> word Only! <span style='font-weight:bold;'>SPELL IT CORRECTLY!!!.</span></center></P>
<p><center>Search</center></p>
 <center><form name=frm method=POST action="<?php echo $script ?>">
     <p><input type=text name="word"><br /></p>
    <p><input type=submit name="sbm" value="Submit">
  </form>    </center></p>
<?php
}

function submited() {
  require("dbconn.inc");
  $word=$_POST['word'];
  $sql="select * from words where eng like '".mysql_real_escape_string($word)."'";
  $result=mysql_query($sql,$link); // I assume $link is defined in dbconn.inc

  if(@mysql_num_rows($result)!=0) {
    $rows=mysql_fetch_array($result);
    $am=$rows["am"];
    echo("<center>The Word <h1><b>$word</b></h1> in Am is : <h1><b>$am </b></h1><br></center>");
  } else {
    echo("<center><span style='font-weight:bold;color:#FF0000;'>Could not find it! Check the spelling and try again !!</span></center>");
  }

  // The connection will close automatically since
  // this is near the end of the script.
  mysql_close($link);

  show_form();
}
?>

if ($count==1){
				
						
				header("Location:store.php");				
				
								}

very simple I have issolated it and it doesn't redirect maybe u can see where my mistake is

I know this involves MySQL, but it's mostly PHP, so I figured it should go here, forgive me if I posted in the wrong section, though.

Anyway! Let's get down to it. I'd like to combine these two scripts (below). I want the questionnaire script to be a signup requirement in the signup script, and I want it to log the questionnaire into my MySQL database as usual, then prompt the user with a successful sign up.

I'm still really new to PHP and I'm just testing to see if this'll work. How would I go about doing this? Thanks a LOT guys.

Questionnai

<?php
  // Start the session
  require_once('startsession.php');

  // Insert the page header
  $page_title = 'Questionnaire';
  require_once('header.php');

  require_once('appvars.php');
  require_once('connectvars.php');

  // Make sure the user is logged in before going any further.
  if (!isset($_SESSION['user_id'])) 
  {
    echo '<p class="login">Please <a href="login.php">log in</a> to access this page.</p>';
    exit();
  }

  // Show the navigation menu
  require_once('navmenu.php');

  // Connect to the database
  $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

  // If this user has never answered the questionnaire, insert empty responses into the database
  $query = "SELECT * FROM mismatch_response WHERE user_id = '" . $_SESSION['user_id'] . "'";
  $data = mysqli_query($dbc, $query);
  if (mysqli_num_rows($data) == 0) 
  {
    // First grab the list of topic IDs from the topic table
    $query = "SELECT topic_id FROM mismatch_topic ORDER BY category_id, topic_id";
    $data = mysqli_query($dbc, $query);
    $topicIDs = array();
    while ($row = mysqli_fetch_array($data)) 
{
      array_push($topicIDs, $row['topic_id']);
    }

    // Insert empty response rows into the response table, one per topic
    foreach ($topicIDs as $topic_id) 
{
      $query = "INSERT INTO mismatch_response (user_id, topic_id) VALUES ('" . $_SESSION['user_id']. "', '$topic_id')";
      mysqli_query($dbc, $query);
    }
  }

  // If the questionnaire form has been submitted, write the form responses to the database
  if (isset($_POST['submit'])) 
  {
    // Write the questionnaire response rows to the response table
    foreach ($_POST as $response_id => $response) 
{
      $query = "UPDATE mismatch_response SET response = '$response' WHERE response_id = '$response_id'";
      mysqli_query($dbc, $query);
    }
    echo '<p>Your responses have been saved.</p>';
  }

  // Grab the response data from the database to generate the form
  $query = "SELECT mr.response_id, mr.topic_id, mr.response, " .
    "mt.name AS topic_name, mc.name AS category_name " .
"FROM mismatch_response AS mr " .
"INNER JOIN mismatch_topic AS mt USING (topic_id) " .
"INNER JOIN mismatch_category AS mc USING (category_id) " .
"WHERE mr.user_id = '". $_SESSION['user_id'] . "'";
$data = mysqli_query ($dbc, $query);
$responses = array();
while ($row = mysqli_fetch_array($data)) 
{
  array_push($responses, $row);
}
  
  mysqli_close($dbc);

  // Generate the questionnaire form by looping through the response array
  echo '<form method="post" action="' . $_SERVER['PHP_SELF'] . '">';
  echo '<p>How do you feel about each topic?</p>';
  $category = $responses[0]['category_name'];
  echo '<fieldset><legend>' . $responses[0]['category_name'] . '</legend>';
  foreach ($responses as $response) 
  {
    // Only start a new fieldset if the category has changed
    if ($category != $response['category_name']) 
{
      $category = $response['category_name'];
      echo '</fieldset><fieldset><legend>' . $response['category_name'] . '</legend>';
    }

    // Display the topic form field
    echo '<label ' . ($response['response'] == NULL ? 'class="error"' : '') . ' for="' . $response['response_id'] . '">' . $response['topic_name'] . ':</label>';
    echo '<input type="radio" id="' . $response['response_id'] . '" name="' . $response['response_id'] . '" value="1" ' . ($response['response'] == 1 ? 'checked="checked"' : '') . ' />Love ';
    echo '<input type="radio" id="' . $response['response_id'] . '" name="' . $response['response_id'] . '" value="2" ' . ($response['response'] == 2 ? 'checked="checked"' : '') . ' />Hate<br />';
  }
  echo '</fieldset>';
  echo '<input type="submit" value="Save Questionnaire" name="submit" />';
  echo '</form>';

  // Insert the page footer
  require_once('footer.php');
?>



Signup:
<?php
  // Insert the page header
  $page_title = 'Sign Up';
  require_once('header.php');

  require_once('appvars.php');
  require_once('connectvars.php');

  // Connect to the database
  $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

  if (isset($_POST['submit'])) {
    // Grab the profile data from the POST
    $username = mysqli_real_escape_string($dbc, trim($_POST['username']));
    $password1 = mysqli_real_escape_string($dbc, trim($_POST['password1']));
    $password2 = mysqli_real_escape_string($dbc, trim($_POST['password2']));

    if (!empty($username) && !empty($password1) && !empty($password2) && ($password1 == $password2)) {
      // Make sure someone isn't already registered using this username
      $query = "SELECT * FROM mismatch_user WHERE username = '$username'";
      $data = mysqli_query($dbc, $query);
      if (mysqli_num_rows($data) == 0) {
        // The username is unique, so insert the data into the database
        $query = "INSERT INTO mismatch_user (username, password, join_date) VALUES ('$username', SHA('$password1'), NOW())";
        mysqli_query($dbc, $query);

        // Confirm success with the user
        echo '<p>Your new account has been successfully created. You\'re now ready to <a href="login.php">log in</a>.</p>';

        mysqli_close($dbc);
        exit();
      }
      else {
        // An account already exists for this username, so display an error message
        echo '<p class="error">An account already exists for this username. Please use a different address.</p>';
        $username = "";
      }
    }
    else {
      echo '<p class="error">You must enter all of the sign-up data, including the desired password twice.</p>';
    }
  }

  mysqli_close($dbc);
?>

  <p>Please enter your username and desired password to sign up to Mismatch.</p>
  <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
    <fieldset>
      <legend>Registration Info</legend>
      <label for="username">Username:</label>
      <input type="text" id="username" name="username" value="<?php if (!empty($username)) echo $username; ?>" /><br />
      <label for="password1">Password:</label>
      <input type="password" id="password1" name="password1" /><br />
      <label for="password2">Password (retype):</label>
      <input type="password" id="password2" name="password2" /><br />
    </fieldset>
    <input type="submit" value="Sign Up" name="submit" />
  </form>

<?php
  // Insert the page footer
  require_once('footer.php');
?>


And here are the pastebins in case you prefer those:

http://pastebin.com/pTXGSMT9 - Questionnaire

http://pastebin.com/28jZhYyY - Signup

Thanks!