php - Blank Page after pressing Submit button with all fields filled up -

-

as shown in title, have page users create projects , page add database. when press submit form fields empty, page post isn't blank. when submit fields filled up, shows blank page without errors , have looked through both pages of codes can't seem find wrong. perhaps here me out? thanks.

//codes on page data submitted.

if ($_post['projecttitle'] != "" && $_post['projectstatus'] != "" && $_post['projectdesc'] != "" && $_post['projectdeliv'] != "" && $_post['year'] != "" && $_post['month'] != "" && $_post['day'] != "" && $_post['projectss'] != "") {          $host = "localhost";         $user = "root";         $pass = "";         $db = "fyp1";          $pt = $_post['projecttitle'];         $ps = $_post['projectstatus'];         $pdes = $_post['projectdesc'];         $pdel = $_post['projectdeliv'];         $date = $_post['year'] . "-" . $_post['month'] . "-" . $_post['day'];         $pss = $_post['projectss'];         date_default_timezone_set('utc+8');         $cdate = date('y-m-d');         $uid = $_session['id'];          $link = mysqli_connect($host, $user, $pass, $db) or die(mysqli_error());         $query = "select * project project_title = $pt , project_description = $pdes , project_deliverables = $pdel , project_skillset = $pss";         $dub = mysqli_query($link, $query) or die(mysqli_connect_error($link));          if (mysqli_num_rows($dub) == 0) {              $insertq = "insert project(project_title,project_description,project_deliverables,project_start,project_end,project_skillset,project_status)                 values ('$pt','$pdes','$pdeliv','$cdate','$date','$pss',$ps)";             mysqli_query($link, $insertq) or die(mysqli_connect_error($link));              $getpid = "select * project project_title = $pt , project_description = $pdes , project_deliverables = $pdel , project_start = $cdate , projecct_end = $date , project_skillset = $pss";             $pid = mysqli_query($link, $getpid) or die(mysqli_connect_error($link));             if (mysqli_num_rows($pid) == 1) {                 while ($row = mysqli_fetch_array($pid)) {                     $proid = $row['project_id'];                     $insertf = "insert user_has_project(user_id,project_id) values ('" . $uid . "','" . $proid . "')";                     mysqli_query($link,$insertf) or die(mysqli_connect_error($link));                     $message = "<p>project added!</p>";                     $message .= "<a href='index.php'>back</a>";                     $a = true;                 }             } else {                 $message = "<p>project failed added!</p>";                 $message .= "<a href='createproject.php'>back</a>";                 $a = false;             }         } else {             $message = "<p>duplicate project found!</p>";             $message .= "<a href='createproject.php'>back</a>";             $a = false;         }     } else {         $message = "<p>please fill fields when creating project!</p>";         $message .= "<a href='createproject.php'>back</a>";         $a = false;     }

// codes on page form

    <div id="content">         <?php if ($a == false) {         ?>                 <h2 id="registerfont">create project</h2>                 <form name="createproject" method="post" action="docreateproject.php" onsubmit="return validateform(this);">                     <fieldset>                         <table>                             <tr>                                 <th colspan="4"><h2>new project</h2></th>                             </tr>                             <tr>                                 <th colspan="4"><hr /></th>                             </tr>                             <tr>                                 <td><label for="projecttitle">project title:</label></td><td><input name="projecttitle" type="text" /></td>                                 <td><label for="projectstatus">project status:</label></td>                                 <td><select name="projectstatus">                                 <?php while ($row = mysqli_fetch_array($result1)) {                                 ?>                                     <option value="<?php echo $row['status_id']; ?>" ><?php echo $row['status_type']; ?></option>                                 <?php } ?>                             </select></td>                     </tr>                     <tr>                         <td><label for="projectdesc">project description:</label></td><th colspan="3"><textarea name="projectdesc" rows="5" cols="40" ></textarea></th>                     </tr>                     <tr>                         <td><label for="projectdeliv">project deliverables:</label></td><th colspan="3"><textarea name="projectdeliv" rows="5" cols="40" ></textarea></th>                     </tr>                     <tr>                         <td>start date:</td><td><?php echo $date; ?></td>                     </tr>                     <tr>                         <td>end date : </td>                         <th colspan="3" align="left">                             <select name="year">                                 <option>---year---</option>                                 <?php ($i = $cyear; $i < ($cyear + 100); $i++) {                                 ?>                                     <option value="<?php echo $i; ?>"><?php echo $i; ?></option>                                 <?php } ?>                             </select>                             <select name="month">                                 <option>---month---</option>                                 <?php while ($rows = mysqli_fetch_array($result)) {                                 ?>                                     <option value="<?php echo $rows['month_id']; ?>"><?php echo $rows['month']; ?></option>                                 <?php } ?>                             </select>                             <select name="day">                                 <option>---day---</option>                                 <?php ($i = 1; $i < 32; $i++) {                                 ?>                                     <option value="<?php echo $i ?>"><?php echo $i ?></option>                                 <?php } ?>                             </select>                         </th>                     </tr>                     <tr>                         <td><label for="projectss">project skill set:</label></td><td><input name="projectss" type="text"/></td><th colspan="2"><small>(please separate comma)</small></th>                     </tr>                 </table>             </fieldset>             <br />             <input name="submit" type="submit" value="create project" />         </form>         <?php                             } else {                                 echo $message;                             }         ?>                         </div>

i managed solve problem. when querying database, @ select statement, variables forgot add ''. e.g select * project project_title = '$variable';

anyways. helped out. appreciate it.


Comments

Post a Comment

Popular posts from this blog

linux - Using a Cron Job to check if my mod_wsgi / apache server is running and restart -

-
my group , running server based upon django , uses mod_wsgi run apache server. not working on project after over, attempting set cronjob similar functionality check if apache server has shut down(system restart or power failure), , if has, restart server me. i've found documentation on how check if apache server down , restart server if is, our server uses https , our start command pretty verbose. can use functionality provided in these examples: https://askubuntu.com/questions/277389/cron-job-to-restart-apache https://www.digitalocean.com/community/tutorials/how-to-use-a-simple-bash-script-to-restart-server-programs or need more complicated process make happen? the command use start server is python manage.py runmodwsgi --host 0.0.0.0 --port 8001 --https-port 8000 --ssl-certificate (certificate location) --server-name (domain name) i'm pretty new linux , using both mod-wsgi apache appreciated. you better off using --setup-only option mod_wsgi-expres...
Read more

actionscript 3 - TweenLite does not work with object -

-
i got following problem: i have object called tempscore game. this object blitted canvas renderer via copypixels method. object not display object. it's score-object (self made). score-object extends object called basicblitarrayobject. basicblitarrayobject extends eventdispatcher (therefore no display object). i tried apply several different tweenlite-plugins tempscore-object (i.e. transformaroundcenter, colormatrixfilter, etc.). nothing happens. absolutely nothing. sometimes error messages (when plugin requires display object , object not display object). far good. according greensock (maker of tweenlite) engine can tween numeric property of object. when plugin transformaroundcenter requires display object tweening have modify plugin working non-display object (tempscore). can't because it's way hard me. my game rests upon code: http://www.8bitrocket.com/book/ch11_blastermines.zip try apply tweenlite object called tempmine inside game class blastermines. ...
Read more

jQuery Ajax Render Fragments OR Whole Page -

-
i'm in throes of building application wraps mess of legacy code. page working on, need substitute fragment divs constructed on back-end -- or else need replace entire page altogether. idea there dynamically controlled flow needs satisfied before can forward legacy product. substituting fragments works fine, seen in below my_body_content swap. trouble comes when i'm trying render not fragment, whole page, in "body" swap. @ point page goes blank. i want similar errors returned server. want nice rest 404 error messages displayed on screen, legacy-product 404s show in legacy-product 404 page. yes, requirements project weird. that's not problem can fix. here's jquery invocation, names changed protect guilty: $.ajax({ url: "places/things", type: "post", data: json.stringify(somebadassobject), datatype: "text", accepts: "text/html", contenttype: "application/json; charset=...
Read more