db &amp; refresh problem

db & refresh problem

akaki

Hi,
Please provide me code if anyone has:
1)I create 2 fields named "product name" & "Quantity" in mysql. Now from the front end, i m inserting data from fields. So, 1 value is inserted at a time. But, sometimes product may be more than 1. then i can insert the data from front end using "ADD MORE" button so, the field will increase(with javascript code). But how can i catch all of them to insert to table, becoz in table there is only 1 field for each data?Its emargency.

2) I m facing "refresh" problem. After inserting 1 time, if refresh the page, than values are inserted again.😕 I used "session" to prevent the refresh problem. here is the code: index.php

<?php
session_start();
$_SESSION['refresh'] = false;
?>

<?php
$slno = $_POST[slno];

if(isset($_POST[posted])){

if(!$_SESSION['refresh'])

$q1 = "INSERT INTO practice VALUES('$slno',)";
$r1 = mysql_query($q1);
if($r1){
echo "Data Successfully Inserted<BR>";
$_SESSION['refresh'] = true;

}else{
echo "Failed";
$_SESSION['refresh'] = true;

}
}
?>

But its not working. So, plz help...

Crowly

You have a logical problem here

session_start();
$_SESSION['refresh'] = false;

Each time the page is loaded $_SESSION['refresh'] is set to false, so your INSERT will be run each time. You could change it to

session_start();
if (!isset($_SESSION['refresh'])) $_SESSION['refresh'] = false;

but then you need to figure out when and how you want to change it fra true to false again, since it will stay true until the session expires. Not sure how you should handle the check to set it back to false again, dont know if its possible to check if the buttom was pressed or the paged refreshed.

akaki

Crowly,
My intecsion & code are simple. just show me xactly where should i type session code.
I have some fields to insert data & post them in same page witha message success/failed. so, 1st i start session & make it false.

<?session_start();
$_session[refresh] = "false";
?>

After submitting 1 time, i will get message success/failed in same page.
So, then $session['refresh'] will be true. thats it.
I provided code example. but in which lines i should i make $session true/false, i cant understand. So, Plz provide the total code. Thanks...

cgraz

akaki wrote:
but in which lines i should i make $_session true/false, i cant understand. So, Plz provide the total code. Thanks...

Please don't ask for someone to provide all of your code for you. This is a forum for help/guidance.

Look at Crowly's post. He copied and pasted a section of your code that was causing a problem, and told you to replace it with other code that he provided. Just find the initial code, then replace it with what Crowly posted. No need to repost all of that code.

Crowly

After submitting 1 time, i will get message success/failed in same page.
So, then $_session['refresh'] will be true. thats it.

No, thats your logical problem. You sumbit the page the first time, and $SESSION['refresh'] is set to false, when you do the insert you set $SESSION['refresh'] to true. But the 2nd time $SESSION['refresh'] will be set to false again (right after session_start), no matter what it was before. So when you come down to if(!$SESSION['refresh']), $SESSION['refresh'] is ALWAYS false. You need to add some if's to controll how $SESSION['refresh'] is toggled between true and false. Try my code bit above and see if it will help.

akaki

Ok, Please, can u give a solution:
I m trying to insert date like dd-mm-yy into database table as "date" type.
We know date takes value as yy-mm-dd.
Just imazine, table name-"practice" field's name-"Tdate" type-date. I m trying to insert like this query:

$tdate=$_POST[tdate]; // imazine the form fields name is tdate.
$q1 = "INSERT INTO practice(date_format(date, '%d-%m-%y') TDate)" Values($tdate);
$r1 = mysql_query($q1);
if($r1)
echo "Success";
else
echo "Failed";

But it failed. please any solution?

Crowly

Change $POST[tdate] to $POST['tdate'].

$q1 = "INSERT INTO practice(date_format(date, '%d-%m-%y') TDate)" Values($tdate);

You sql is wrong, you format the date in the wrong place, you need to format the value not the field.
This should be valid sql

$q1 = "INSERT INTO practice(TDate) Values(".$tdate.")";

But it depends on which format $tdate is in, the database expect it to be YYYY-MM-DD, in my country we use the format DD.MM.YYYY so i use a substring rutine to convert it, it looks like this

$tdate=substr($_POST['tdate'],6,4)."-".substr($_POST['tdate'],3,2)."-".substr($_POST['tdate'],0,2);

You should also add some security to values entered into the db from users (post/get), mysql_real_escape_string, then the sql would look like this

$q1 = "INSERT INTO practice(TDate) Values(".mysql_real_escape_string($tdate).")";

Instead of this

$r1 = mysql_query($q1);
if($r1)
echo "Success";
else
echo "Failed";

you can use

mysql_query($q1)||die('Error (tdate): '.mysql_error());

, if something goes wrong it will print out the sql error message, which makes it easier to debug than just "Failed".

Hope this helps.

akaki

I m also trying to insert dd/mm/yy to me TDate field.
Here is xactly i m trying to insert values: There are some xtra fields

$tdate = substr($POST['tdate'],6,4)."-".substr($POST['tdate'],3,2)."-".substr($_POST['tdate'],0,2);

$q1 = "INSERT INTO practice(Sl_No, Name, TDate, Price) VALUES(' ', '$name', '$tdate', '$price')";

I m inserting as: 16-11-07
But in table it's taking like 00-00-00. That means no values.
Is there any problem of 16/11/07?

Crowly

I m also trying to insert dd/mm/yy to me TDate field.
Here is xactly i m trying to insert values: There are some xtra fields

$tdate = substr($POST['tdate'],6,4)."-".substr($POST['tdate'],3,2)."-".substr($POST['tdate'],0,2);

that substring rutine presumes that you start off with dd/mm/yyyy. Not sure if that will make a difference since the year is at the end, but you can try to change $POST['tdate'],6,4) to $_POST['tdate'],6,2

Try to change

$q1 = "INSERT INTO practice(Sl_No, Name, TDate, Price) VALUES(' ', '$name', '$tdate', '$price')";

$q1 = "INSERT INTO practice(Sl_No, Name, TDate, Price) VALUES(' ', '{$name}', '{$tdate}', '{$price}')";

$q1 = sprintf("INSERT INTO practice(Sl_No, Name, TDate, Price) VALUES(' ', '%s', '%s', '%s'),$name,$tdate,$price)";

For testing/debugging purposes it can be very helpful to do a

echo $q1."<br />";

before you excute mysql_query($q1) so that you can check if the INSERT sql looks correct.

akaki

Hello Crowly,
Yes the last "code" worked (dates inside curly braks). But whats the difference?

Crowly

Not to sure about the difference, but curly brackets help PHP determine where the variable starts and ends (according to http://www.hudzilla.org/phpwiki/index.php?title=How_PHP_is_written).
I always like to concatenate in my variables in strings (see ex below), to avoid the any problemes with outputting the variable name instead of the value. I also think the code is a bit easier to read.

You can also concatenate in the variables, this is how i usually do it

$q1 = "INSERT INTO practice(Sl_No, Name, TDate, Price) VALUES(' ', '".$name."', '".$tdate."', '".$price."')";

akaki

Thats cool. But, give me another solution if u can. I m tetriving some data from a table with php code. But if under any column, some data is very long(like address).
Then the main page autometically expanding horizontally. So, the size of every page are not same. No problem, if the page expand vertically. So, any extra code i need to type?

And also, under 1024x768 resulation, the size of the page is shrinking. Any code tocontrol the size?
Thanks...

Crowly

This is not a php issue, but html/css. Check out http://www.w3schools.com, lots of useful information about web "stuff".

Try to put the information into div brackets and set a width parameter either in style, class or id. This will controll when the text should wrap/start on a new line.

<div style="width: 20%"><?php echo $row['adress']; ?></div>
// or
<?php
// \n = newline
echo '<div style="width: 20%">'.$row['adress']."</div>\n";
?>