Updateing a SQL select populated form

Dear Sir/Madam

As i am very new to PHP. i need some help from this group.

I have a form with 10 records populated from my_sql DB,
for simple say Name ,Age ,Sex,place,flg,MoveDate
(flg is chek mark)

say i have populated this info on the php form,
now i want to update only flg and MoveDate,
(MoveDate should be updated whenever flg is set)

Please advise me how to go about this in php with Pear Package
installed

Thanks in Advance

-evolu

Re: Updateing a SQL select populated form

On Mar 30, 10:16 am, bangsund...@gmail.com wrote:
> Dear Sir/Madam
>
> As i am very new to PHP. i need some help from this group.
>
> I have a form with 10 records populated from my_sql DB,
> for simple say Name ,Age ,Sex,place,flg,MoveDate
> (flg is chek mark)
>
> say i have populated this info on the php form,
> now i want to update only flg and MoveDate,
> (MoveDate should be updated whenever flg is set)
>
> Please advise me how to go about this in php with Pear Package
> installed
>
> Thanks in Advance
>
> -evolu

I didn't quite understand your request, could you please be more
speciffic? You want it updated IN the database on the POST of the form
or oyu want it updated live on the user side when the flg is changed?
Please be more speciffic, because the approach is rather different on
those two scenarios.

Re: Updateing a SQL select populated form

bangsundara@gmail.com wrote:
> Dear Sir/Madam
>
> As i am very new to PHP. i need some help from this group.
>
> I have a form with 10 records populated from my_sql DB,
> for simple say Name ,Age ,Sex,place,flg,MoveDate
> (flg is chek mark)
>
> say i have populated this info on the php form,
> now i want to update only flg and MoveDate,
> (MoveDate should be updated whenever flg is set)
>
> Please advise me how to go about this in php with Pear Package
> installed
>
> Thanks in Advance
>
> -evolu
>

Not hard. Fetch the data from your $_POST or $_GET array element and
use a SQL UPDATE statement to update the appropriate rows in your database.

If you want more help, you need to post what you've already tried so we
can help you with it.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Re: Updateing a SQL select populated form

Hello
I sorry for writing late and thanks for the reply,
this is an eg,
what i want to do is , display all the records frm the table,
when the "flg" column is changed i want change MoveDate
and all the operation or over i want to update at once.
Thanks in Advance

-------------------

Display 10 records at a time

Re: Updateing a SQL select populated form

bangsundara@gmail.com wrote:
> Hello
> I sorry for writing late and thanks for the reply,
> this is an eg,
> what i want to do is , display all the records frm the table,
> when the "flg" column is changed i want change MoveDate
> and all the operation or over i want to update at once.
> Thanks in Advance
>
> -------------------
>
>
>
>
>
>

Display 10 records at a time

Re: Updateing a SQL select populated form

>>On 4月6日, 午前3:52, Jerry Stuckle wrote:

Thank you very much for your kind reply.
as per your advice, i made simple php like below pg,

now i have 2 doubt.

1.when i read a data to check box from database, how can i set
cheked when data is 1 not checked when data is 0.

Then
2. After displaying the data, whe the user clicked, then
date field can be entered, if not previous ino is retained
then the update whereever the user changed the checkbox and
date field onlt those info should be updated.

here is the sample code wher i have done till now

--------------------------
// connect to the database :mysql
$host="localhost"; // Host name.
$dbuser="test"; // MySQL username.
$dbpassword="******"; // MySQL password.
$database="test"; // Database name.
mysql_connect($host,$dbuser,$dbpassword) or die('Unable to connect to
thye database');
mysql_select_db($database) or die("Unable to select database");
$result = mysql_query("SELECT * FROM tbltest ORDER BY slno,empid");
$i = 0;

print "

Re: Updateing a SQL select populated form

bangsundara@gmail.com wrote:
>>> On 4月6日, 午前3:52, Jerry Stuckle wrote:
>
> Thank you very much for your kind reply.
> as per your advice, i made simple php like below pg,
>
> now i have 2 doubt.
>
> 1.when i read a data to check box from database, how can i set
> cheked when data is 1 not checked when data is 0.
>

In your checkbox code, you need to add the CHECKED attribute to
the checkbox if the flag is set, i.e.

echo "input type='checkbox' name='{$rec['slno']}' value='{$rec['flg']}'";

if ($rec['flg'] == 1)
echo ' CHECKED';

echo ">\n";


> Then
> 2. After displaying the data, whe the user clicked, then
> date field can be entered, if not previous ino is retained
> then the update whereever the user changed the checkbox and
> date field onlt those info should be updated.
>

You can't do this with PHP on the client. You can use javascript to
enable the date field when the checkbox is checked. Try
comp.lang.javascript for info on that.

When the user submits the data, just look at each of the checkboxes
which has been checked.

But to do this, you need to change your logic. Your checkbox name
should be a constant, such as 'reccb[]'. The value should be the record
number, i.e. $rec['slno'].

Now your $_POST['reccb'] array will contain an item for each checked
checkbox.

You also have another problem in that you have the data field named
rec[$i]. This can create a conflict with your checkbox as you have it
if you have low numbers for your slno.

The solution for this - and to keep your date field more closely related
to the rest of the data - i.e. name it "recdate[$rec['slno']]". Now
when you fetch the checkboxes from the $_POST array, you will have an
entry for the date field, i.e. if $_POST['reccb'][0] contains 123,
$_POST['recdate'][123] will have the new date value.

Use that information to build your SQL statement to update the database.

> here is the sample code wher i have done till now
>
> --------------------------
> > // connect to the database :mysql
> $host="localhost"; // Host name.
> $dbuser="test"; // MySQL username.
> $dbpassword="******"; // MySQL password.
> $database="test"; // Database name.
> mysql_connect($host,$dbuser,$dbpassword) or die('Unable to connect to
> thye database');
> mysql_select_db($database) or die("Unable to select database");
> $result = mysql_query("SELECT * FROM tbltest ORDER BY slno,empid");
> $i = 0;
>
> print "

Re: Updateing a SQL select populated form

Thanks Jerry,

Thank you very muvh for your advise. you are a great teacher.

Here is the code for populate and display check box data with check/d.
and also i attaching a sample for update.
display works ok.
but the updated fails as i am not getting (POST) proper values to
update all are blank.
can you advise me some with some more hint.
Thanks in Advance.

---------------
display:tdisplay.php it works ok
---------------------------------
$host="localhost"; // Host name.
$dbuser="***"; // MySQL username.
$dbpassword="***"; // MySQL password.
$database="test"; // Database name.
mysql_connect($host,$dbuser,$dbpassword) or die('Unable to connect to
thye database');
mysql_select_db($database) or die("Unable to select database");
$result = mysql_query("SELECT * FROM tblsales ORDER BY slno,empid");
$i = 0;
print "

Re: Updateing a SQL select populated form

bangsundara@gmail.com wrote:
> Thanks Jerry,
>
> Thank you very muvh for your advise. you are a great teacher.
>
> Here is the code for populate and display check box data with check/d.
> and also i attaching a sample for update.
> display works ok.
> but the updated fails as i am not getting (POST) proper values to
> update all are blank.
> can you advise me some with some more hint.
> Thanks in Advance.
>
> ---------------
> display:tdisplay.php it works ok
> ---------------------------------
> > $host="localhost"; // Host name.
> $dbuser="***"; // MySQL username.
> $dbpassword="***"; // MySQL password.
> $database="test"; // Database name.
> mysql_connect($host,$dbuser,$dbpassword) or die('Unable to connect to
> thye database');
> mysql_select_db($database) or die("Unable to select database");
> $result = mysql_query("SELECT * FROM tblsales ORDER BY slno,empid");
> $i = 0;
> print "

Re: Updateing a SQL select populated form(Nearly finish)

Thank you very much.Attaching worjking code at the end.

But still javascript I/F is not working,
i.e when i click the check all chek box java script is able to
put check mark on all thye populated check box already with or with
out checked.

Thanks for your advice and you are so nice and you are one among the
best of best of JDS Computer Training Corp. (i only know you only at
present)

code: what it will do :
It will read some info from table and populate and display data with
edit date filed and check mark to modify and chek mark to delete the
record.

pending:
javascript portion: check all chkbox, and depending on this enable and
disable the edit field.
please note No error check, no SQL injection avoidance, database
conection is not good (used twice!!)
but may be good for learner.
taken help from:
Mr.Jerry Stuckle (Ms ??? i do not know)
and Mr.Peter of canada (Google search)

---------------------------------------

code for populate data :tdisplaynew.php
======================================





// connecting to the DB better to use class so that we can use in
later pg
$host="localhost";
$dbuser="root";
$dbpassword="";
$database="test";
mysql_connect($host,$dbuser,$dbpassword) or die('Unable to connect to
thye database');
mysql_select_db($database) or die("Unable to select database");
// excuite the query
$result = mysql_query("SELECT * FROM tblsales ORDER BY slno,empid");
// counter start to display data from db and hold the positions of an
record
$slno=0; // this is no relations with the table field better to use
i or j
print "

Inside the delete loop $i ";
// Here delete if the delete flag is selected
$queryd = "DELETE from `tblsales` WHERE `empid` = '$eid' ";
mysql_query($query) or die ("Error in query: $query");
print "Delete Success

Re: Updateing a SQL select populated form(Nearly finish)

bangsundara@gmail.com wrote:
> Thank you very much.Attaching worjking code at the end.
>
> But still javascript I/F is not working,


>
>

There is a reason why people adopt conventions of indentation and brace
spacing.

function allcheck()
{
if (document.namestoupdate.allcheck.checked)
{
for(i=0; if (document.namestoupdate.elements[i].name == "flg[]")
// I see no third term in here. it should be "for(a;b;c)"
// And no IF statement is required, its implied in the
// definition of the expression 'b'
{
document.namestoupdate.elements[i].checked = true;
}
}

// Gosh. Three opening braces and only two closing ones..... wheres the
last one

}