Databases
StackOverflow2013
Postsdbo
POUnable to input numbers into MySQL using php statement
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POUnable to input numbers into MySQL using php statement
    primarykey
    data
    text
    <p>I am working on a website where an administrator can edit a schedule that they already created. They can click on any item on the schedule to edit it. For example, they can click on the shift start time and then it directs them to a page where they can update the value.</p> <p>Unfortunately, I have not been able to get this to work for every value. It seems to be that the text values are working just fine, but I am getting a syntax error when it is a number.</p> <p>Here is what I am using to update:</p> <pre><code>$type = $_GET['type']; $value = $_GET['value']; $week = $_GET['week']; $newval = $_POST['newval']; if(strlen($newval) &gt; 0) { include '../dbinfo.php'; $type = $mysqli-&gt;real_escape_string($_POST['type']); $week = $mysqli-&gt;real_escape_string($_POST['week']); $tablename = $mysqli-&gt;real_escape_string("cs" . $_SESSION['squadron']); $newval = $mysqli-&gt;real_escape_string($newval); if((is_numeric($newval))) { $sql = "UPDATE $tablename SET $type=$newval WHERE week=$week"; } else { $sql = "UPDATE $tablename SET $type='$newval' WHERE week=$week"; } if($result = $mysqli-&gt;query($sql)) { echo "Your specififed changed was completed successfully!&lt;br&gt;"; echo "&lt;a href='edit.php?week=" . $week . "'&gt;Continue editing&lt;/a&gt;"; } else { echo mysqli_error($result); } } </code></pre> <p>Changing a string results in the sql statement: </p> <pre><code>UPDATE cs14 SET shift_1_name='Test' WHERE week=1 (this works) </code></pre> <p>Changing a number results in the sql statement: </p> <pre><code>UPDATE cs14 SET shift_ 1_starttime=940 WHERE week=1 (this doesn't work) </code></pre> <p>It is giving me the MySQL error: </p> <pre><code>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1_starttime=940 WHERE week=1' at line 1 </code></pre> <p>I have already researched this error, and I have checked the syntax over and over again. It doesn't work in phpmyadmin either. I have no idea what to check next!</p> <p>Can anyone help me out with my syntax here??? Thanks!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USChris
    1. USbrokekidweb
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POUnable to input numbers into MySQL using php statement
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COis the column type you're using of type `int` (or other numeric) ?
      singulars
      1. POUnable to input numbers into MySQL using php statement
      1. USNick Andriopoulos
    2. CONewval shouldn't be a string especially if your database is set to integer for that value.
      singulars
      1. POUnable to input numbers into MySQL using php statement
      1. USkarmafunk
    3. COcolumn type for everything is varchar. When I tried to change a date (that had ints in it), it still gave me an error, so I don't believe it's a column error. I tried even without quotes but I get the same error.
      singulars
      1. POUnable to input numbers into MySQL using php statement
      1. USbrokekidweb
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload