DaniWeb Forum Index > Web Development > PHP

customised the locked textboxes and save as new data

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Oct 2008

Posts: 2,429

Reputation: adatapost has much to be proud of

Solved Threads: 437

adatapost

Offline

Nearly a Posting Maven

Re: customised the locked textboxes and save as new data

#11

Jun 13th, 2009

•

Originally Posted by tulipputih

ok..thanks.this is my code
Help with Code Tags

php Syntax (Toggle Plain Text)
  <?php
   $query= mysql_query(" SELECT * FROM lesson
   					WHERE lessonID='" . $_GET['lessonID'] . "'");
 
      while($entry=mysql_fetch_array($query))
      {
	 echo " Subject: ";
	 echo '<input  name="subject" readonly="readonly" value="', $entry['subject'] , '" /><br />';
         echo " Year:"; 
	 echo '<input  name="year" readonly="readonly" value="', $entry['year'] , '" /><br />';
 
 
  }
 
   ?>
<?php $query= mysql_query(" SELECT * FROM lesson WHERE lessonID='" . $_GET['lessonID'] . "'"); while($entry=mysql_fetch_array($query)) { echo " Subject: "; echo '<input name="subject" readonly="readonly" value="', $entry['subject'] , '" /><br />'; echo " Year:"; echo '<input name="year" readonly="readonly" value="', $entry['year'] , '" /><br />'; } ?>

Your code misses :

1. Form tag
2. Single quote never evaluates/expand variables.
3. No submit buttons.

Get a hint from the given code:

page1.php

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?php
   $flag="disabled=\"disabled\"";
   $cmd=$_REQUEST["cmd"];
 
    $query= mysql_query(" SELECT * FROM lesson
   			 WHERE lessonID='" . $_GET['lessonID'] . "'");
 
   $no="";
   $name=""; 
    if($entry=mysql_fetch_array($query)) {
         $no=$entry[0];  $name=$entry[1];
     }
 
   if(isset($cmd)) {
      if($cmd=="Edit") 
           $flag="";
     else
     if($cmd=="Update") {
             ..... Write code to update a record.
        }
     }
?>
 
<form method="post" action="page1.php">
No <input type="text"  
             <?php echo $flag ?> 
             name="no" 
             value="<?php echo $no?>"
              />
<br/>
Name <input type="text"  
              <?php echo $flag ?> 
              name="name" 
              value="<?php echo $name?>"
               />
 
<input type="submit" name="cmd" value="Edit"/>
<input type="submit" name="cmd" value="Cancel"/>
<input type="submit" name="cmd"  <?php echo $flag ?>   value="Update"/>
</form>
<?php
   $flag="disabled=\"disabled\"";
   $cmd=$_REQUEST["cmd"];

    $query= mysql_query(" SELECT * FROM lesson
   			 WHERE lessonID='" . $_GET['lessonID'] . "'");
   
   $no="";
   $name=""; 
    if($entry=mysql_fetch_array($query)) {
         $no=$entry[0];  $name=$entry[1];
     }

   if(isset($cmd)) {
      if($cmd=="Edit") 
           $flag="";
     else
     if($cmd=="Update") {
             ..... Write code to update a record.
        }
     }
?>

<form method="post" action="page1.php">
No <input type="text"  
             <?php echo $flag ?> 
             name="no" 
             value="<?php echo $no?>"
              />
<br/>
Name <input type="text"  
              <?php echo $flag ?> 
              name="name" 
              value="<?php echo $name?>"
               />
  
<input type="submit" name="cmd" value="Edit"/>
<input type="submit" name="cmd" value="Cancel"/>
<input type="submit" name="cmd"  <?php echo $flag ?>   value="Update"/>
</form>

Failure is not fatal, but failure to change might be. - John Wooden

•

Join Date: May 2009

Posts: 81

Reputation: tulipputih is an unknown quantity at this point

Solved Threads: 0

tulipputih tulipputih is offline

Offline

Junior Poster in Training

Re: customised the locked textboxes and save as new data

#12

Jun 15th, 2009

Thanks Atli & Adatapost for your responses.

Adatapost,
What I intend to do is to insert a new record after customising the display data ( by click edit button).. so, I need to change "update" to "insert"..am I?

& how can the id be increased based on the highest id in the table?

thanks

•

Join Date: Oct 2008

Posts: 2,429

Reputation: adatapost has much to be proud of

Solved Threads: 437

adatapost

Offline

Nearly a Posting Maven

Re: customised the locked textboxes and save as new data

#13

Jun 15th, 2009

•

Originally Posted by tulipputih

Thanks Atli & Adatapost for your responses.

Adatapost,
What I intend to do is to insert a new record after customising the display data ( by click edit button).. so, I need to change "update" to "insert"..am I?

& how can the id be increased based on the highest id in the table?

thanks

Add another submit button with value="Insert" and name="cmd". Compare value of $cmd and if it is "Insert" then write code to insert a record.

Failure is not fatal, but failure to change might be. - John Wooden

•

Join Date: May 2009

Posts: 81

Reputation: tulipputih is an unknown quantity at this point

Solved Threads: 0

tulipputih tulipputih is offline

Offline

Junior Poster in Training

Re: customised the locked textboxes and save as new data

#14

Jun 17th, 2009

hello all,
thanks for your input

•

& how can the id be increased based on the highest id in the table?

what I mean here is to enable an ID auto increment whenever we insert a new record to the table.
Do I have to query the maximum number in that table,
then ID++.
Is it correct? any proper syntax?
thanks

•

Join Date: May 2007

Posts: 370

Reputation: Atli is an unknown quantity at this point

Solved Threads: 46

Atli

Offline

Posting Whiz

Re: customised the locked textboxes and save as new data

#15

Jun 17th, 2009

You can simply add the AUTO_INREMENT option to the column that is supposed to incremented, and leave it out of the INSERT query.

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
CREATE TABLE test (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `value` VARCHAR(255) NOT NULL,
  PRIMARY KEY(`id`);
);
 
INSERT INTO test(`value`)
VALUES ('First'), ('Second'), ('Third');
 
SELECT * FROM test;
+----+--------+
| id | value  |
+----+--------+
|  1 | First  |
|  2 | SECOND |
|  3 | Third  |
+----+--------+
CREATE TABLE test (
  `id` Int Unsigned Not Null Auto_Increment,
  `value` VarChar(255) Not Null,
  Primary Key(`id`);
);

INSERT INTO test(`value`)
VALUES ('First'), ('Second'), ('Third');

SELECT * FROM test;
+----+--------+
| id | value  |
+----+--------+
|  1 | First  |
|  2 | Second |
|  3 | Third  |
+----+--------+

Please do not ask for help in a PM. Use the forums.
And use [code] tags!

•

Join Date: May 2009

Posts: 81

Reputation: tulipputih is an unknown quantity at this point

Solved Threads: 0

tulipputih tulipputih is offline

Offline

Junior Poster in Training

Re: customised the locked textboxes and save as new data

#16

Jun 18th, 2009

owh..thanks
I did used AUTO incerement.
tq.

•

Join Date: May 2009

Posts: 81

Reputation: tulipputih is an unknown quantity at this point

Solved Threads: 0

tulipputih tulipputih is offline

Offline

Junior Poster in Training

Re: customised the locked textboxes and save as new data

#17

Jul 3rd, 2009

HI adatapost,
I am sorry for coming to this thread again
several questions to ask:

•

$flag="disabled=\"disabled\"";

to enable the textboxes after click edit, can we code like this ?

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
   $unflag="enabled=\"enabled\"";
   $unflag="enabled=\"enabled\"";

I have tried this but it doesn't work.

when click the EDIT button, the value in textbox
remains..& can be editted.
currently the value is set to empty = $flag="";

thank you

•

Join Date: Oct 2008

Posts: 2,429

Reputation: adatapost has much to be proud of

Solved Threads: 437

adatapost

Offline

Nearly a Posting Maven

Re: customised the locked textboxes and save as new data

#18

Jul 3rd, 2009

Help with Code Tags

php Syntax (Toggle Plain Text)

$flag="";

Failure is not fatal, but failure to change might be. - John Wooden

•

Join Date: May 2007

Posts: 370

Reputation: Atli is an unknown quantity at this point

Solved Threads: 46

Atli

Offline

Posting Whiz

Re: customised the locked textboxes and save as new data

#19

Jul 4th, 2009

There is no enabled attribute. There is no need for it.
If the tag isn't specifically marked as disabled, it will be enabled.
So to enable it, simply remove the disabled attribute, as adatapost demonstrated.

Please do not ask for help in a PM. Use the forums.
And use [code] tags!

•

Join Date: May 2009

Posts: 81

Reputation: tulipputih is an unknown quantity at this point

Solved Threads: 0

tulipputih tulipputih is offline

Offline

Junior Poster in Training

Re: customised the locked textboxes and save as new data

#20

Jul 4th, 2009

•

If the tag isn't specifically marked as disabled, it will be enabled.
So to enable it, simply remove the disabled attribute, as adatapost demonstrated

ic, ok..thanks