Jump to content

elentz

Members
  • Content Count

    228
  • Joined

  • Last visited

Community Reputation

0 Neutral

About elentz

  • Rank
    Advanced Member

Profile Information

  • Gender
    Not Telling

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. I wonder how I missed that... Anyway it works like it should. Thank you Barand!!
  2. got it, no errors now.. I didn't correctly connect to Mysql either. Had to fix that. No update to the DB yet It reads the table contents. Just to show what I am working with, mostly from barand. I do get the echo connected successfully Thanks // Create connection try { $db = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password); // set the PDO error mode to exception $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); echo "Connected successfully"; } catch(PDOException $e) { echo "Connection failed: " . $e->getMe
  3. Hmm, My system is using php version 5.6 I cannot change it either. Would that be the reason that the http error log throws that error?
  4. I have the script retrieving the info from the table so the connection is correct. The submit doesn't update the table. In the logs I am getting this: mysqli_stmt::execute() expects exactly 0 parameters, 1 given on line 20 $updt->execute( [ $reset, $id ] ); I also have to comment out this line in order for the page to work as above $reset = $_POST['reset'][$id] ?? 0; // if checkbox wasn't posted then it is "0"
  5. Sometimes I might not make my needs as clear to others as it might appear in my head. Thanks fo ryour help
  6. got it. I originally envisioned a bunch or rows with a checkbox on the end. check all the boxes you want, click a submit button to update the DB and run another page to reboot the phones. If I misspoke and indicated that I wanted to use the checkbox as a submit type of operation I apologize, not what I meant. I haven't had anytime to work on this at all today, maybe tomorrow Thanks
  7. I think I have the idea. Thanks
  8. Ah I think I understand now
  9. Instead of a submit button could a checkbox work? What about a Yes/No dropdown? I want to select the phones I want to restart, update a DB table and then use a submit button to go to another page that will run a query to reset the phones.
  10. I do have a primary key assignedto the id field
  11. ginerjm That sounds like the way to go, I could have any number of rows and updating as each is checked would be best. Gizmola, I think I do have a primary key on that table, can't check from home tho.
  12. I think I get what you are saying. I will see what I can do. Thanks
  13. I do have some code. $sql = "select * from extensions"; $result = mysqli_query($link,$sql) or die(mysql_error()); echo "<table border='3'> <tr> <th>Extension #</th> <th>Reboot</th> </tr>"; while($row = mysqli_fetch_array($result)) { echo "<tr>"; echo "<td>" . $row['extension'] . "</td>"; echo "<td>'."<input type='checkbox' class='form' value='1' name='checkbox[" . $row['reset'] . "]' />".'</td>"; echo "</tr>"; } echo "</table>"; ?> I wa
  14. I have a need to create a form that will get info from a mysql table, show that info, two fields one of which I want to be a checkbox that will need to update the table with either a 0 or a 1. I will later use that info. I have searched all over and haven't found what I am looking for. I can find tutorials for creating checkboxes but nothing what I need / want
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.