StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
19086200
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
17
CommunityOwnedDate
CreationDate
2013-09-30T03:48:54.210
FavoriteCount
0
LastActivityDate
2013-09-30T06:06:29.190
LastEditDate
2017-05-23T12:29:31.737
LastEditorUserId
-1
OwnerUserId
1415724
ParentId
19085628
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
<p>I tested your code and found that your submit button was one of the things at fault, including an improperly place semi-colon in: </p> <pre><code>$query = "INSERT INTO scoreboard (name,percent) VALUES ('$getname','$percentage');" </code></pre> <p>Which should read as:</p> <pre><code>$query = "INSERT INTO scoreboard (name,percent) VALUES ('$getname','$percentage')"; </code></pre> <h2>Tested using the following form and PHP</h2> <pre><code><form method="post" action=""> <center> <font color="green">Your name Max length is 15</font> <input type="text" name="username" maxlength="15"> <input type="submit" name="submit" value="Submit"> </center> </form> <?php if (isset($_POST['username'])) { $link = mysqli_connect("myhost","myusername","mypw","mydatabase") or die("Error " . mysqli_error($link)); // $getname = $_POST['username']; $getname = mysqli_real_escape_string($link,$_POST['username']); $percentage = "10"; $query = ("INSERT INTO scoreboard (name,percent) VALUES ('$getname',$percentage)"); $result = mysqli_query($link, $query); if(!$result){ printf("Error message: %s", mysqli_error($link)); } else { echo "Data properly inserted with the value of <b>$getname</b> and <b>$percentage</b>"; } } ?> </code></pre> <p><strong>NOTE:</strong> You will be better off using the code below in order to check if the field is empty. Otherwise, clicking on the submit button without anything inside, will produce an entry in DB with a blank name field.</p> <pre><code>if (empty($_POST['username'])) { die("<div align='center'>Enter your name</div>"); } else { // rest of code </code></pre> <p>Plus as stated by Hanky 웃 Panky, you should sanitize your variables like this, as done in my working example:</p> <pre><code>$getname = mysqli_real_escape_string($link,$_POST['username']); </code></pre> <hr> <p><strong>Here is a safer (parametrized) method</strong> as taken from an example on <a href="https://stackoverflow.com/a/60442/1415724">SO here</a> </p> <p><strong>Quick note:</strong> If you are going to use <code>$percentage = 10;</code> instead of <code>$percentage = "10";</code></p> <p>then you will need to use <code>$stmt->bind_param("si", $unsafe_variable,$percentage);</code> otherwise, your percentage will be treated as a string, as opposed to an integer and will be thrown an error. <code>s</code> is for <code>string</code> and <code>i</code> is for <code>integer</code>.</p> <pre><code><form method="post" action=""> <center> <font color="green">Your name Max length is 15</font> <input type="text" name="username" maxlength="15"> <input type="submit" name="submit" value="Submit"> </center> </form> <?php if (empty($_POST['username'])) { die("<div align='center'>Enter your name</div>"); } else { $mysqli = new mysqli("myhost","myusername","mypw","mydatabase"); // Check that connection was successful. if($mysqli->connect_errno > 0) { die('Connection failed [' . $mysqli->connect_error . ']'); } $percentage = "10"; $unsafe_variable = $_POST["username"]; $stmt = $mysqli->prepare("INSERT INTO scoreboard (name,percent) VALUES (?,?)"); // TODO check that $stmt creation succeeded // "s" means the database expects a string $stmt->bind_param("ss", $unsafe_variable,$percentage); $stmt->execute(); $stmt->close(); $mysqli->close(); echo "<div align='center'>Data written to DB</div>"; } ?> </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POPHP and sql issue
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USCommunity
UserOwnerUserId
1. USFunk Forty Niner
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POPHP and sql issue
  singulars
  PostTypePostTypeId
  PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
2. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTAcceptedByOriginator
3. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
CommentsPostId

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.