StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POupdate mysql row with html form and php
primarykey
Id
20804505
data
AcceptedAnswerId
20804582
AnswerCount
5
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2013-12-27T16:53:24.697
FavoriteCount
0
LastActivityDate
2014-09-18T19:40:01.683
LastEditDate
2013-12-27T18:58:11.733
LastEditorUserId
3139971
OwnerUserId
3139971
ParentId
0
PostTypeId
1
Score
0
ViewCount
2145
LastEditorDisplayName
text
Body
<p>I've been looking through many threads on here without finding a solution to my problem. I've created a form that is supposed to show content of a database in input boxes, and when i change the content, it should be updated in the database.</p> <p>No errors, nothing gets changed.</p> <pre><code><?php $con=mysqli_connect("localhost","root","","frontpage"); // Check connection if (mysqli_connect_errno()){ echo "Failed to connect to MySQL: " . mysqli_connect_error(); } $result = mysqli_query($con,"SELECT * FROM frontpage_left_links") or die("Error: ".mysqli_error($con)); while($row = mysqli_fetch_array($result)){ echo '<form action="" method="post">'; echo '<div style="float:left">'; echo '<table border="1" bordercolor="#000000">'; echo '<tr>'; echo '<td>link</td>'; echo '<td><input type="text" name="linkid" value="'.$row['link'].'"></td>'; echo '</tr>'; echo '<tr>'; echo '<td>img</td>'; echo '<td><input type="text" name="imgid" value="'.$row['img'].'"></td>'; echo '</tr>'; echo '<tr>'; echo '<td>tekst</td>'; echo '<td><input type="text" name="imgid" value="'.$row['name'].'"></td>'; echo '</tr>'; echo '<tr>'; echo '<td><input type="submit" id="update" name="gem" value="Gem"</td></td>'; echo '<td><input type="hidden" name="id" value="'.$row['id'].'"></td>'; echo '</tr>'; echo '</table></div>'; echo '<div style="float:left"><a href="'.$row['link'].'"><center><img src="img/'.$row['img'].'"><br />'.$row['name'].'</center></a></div>'; echo '</form><br /><br /><br /><br /><br /><br /><br /><br />'; } if(isset($_POST['update'])){ $id = $_POST['id']; $link = $_POST['linkid']; $img = $_POST['imgid']; $name = $_POST['nameid']; $sql = mysqli_query("UPDATE frontpage_left_links SET link = '$link', img = '$img', name = '$name' WHERE id = '$id'"); $retval = mysqli_query( $sql, $con ); if(! $retval ){ die('Could not update data: ' . mysql_error()); } echo "Updated data successfully\n"; } mysqli_close($con); ?> </code></pre> <p>The form show the database content fine, but nothing happens when changed.</p> <p>I appreciate any help I can get.</p> <hr> <p>This is what it looks like now.</p> <pre><code><?php $con=mysqli_connect("localhost","root","","frontpage"); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } if(isset($_POST['gem'])) { $id = $_POST['id']; $link = $_POST['linkid']; $img = $_POST['imgid']; $name = $_POST['nameid']; $sql = mysqli_query("UPDATE frontpage_left_links SET link = '$link', img = '$img', name = '$name' WHERE id = '$id'"); $retval = mysqli_query( $con, $sql ); if(! $retval ) { die('Could not update data: ' . mysql_error()); } echo "Updated data successfully\n"; } $result = mysqli_query($con,"SELECT * FROM frontpage_left_links") or die("Error: ".mysqli_error($con)); while($row = mysqli_fetch_array($result)) { echo '<form action="" method="post">'; echo '<div style="float:left">'; echo '<table border="1" bordercolor="#000000">'; echo '<tr>'; echo '<td>link</td>'; echo '<td><input type="text" name="linkid" value="'.$row['link'].'"></td>'; echo '</tr>'; echo '<tr>'; echo '<td>img</td>'; echo '<td><input type="text" name="imgid" value="'.$row['img'].'"></td>'; echo '</tr>'; echo '<tr>'; echo '<td>tekst</td>'; echo '<td><input type="text" name="nameid" value="'.$row['name'].'"></td>'; echo '</tr>'; echo '<tr>'; echo '<td><input type="submit" id="update" name="gem" value="Gem"</td></td>'; echo '<td><input type="hidden" name="id" value="'.$row['id'].'"></td>'; echo '</tr>'; echo '</table></div>'; echo '<div style="float:left"><a href="'.$row['link'].'"><center><img src="img/'.$row['img'].'"><br />'.$row['name'].'</center></a></div>'; echo '</form><br /><br /><br /><br /><br /><br /><br /><br />'; } mysqli_close($con); ?> </code></pre> <p>Now i get this error.</p> <p>Warning: mysqli_query() expects at least 2 parameters, 1 given in /Applications/XAMPP/xamppfiles/htdocs/page/admin.php on line 17</p> <p>Warning: mysqli_query(): Empty query in /Applications/XAMPP/xamppfiles/htdocs/page/admin.php on line 19 Could not update data: </p>
Tags
<php><html><mysql><forms><sql-update>
Title
update mysql row with html form and php
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USuser3139971
UserOwnerUserId
1. USuser3139971
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
2. PO
  singulars
  PostTypePostTypeId
  PTAnswer
3. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  POupdate mysql row with html form and php
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTApproveEditSuggestion
CommentsPostId
1. COYou have wrong your submit button name and could you just print your sql query and see it works in the database?
  singulars
  PostPostId
  POupdate mysql row with html form and php
  UserUserId
  USAwlad Liton

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.