how to display the mobile no in mobile no label searching by employee id in html using php and mysql -


i want display mobile number in mobileno label when enter employee id search code displays no result.

i want display data using while loop in html form

search.php

<?php                    $output = null;          $mysqli = mysqli_connect("localhost","root","","db") or die ("error in connection");          if(isset($_post['search']))           {          	$search = $mysqli->real_escape_string(isset($_post['search']));          	$resultset = $mysqli->query("select * emp emp_id = '$search'");          	if($resultset->num_rows > 0)               {          	   while($rows = mysqli_fetch_row($resultset))                  {          		   $mobileno = $rows['emp_mob_no'];          		   $output = "mobile no: $mobileno";          	    }          	 }               {          		$output = "no result";          	 }          }          ?>

display.php

<html>  <head>  </head>  <body>  <form action="search.php" method="post">       <ul>        <li>         <label for="employeeid">employee id</label>         <input type="text" name="employeeid" placeholder="employee id" />         <input type="submit" value="search" name="search"/>          </li>        <li>          <label for="mobileno">mobile no.</label>          <?php echo $output;?>        </li>  </form>  </body>  </html>

1st : missed else that's why $output variable alwasy overwrite no result .

2nd : $search = $mysqli->real_escape_string(isset($_post['search'])); line wrong isset return boolean value escaping boolean value .

3rd : try use prepared statement avoid sql injection .

php:

<?php          $output = null;         $mysqli = mysqli_connect("localhost","root","","db") or die ("error in connection");         if(isset($_post['search']))          {             $search=$_post['search'];              $stmt = $conn->prepare("select * emp emp_id = ?");              $stmt->bind_param('i',$_post['search']);              $stmt->execute();              $get_result = $stmt->get_result();              if($get_result->num_rows > 0)              {                while($rows = $get_result->fetch_assoc())                 {                    $mobileno = $rows['emp_mob_no'];                    $output = "mobile no: $mobileno";                 }               }else //here else missed .              {                 $output = "no result";              }         } ?>

Comments

Post a Comment

Popular posts from this blog

ubuntu - PHP script to find files of certain extensions in a directory, returns populated array when run in browser, but empty array when run from terminal -

i running os ububtu 16.04. ultimate goal able run php script cron job every minute. here php script located @ /var/www/html/tests/test/index.php : <?php $directorypath = $_server['document_root']."/tests/test/data/"; echo "directorypath: $directorypath<br><br>";//check $imagefilepathsarray = glob($directorypath . "*.{png,gif}", glob_brace); echo "<br><br>imagefilepathsarray: "; print_r($imagefilepathsarray);//check ?> when open php script in browser visiting url my-ip-address/tests/test/index.php , get: directorypath: /var/www/html/tests/test/data/ imagefilepathsarray:array( [0] => /var/www/html/tests/test/data/pic.png [1] => /var/www/html/tests/test/data/pic.gif ) before writing cron job in crontab file, need check if can run anywhere using terminal . opened ubuntu terminal @ /home/ location, , executed in terminal: sudo php /var/www/html/tests/test/index.php i got following out...
Read more

php - How can i create a user dashboard -

today have questions you, want create user dashboard site, include (obviously), users data, example -email -username -and others stuff how can information, , print them in html page? if can, how can these information via php sessions? shuld use session? example, if user login, , start new session ( session_start() ), how can data print in dashboard? should use php "project"? in advice, have day , thank time!
Read more

javascript - How to detect toggling of the fullscreen-toolbar in jQuery Mobile? -

i have jquery mobile page fixed full-screen toolbar, data-tap-toggle enabled. straight under toolbar have positioned banner should slide upwards when toolbar hiding , slide downward when toolbar showing. jquery mobile toggles toolbar applying , removing ui-fixed-hidden class - sadly, can't find in documentation of toolbar widget toggle , hide or show event that. how can detect when toolbar toggled, reposition banner? .banner { position: fixed; background-color: darkseagreen; top: 46px; min-height: 48px; width: 100%; text-align: center; line-height: 48px; } <!doctype html> <html> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no"> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"> <script src="https://code.jquery.com/jquery-1....
Read more