Need a little help with some code from a more experienced php coder

malvernphpman

Hello there i need a little help as im very new to php and i need a little help on something. I need some code that will display an error message or a html form depending on what is or isnt in the value feild of a table in a mysql database

and these are the values i have to use in the table of the mysql database. Well the ones i wish to use anyway

`user_id``value``created_at`

these are the total that can be used

`id``field_id``user_id``value``created_at`

What it is i want to do is if the value of value is empty show a html form and if the value of value has data in it then show/echo an error message that i can use a CSS <DIV> class in saying "Sorry you already have value that you created on created_at

Thanks for the help in advance!

dagon

and so far you have written?

malvernphpman

Nothing as i am stuck as where to start

dalecosp

I'd recommend either

<html>
   <head>
      <title>My page</title>

or else:

<?php

/* 
This is "my_script.php", written by me.  It will either 
display an error message or an HTML form, depending 
on whether some value is set in the database.
*/

malvernphpman

dalecosp;10974605 wrote:

I'd recommend either

<html>
   <head>
      <title>My page</title>

or else:

<?php

/* 
This is "my_script.php", written by me.  It will either 
display an error message or an HTML form, depending 
on whether some value is set in the database.
*/

I dont wish to be so rude but i carnt help it. What you just replyed with is a little bit on the sarcastic side of replys. Im sorry to say im looking for help not insults. I have got that far, and further since posting this. However like i said im new to php and learn from being shown how to do it. And rung (like now) into issues fromm time to time and turn to forums full of experienced php coders for help!.

Since posting this i have managed to compile a PHP coded file. But have drawn a blank, it isnt working and am looking for advise as to why it wouldnt be working. When i say its not working it is displaying the form regardless of wether 'value' is empty or not. What it should be doing is if 'value' has content in it do NOT show the form and if the content of 'value' is empty show the form.

Please see the below code:

<?php 

$con = mysql_connect(localhost,username,password);   // the connection to ur database
$db = mysql_select_db(mydatabasename);  // select the database name

$rs = mysql_query("select * from mytablename");  // the sql query to fetch records from ur table
if(mysql_num_rows($rs)>0)
{
     if($row['value']=='')    

     { ?>

<form name="frmEmail" method="post">
<table width="400" border="0">
<tr><td>Username:</td><td><input name="user" size="20" type="text" /></td></tr>
<tr><td>Password:</td><td><input name="pass" size="20" type="password" /></td></tr>
<tr><td>Verify Password:</td><td><input name="vpass" size="20" type="password" /></td></tr>
<tr><td colspan="2" align="center"><hr /><input name="submit" type="submit" value="Create Email" /></td></tr>
</table>
</form> 
     <?php } else
     { ?>   

     <div class="error">Sorry, you already have data created on <?= $row['created_at']; ?>.
     <?php } 
}
else 
     echo 'Failed to retrieve records';
?>

I maybe missing something really silly and just to help you out a little more i have provided an image of the table in question inside the mysql database. Please see the attached image link just below this text.

dagon

I dont wish to be so rude but i carnt help it. What you just replyed with is a little bit on the sarcastic side of replys. Im sorry to say im looking for help not insults. I have got that far, and further since posting this. However like i said im new to php and learn from being shown how to do it. And rung (like now) into issues fromm time to time and turn to forums full of experienced php coders for help!.

You may want us to write it for you but we wont, we will help if you actully make an attempt (hence my prompt for code). Now that you have actully botherd to try, we will assist:

$row is not defined in your code.

malvernphpman

Ok thanks for your reply. Like i said i learn by view i have speacil needs and its the only way i can learn by visual means.

Ok back to the mission in hand how would i define $row in my code?

malvernphpman

I know it has something to do with this line of code i have found that much out

if($row['value']=='')

However i have to define it and how i am unsure.

I have a feeling it has got to have something inbetween these 2 '' thingys

sneakyimp

I don't know for sure, but it sounds to me like you want $row to contain the information you retrieved from the database using mysql_query.

You'll need to use [man]mysql_fetch_assoc[/man].

JVassie

$row = mysql_fetch_assoc($rs);

Ought to do the trick 🙂