Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

PHP Form/Mysql Issues

Posted on 2011-03-08
3
Medium Priority
?
198 Views
Last Modified: 2013-12-25
Okay,
I've taken some of your advice, example codes, read some URLs & have build the following but it is not pulling the data from my mysql database so I can see it to edit it. Can soomeone take a look at this to see where my mistake is? I've also attached a photo of the fields I'm trying to edit to help you better understand what I am doing. Thanks

<?php

$con = mysql_connect("localhost","uname","password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("mydb", $con);

$result = mysql_query("SELECT * FROM mytable ");

$i=0;


while ($i < $num) {
$due_ge=mysql_result($result,$i,"due_ge");
$due_rk=mysql_result($result,$i,"due_rk");
$due_ny=mysql_result($result,$i,"due_ny");

?>

<form action="updated.php">
<input type="hidden" name="id" value="<? echo "$id"; ?>">
DATE1: <input type="date" name="due_ge" value="<? echo "$due_ge"?>"><br>
DATE2: <input type="date" name="due_rk" value="<? echo "$due_rk"?>"><br>
DATE3: <input type="date" name="due_ny" value="<? echo "$due_ny"?>"><br>
<input type="Submit" value="Update">
</form>

<?php
++$i;
} 
?>

Open in new window

editeditedit.JPG
0
Comment
Question by:wantabe2
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
3 Comments
 
LVL 27

Expert Comment

by:Lukasz Chmielewski
ID: 35071397
Use this at the top to see what's wrong

$con = mysql_connect("localhost","uname","password") or die(mysql_error());
mysql_select_db("mydb", $con) or die(mysql_error());;

$result = mysql_query("SELECT * FROM mytable ") or die(mysql_error());;
0
 
LVL 27

Accepted Solution

by:
Lukasz Chmielewski earned 2000 total points
ID: 35071431
Aso, there is no $num variable

<?php
$con = mysql_connect("localhost","uname","password") or die(mysql_error());
mysql_select_db("mydb", $con) or die(mysql_error());;
$result = mysql_query("SELECT * FROM mytable ") or die(mysql_error());;
$num = mysql_num_rows($result);
$i=0;

while ($i < $num) {
$due_ge=mysql_result($result,$i,"due_ge");
$due_rk=mysql_result($result,$i,"due_rk");
$due_ny=mysql_result($result,$i,"due_ny");

?>

<form action="updated.php">
<input type="hidden" name="id" value="<? echo "$id"; ?>">
DATE1: <input type="date" name="due_ge" value="<? echo "$due_ge"?>"><br>
DATE2: <input type="date" name="due_rk" value="<? echo "$due_rk"?>"><br>
DATE3: <input type="date" name="due_ny" value="<? echo "$due_ny"?>"><br>
<input type="Submit" value="Update">
</form>

<?php
++$i;
} 

Open in new window

0
 
LVL 27

Expert Comment

by:Lukasz Chmielewski
ID: 35071460
I've noticed that there is no $id declared and for each record there is a form generated - is that correct thing to do ?

add
error_reporting(E_ALL);
to the top of the script and this will tell you more.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
Learn the basics of if, else, and elif statements in Python 2.7. Use "if" statements to test a specified condition.: The structure of an if statement is as follows: (CODE) Use "else" statements to allow the execution of an alternative, if the …
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
Suggested Courses

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question