PHP form on function with SQL request -


i have function on php:

function getlastmatchs($nb) {     try     {     $db = new pdo(dbhost, dbuser, dbpass);     $db->setattribute(pdo::attr_errmode, pdo::errmode_exception);     }     catch(pdoexception $e)     {         die('connexion failed: '.$e->getmessage());     }     $i=0;         $get5tmatchs = $db->query('select wid, lid, date, cwid, clid `match`');         while ($nb<$i)         {             $data5matchs = $get5tmatchs->fetch();             echo '<tr>                     <td>'.$data5matchs['wid'].'</td>';                     echo '<td>'.$data5matchs['lid'].'</td>';                     echo '<td>'.$data5matchs['cwid'].'</td>';                     echo '<td>'.$data5matchs['clid'].'</td>';                     echo '<td>'.$data5matchs['date'].'</td>                     <br>                 </tr>';         $i++;         } }

and form is:

echo '<form action="index.php" method="post">                 <h3>my question......</h3>                 <p>                     <input type="text" name="nbmatchs" />                     <input type="submit" value="ok" />                 </p>                 </form>';         echo getlastmatchs('nbmatchs');

how can show nbmatch time guys want table ? when now, nothing happen. help

ps: exemple tape 5, can see 5 time tabe have put in function.

what indended accomplish (as far understood) allow visitor enter numer , submit after "matches" data shown. number visitor entered acts limiter.

1. post variables? have placed function below form input value of string 'nbmatchs'. guess wanted submit form , 'nbmatches' value , apply sql query filtering. way have done doesn't work. have action attribute on form element set index.php. that's going submit form data. need have way submitted post variables. this: 

$nbmatchs = $_post['nbmatchs'];

never trust data client has given you. know must number let's check on it: 

$nbmatches = is_numeric(trim($_post['nbmatchs'])) ? $_post['nbmatchs'] : 1;

above checked if data client has given number. if we'll assign nubmer variable $nbmatches. if data client has given not number (eg. string) assign number 1 variable. @ point may end script execution let visitor know must enter number assign 1 variable if seems suspicious. after can submit variable function getlastmatchs takes variable , assigns sql query results limiter. assuming code in 1 file 'index.php' should have following code:

<?php  function getlastmatchs($nbmatches) {      try{         $db = new pdo(dbhost, dbuser, dbpass);         $db->setattribute(pdo::attr_errmode, pdo::errmode_exception);     } catch(pdoexception $e) {         die('connexion failed: '.$e->getmessage());     }      try {         $select = $db->prepare('select wid, lid, date, cwid, clid `match` limit '.$nbmatches.';');           $select->execute();         $results = $select->fetchall(pdo::fetch_assoc);     } catch(pdoexception $ex) {         echo "<span style='color:red'>".$ex->getmessage()."</span></p>";       }      echo '<table>';      foreach($results $result){         $output = '<tr>';         $output .= '<td>'.$result['wid'].'</td>';         $output .= '<td>'.$result['lid'].'</td>';         $output .= '<td>'.$result['cwid'].'</td>';         $output .= '<td>'.$result['clid'].'</td>';         $output .= '<td>'.$result['date'].'</td>';         $output = '</tr>';          echo $output;     }      echo '</table>';  }  if(isset($_post['nbmatchs'])){     $nbmatches = is_numeric(trim($_post['nbmatchs'])) ? $_post['nbmatchs'] : 1;     getlastmatchs($nbmatches); }  ?>  <form action="index.php" method="post">     <h3>my question......</h3>     <p>         <input type="text" name="nbmatchs" />         <input type="submit" value="ok" />     </p> </form>

let me know if works way wanted.


Comments

Post a Comment

Popular posts from this blog

get url and add instance to a model with prefilled foreign key :django admin -

Image
i have page in each contest shown in row. each row contains contest id , link other model names have foreign key contest. news model: class news(models.model): title = models.charfield(max_length=50, null=true) description = models.textfield() time = models.timefield( default= datetime.datetime.now().time()) contest = models.foreignkey(contest) i want use admin adding , changing these models. want when user clicks on 'news' has foreign key contest id=1, shows list of news value foreign key. use {% instance in instances %} <tr class="{% cycle 'row1' 'row2' %}"> <td>{{ instance.title }}</td> <td>{{ instance.starttime }}</td> <td>{{ instance.timespan }}</td> <td>{{ instance.date }}</td> <td><a href="/adm...
Read more

android - Keyboard hides my half of edit-text and button below it even in scroll view -

i having trouble keyboard covers edit-text , half of button in scroll view. here's layout , please tell me how should resolve problem. many questions on topic none of them s working me. <?xml version="1.0" encoding="utf-8"?> <linearlayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="match_parent" android:background="@drawable/bg" android:layout_height="match_parent"> <scrollview android:layout_width="match_parent" android:fillviewport="true" android:layout_height="match_parent"> <relativelayout android:layout_width="match_parent" android:layout_height="wrap_content" android:orientation="vertical"> <linearlayout android:layout_width="match_parent" android:layout_height="w...
Read more

css - Make div keyboard-scrollable in jQuery Mobile? -

from can tell, although jquery-mobile-powered pages can contain divs overflow set scroll or auto, , these divs can scrolled one-screen bar or mouse wheel, cannot scrolled using arrow keys, page-up/page-down, or home/end. instead, official "page" div (with data-role="page") absorbs input. perhaps other divs can't acquire focus, i'm not sure. is there way around this? edit: jsfiddle of simple example: https://jsfiddle.net/qogz0shx/ <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js"></script> <script src="https://ajax.googleapis.com/ajax/libs/jquerymobile/1.4.5/jquery.mobile.min.js"> </script> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"/> <style> #outer { overflow:scroll; height: 50vh; width: 50vw; } #inner { height: 500vh; width: 500vw; } ...
Read more