two input type in php mysql-query -


i have table in 2 text fields , 1 input text field. query created new row, , if there one, update.

if (isset($_post['submit'])) { $text = !empty($_post['text']) ? $_post['text'] : null; foreach ($text $idt => $pages) { if ($pages != null) {     $todb = $mysqli->query('insert extendtovar (book_id, pages)  values ("' . $idt . '", "' . $pages . '")  on duplicate key update pages = "' . $pages . '"');   }  } }      $todb = $mysqli->query('select    nalvmag.id id,   nalvmag.name name,   extendtovar.book_id id2,   extendtovar.pages pages   nalvmag left join extendtovar    on nalvmag.id = extendtovar.book_id    nalvmag.remainder > 0   order name asc');   echo '<table class="raz">';   while ($row = $todb->fetch_array())   { echo '<tr><td>'.$row[id].'</td>';       echo '<td>'.$row[name].'</td>';       echo '<td><input type="text" name="text['.$row[id].']" value="'.$row[pages].'" maxlength="5" size="6"><br></td></tr>';   }     echo '</table>';      echo'<button type="submit" name="submit">submit</button></form>'; }

but want add 1 more input text field

echo $row[id]; echo row[name]; echo '<input type="text" name="text['.$row[id].']" value="'.$row[pages].'" maxlength="5" size="6"> echo '<input type="text" name="text2['.$row[id].']" value="'.$row[pages2].'" maxlength="5" size="6">

and when update php code 

if (isset($_post['submit'])) {     $text = !empty($_post['text']) ? $_post['text'] : null;     foreach ($text $idt => $pages) {     if ($pages != null) {         $todb = $mysqli->query('insert extendtovar (book_id, pages, pages)      values ("' . $idt . '", "' . $pages . '", "' . $pages2 . '")      on duplicate key update pages = "' . $pages . '", pages2 = "' . $pages2 . '"');       }      }     }

field pages2 not update.

i can not understand how change foreach , form request


Comments

Post a Comment

Popular posts from this blog

PHP and MySQL WP -

i trying accomplish 2 things here code. writing php directly wp page using insert php plugin. 1) query mysql database , return results 1 column 4 columns. 2) make each result own hyperlink directs user new wp page runs new query on page. i able query show results , turn results dynamic hyperlink, cannot formatting down. right returns result 1 column. here have: [insert_php] $servername = "localhost"; $username = "login"; //edited privacy $password = "password"; //edited privacy $database = "database"; //edited privacy // create connection $conn = new mysqli($servername, $username, $password, $database); // check connection if ($conn->connect_error) { die("connection failed: " . $conn->connect_error); } echo "connected successfully"; //get results database $result = mysqli_query($conn,"select mine mines order mine"); $all_property = array(); //declare array saving property //showing proper...
Read more

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

i'm implementing inapp billing in android app. works well, however, i'm trying decouple broadcast receiver activity manifest. suggestion in android's trivialdrive sample: // important: dynamically register broadcast messages updated purchases. // register receiver here instead of <receiver> in manifest // because call getpurchases() @ startup, therefore can ignore // broadcasts sent while app isn't running. // note: registering listener in activity bad idea, done here // because sample. regardless, receiver must registered after // iabhelper setup, before first call getpurchases(). currently there's class extends broadcastreceiver : public class iabbroadcastreceiver extends broadcastreceiver { /** * intent action receiver should filter for. */ public static final string action = "com.android.vending.billing.purchases_updated"; private final iabbroadcastlistener mlistener; public iabbroadcastreceiver(iabbroadcastlistener listener) { m...
Read more

go - golang pprof for c library code -

i have been trying profile golang application pprof, seems details of c code(linked static library) missed in output result. flame graph from frame graph can see c code time consuming reported within "runtime._externalcode", no details @ all. , sure static library compiled debug enable. so there way make pprof details(like stack trace) of 3rd party c code? or there other golang profiling tool this?
Read more