php - Can't select user from mysql table. -


i asked question before code submitting users. after few days of guessing, got working. but, now. can't select user inside table login. code.

<?php     if($_post['submit_id'] == 1)     {      //echo $_post['fname'];      $playerf = $_post['fname'];     $playerl = $_post['lname'];     $name = $_post['firstname'];      $link = mysqli_connect("localhost","tester","abc123","biscuit") or die(" did not connect. " . mysqli_error($link));     $query = "select firstname users" or die("did not work." . mysqli_error($link));      if($name != $fname)       {       echo "does not match.";       }      else       {     header ("location: game.php");       }      }    ?>          <table align = "center">       <tr>     <td>        welcome <b> besco's biscuits </b>. please fill out following <br />       areas , begin adventure soon. :)        </td>     </tr>     </table>     <br /> <br /> <br /> <br /> <br />       <table align = "center">       <tr>     <td>          <form action="<?php echo htmlentities($_server['php_self']); ?>" method="post" > <br />         firstname: <input type="text" name="fname" id= "fname" required = "1"> <br />         lastname: <input type = "text" name = "lname" id= "lname" required = "1"> <br />          <input type = "submit" value = "register" id="submit_id" > &nbsp; &nbsp;           <input name="submit_id" type="hidden" id="submit_id" value="1">         <input type = "reset" name="reset" value="reset page" class = "account">        </form>     </td>       </tr>     </table>

when try submit user identify/match, doesn't , sends me straight game. can help? beta due in 3 days.!!!

you not executing query nor fetching results:

$query = mysqli_query($link, "select firstname users") or die("did not work." . mysqli_error($link)); $user = mysqli_fetch_assoc($link, $query); if($name != $user['firstname'])

additionally:

  • where did $fname come from? did make up?
  • you don't seem use post variables necessary run query , exact match user. above code return every user check first one. doubt want.
  • you have 2 post variables seem hold first name. correct you?

Comments

Post a Comment

Popular posts from this blog

apache - Remove .php and add trailing slash in url using htaccess not loading css -

i have add following code htaccess file removing .php extension , add trailing slash urls. worked fine reduced page loading speed , css code not loading @ all. pages ugly. please help rewriteengine on rewritebase / ## hide .php extension snippet # externally redirect /dir/foo.php /dir/foo rewritecond %{the_request} ^[a-z]{3,}\s([^.]+)\.php [nc] rewriterule ^ %1/ [r,l] # add trailing slash rewritecond %{request_filename} !-f rewritecond %{request_uri} !/$ rewriterule . %{request_uri}/ [l,r=301] # internally forward /dir/foo /dir/foo.php rewritecond %{request_filename} !-d rewritecond %{request_filename}.php -f rewriterule ^(.*?)/?$ $1.php [l] we can rewrite urls using .htaccess files. before writing in .htaccess files need verify kind of server using. can check server adding a <?php phpinfo(); ?> in php page. ensure mod_rewrite module enabled in apache server. can identified checking phpinfo included page. common methods used url rewriting follows ...
Read more

inno setup - TLabel or TNewStaticText - change .Font.Style on Focus like Cursor changes with .Cursor -

is possible change .font.style on focus tlabel or tnewstatictext happens cursor when use .cursor ? there no built-in support track mouse hovering in inno setup @ time. however, intercepting window procedure of controls can track yourself. following example need innocallback library: [setup] appname=my program appversion=1.5 defaultdirname={pf}\my program outputdir=userdocs:inno setup examples output [files] source: "innocallback.dll"; destdir: "{tmp}"; flags: dontcopy [code] #ifdef unicode #define aw "w" #else #define aw "a" #endif const gwl_wndproc = -4; wm_mousemove = $0200; type wparam = uint_ptr; lparam = longint; lresult = longint; twindowproc = function(hwnd: hwnd; umsg: uint; wparam: wparam; lparam: lparam): lresult; function setcapture(hwnd: hwnd): hwnd; external 'setcapture@user32.dll stdcall'; function releasecapture: bool; external 'releasecapture@user32.dll stdcall'; func...
Read more