php - MySQL time-exceeded error -

-

i working on ajax testing platform. experiencing stupid errors in php programming. here code. error: maximum execution time of 30 seconds exceeded.

<?php $resultfromjson;  $databaseconnection = mysql_connect("localhost", "root", "password"); if($databaseconnection)mysql_select_db("fastdata", $databaseconnection); else echo mysql_error($databaseconnection);  if(isset($_get['command'])){     switch($_get['command']){         case "loadpeople":         {             $sqlcommandstring = "select *  `people` limit 0 , 30";              $people = array();             $index = 0;             while($row = mysql_fetch_assoc(mysql_query($sqlcommandstring))){                 $people[$index] = $row;                 $index++;                }              echo json_encode( $people );         }         break;       } }  if(!isset($_get['command']))echo json_encode( "error#001" );  ?>

what can solve error? causes error?

p.s. testing php script directly in browser main.php?command=loadpeople url.

execute query, then loop through results; don't try re-execute query in every iteration of while

$resultset = mysql_query($sqlcommandstring); while ($row = mysql_fetch_assoc($resultset)) {

as you're learning basics, i'd suggest learn use mysqli or pdo rather deprecated mysql library... being able use prepared statements , bind variables doesn't affect query, knowing how use them become more important later


Comments

Post a Comment

Popular posts from this blog

javascript - DIV "hiding" when changing dropdown value -

-
this related previous question asked: hide / show multiple divs i have code in place previous question , seems work ok apart when change value in dropdown "after" ticket selection made. i have number of javascrpts in place wondering if there clash somewhere? first bit of code in head of document. <head> <script type="text/javascript"> $(function() { $('.cat_dropdown').change(function() { $('#paymethod').toggle($(this).val() >= 2); }); }); </script> <script type="text/javascript"> $(document).ready(function () { $(".paymentmethod").click(function () { $(".paymentinfo").hide(); switch ($(this).val()) { case "credit card authorisation": $("#pay0").show("slow"); break; ...
Read more

html - Accumulated Depreciation of Assets on php -

-
i have problem table print out asset accumulated depreciation on php, stright line method. $query = mysqli_query($connect, "select current_value, salvage_value, useful_life, placed_service assets"); if(!$query){ echo 'could not run query b: ' . mysqli_error($connect); exit; } while($asset = mysqli_fetch_row($query)){ echo "assets :"; print_r($asset); $month = 12; $year = date('y',strtotime($asset[3])); $first_year = $month - ((int)date('m',strtotime($asset[3]))-1); $last_year = $month - $first_year; $first = round((($asset[0] - $asset[1])/$asset[2])*(($first_year)/12),0); $last = round((($asset[0] - $asset[1])/$asset[2])*(($last_year)/12),0); $others = ($asset[0] - $asset[1])/$asset[2]; echo "<table border=1>"; echo "<tr><th>year</th><th>book value year start</th><th>depreciation expense</th><th...
Read more

node.js - Node - Passport Auth - Authed Post Route hangs on form submission -

-
this weird one. im passport's 'local strategy' express app , i'm running odd issue. essentially, have 3 routes. each have auth check in place. app.get('/admin', authenticatedornot, adminroute.index); app.get('/admin/new', authenticatedornot, adminroute.newpost); app.post('/admin/new', authenticatedornot, adminroute.create); the authenticatedornot method : var authenticatedornot = function(req, res, next){ if(req.isauthenticated()){ next(); }else{ res.redirect("/login"); } } works perfect logging in admin area, , checking if user logged in, when submit form '/admin/new' post route, browser hangs. nothing happens in console, console.log in place : exports.create = function(req, res){ console.log(req); // database logic here res.redirect('/admin'); } i cant seem work. hangs, , fails. browser console says 'pending' in network request. ive tried remov...
Read more