StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POLocal Apache server crashes when using mysql_fetch_array() and foreach() to display results
text
Body
copied!<p>So, basically what I'm trying to do is to display search hits on a page. I have set up a form which posts to the page below, this data is then searched for in my MySQL database and the results should be displayed in the following format:</p> <p><hr/> <br/> Name <br/> Profile Image Path <br/> Age <br/><br/> <hr/> <br/></p> <p>I searched on the internet extensively and found out that you have to use a while loop, as I was just using a foreach loop before.</p> <p>But my apache server crashes whenever I search for something. I think it could be because of the while loop as it didn't crash before but it would only display the <strong>same</strong> set of results (Name, Image and Age) a certain amount of times, depending on the amount of rows found in the database.</p> <p>Here's the search page code:</p> <pre><code>require_once "lib/mysql.php"; </code></pre> <p>if (isset($_POST[search]) && !empty($_POST[search])){</p> <pre><code>$search = $_POST[search]; // The mysql class used for functions. $mysql = new mysqlHandle; // Opens access to the mysql server. $mysql->accessOpen('root', '', 'Portfolio', 'localhost'); // Sets $rows to number of entries (rows) with the 'Name' value of $search. $rows = $mysql->tableCheckNum('*', stats, Name, $search, Portfolio); echo "<div id='content'> <div id='content_main'> <h2>Search Results for '$search'</h2> <br/><hr/><br/>"; // Makes sure that there's at least 1 search hit. if ($rows>0){ // Sets the current hit number. (the first one is 1, the second is 2 et.c) $num = 1; $user = array(); // My mysql function for checking the order of entries, see the attached myqsl code. while ($result = $mysql->tableCheckOrder('*', stats, Name, $search, ID, DESC, Portfolio)){ // The $user array should hold the user's (searched for) details. $user[] = $result; foreach ($user as $result){ // Makes sure that we haven't exceeded the number of rows. if ($num<=$rows){ // Adds one to the number of displayed rows, as we have dsplayed another. $num++; // Prints the user's (searched for) details. print_r ($user[Name]."<br/>"); print_r ($user[Image]."<br/>"); print_r ($user[Age]."<br/>"."<br/>"."<hr/>"."<br/>"); } } } }else{ echo "No users found"; } echo '</div> </div>'; </code></pre> <p>}</p> <p>Here's the applicable MySQL code:</p> <pre><code>// Gets order of entries (rows) The indentations under "function tableCheckOrder" isn't showing up btw. function tableCheckOrder($span, $table, $column, $value, $order, $mode, $base){ mysql_select_db($base); $this->query11="SELECT $span FROM $table WHERE $column = '$value' ORDER BY $order $mode"; $this->result11=mysql_query($this->query11) or die("<br/>"."Invalid $table CHECK ORDER query: " .mysql_error()); return mysql_fetch_array($this->result11, $result_type = MYSQL_BOTH); } // This function checks amount of rows in table. function tableCheckNum($span, $table, $column, $value, $base){ mysql_select_db($base); $this->query="SELECT $span FROM $table WHERE $column = '$value'"; $this->result=mysql_query($this->query) or die("Invalid $table CHECK NUM query: " .mysql_error()); return mysql_num_rows($this->result); } </code></pre> <p>Here's a pic of my 'stats' table structure:</p> <p><img src="https://i.stack.imgur.com/IKm3C.png" alt="My 'stats' table structure"></p> <p>I really want to be able to display the search results without it crashing</p> <p>If I can give you any more information, please ask!</p> <p>Thanks in advance!</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

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