html - How to add variables into a mysql table from php -


okay objective have people able select there schedule. code far

<?php  //if form has been submitted process if(isset($_post['submit'])){      $servername = "localhost";     $username = "username";     $password = "password";     $dbname = "jesuitschedule";      try {         $conn = new pdo("mysql:host=$servername;dbname=$dbname", $username, $password);         // set pdo error mode exception         $conn->setattribute(pdo::attr_errmode, pdo::errmode_exception);         $sql = 'insert schedule (saturdaymorning, saturdayafternoon, sundaymorning, sundayafternoon, weekday) values (:saturdaymorning, :saturdayafternoon, :sundaymorning, :sundayafternoon, :weekday)';         // use exec() because no results returned         $conn->exec($sql);         echo "new record created successfully";         }     catch(pdoexception $e)         {         echo $sql . "<br>" . $e->getmessage();         }      $conn = null; }  //define page title $title = 'schedule';  //include header template require('layout/header.php'); ?><!doctype html> <html lang="en"> <head>     <meta charset="utf-8">     <title>schedule</title>     <link href="//netdna.bootstrapcdn.com/bootstrap/3.1.0/css/bootstrap.min.css" rel="stylesheet">     <link rel="stylesheet" href="style/main.css"> </head> <body>  <div class="container">      <div class="row">          <div class="col-xs-12 col-sm-8 col-md-6 col-sm-offset-2 col-md-offset-3">             <form role="form" method="post" action="" autocomplete="off">                 <h2>please select schedule</h2>                 <hr>                   <div class="form-group">                     <input type="checkbox" name="saturdamorning" id="satmor" class="form-control input-lg" placeholder="user name" value="yes" tabindex="1">saturday morning <br>                 </div>                 <div class="form-group">                     <input type="checkbox" name="saturdayafternoon" id="sataft" class="form-control input-lg" placeholder="s" value="yes" tabindex="2">saturday afternoon <br>                 </div>                 <div class="form-group">                     <input type="checkbox" name="sundaymorning" id="sunmor" class="form-control input-lg" placeholder="s" value="yes" tabindex="3">sunday afternoon <br>                 </div>                 <div class="form-group">                     <input type="checkbox" name="sundayafternoon" id="sataft" class="form-control input-lg" placeholder="s" value="yes" tabindex="4">sunday morning <br>                 </div>                 <div class="form-group">                     <input type="checkbox" name="weekday" id="email" class="form-control input-lg" placeholder="s" value="yes" tabindex="5">weekday <br>                 </div>                   <div class="row">                     <div class="col-xs-6 col-md-6"><input type="submit" name="submit" value="register" class="btn btn-primary btn-block btn-lg" tabindex="6"></div>                 </div>             </form>         </div>     </div>  </div>  </body> </html>

when run code works no errors when check table blank rows. code adds new sets of rows doesn't add data them. trying add either yes, or keep blank if not select it. great thanks.

as pointed out fred -ii-, you've not bound statement. here's code using prepared statement. i've commented code explain position

if(isset($_post['submit'])){      $servername = "localhost";     $username = "username";     $password = "password";     $dbname = "jesuitschedule";      try {         $conn = new pdo("mysql:host=$servername;dbname=$dbname", $username, $password);         // set pdo error mode exception         $conn->setattribute(pdo::attr_errmode, pdo::errmode_exception);         // have sql statement, attempting insert non-existant values. you'll either         // wind error, values given in statement inserted table,         // or empty values.         //$sql = 'insert schedule (saturdaymorning, saturdayafternoon, sundaymorning, sundayafternoon, weekday) values (:saturdaymorning, :saturdayafternoon, :sundaymorning, :sundayafternoon, :weekday)';          // create prepared statement, let's bind parameters         $stmt = $con->prepare(             'insert schedule (                 saturdaymorning, saturdayafternoon, sundaymorning, sundayafternoon, weekday                 ) values (                 :saturdaymorning, :saturdayafternoon, :sundaymorning, :sundayafternoon, :weekday                 )';         );          // use exec() because no results returned         //$conn->exec($sql); // you're executing statement no bound parameters          // can use bindparam, find method tad easier         // take stmt created above, , bind values parameters given         // in statement, but, execute. :)         $stmt->execute(array(             ':saturdaymorning' => 'value',             ':saturdayafternoon' => 'value',             ':sundaymorning' => 'value',             ':sundayafternoon' => 'value',             ':weekday' => 'value'         ));         echo "new record created successfully";         }     catch(pdoexception $e)         {         echo $sql . "<br>" . $e->getmessage();         }      $conn = null; }

if you'd more info on this, take @ pdo page php site, pulled fix: php: pdo - manual


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