Ad:

PHP Discussion Thread
Unsolved
Views: 1770

You are currently viewing page 2 of this multi-page discussion thread; Jump to the first page

Jun 13th, 2009

Re: customised the locked textboxes and save as new data

Click to Expand / Collapse Quote originally posted by tulipputih ...

ok..thanks.this is my code
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

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>

adatapost

Moderator

Reputation Points: 2136

Solved Threads: 1228

Posting Genius

Offline

6,527 posts
since Oct 2008

Permalink

Jun 15th, 2009

Re: customised the locked textboxes and save as new data

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

tulipputih

Reputation Points: 10

Solved Threads: 0

Junior Poster

Offline

107 posts
since May 2009

Permalink

Jun 15th, 2009

Re: customised the locked textboxes and save as new data

Click to Expand / Collapse Quote 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.

adatapost

Moderator

Reputation Points: 2136

Solved Threads: 1228

Posting Genius

Offline

6,527 posts
since Oct 2008

Permalink

Jun 17th, 2009

Re: customised the locked textboxes and save as new data

hello all,
thanks for your input

Quote ...

& 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

tulipputih

Reputation Points: 10

Solved Threads: 0

Junior Poster

Offline

107 posts
since May 2009

Permalink

Jun 17th, 2009

Re: customised the locked textboxes and save as new data

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

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  |
+----+--------+

Atli

Reputation Points: 93

Solved Threads: 70

Posting Pro

Offline

526 posts
since May 2007

Permalink

Jun 18th, 2009

Re: customised the locked textboxes and save as new data

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

tulipputih

Reputation Points: 10

Solved Threads: 0

Junior Poster

Offline

107 posts
since May 2009

Permalink

Jul 3rd, 2009

Re: customised the locked textboxes and save as new data

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

Quote ...

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

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

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

tulipputih

Reputation Points: 10

Solved Threads: 0

Junior Poster

Offline

107 posts
since May 2009

Permalink

Jul 3rd, 2009

Re: customised the locked textboxes and save as new data

php Syntax (Toggle Plain Text)

$flag="";

adatapost

Moderator

Reputation Points: 2136

Solved Threads: 1228

Posting Genius

Offline

6,527 posts
since Oct 2008

Permalink

Jul 4th, 2009

Re: customised the locked textboxes and save as new data

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.

Atli

Reputation Points: 93

Solved Threads: 70

Posting Pro

Offline

526 posts
since May 2007

Permalink

Jul 4th, 2009

Re: customised the locked textboxes and save as new data

Quote ...

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

but I would like to retain the value that is currently displayed.
by using this

php Syntax (Toggle Plain Text)

 $flag="";

the textbox is enable..it's correct..but the value inside is emptied.

thank you

tulipputih

Reputation Points: 10

Solved Threads: 0

Junior Poster

Offline

107 posts
since May 2009

Previous
1
Page 2
3
Next

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Warning: session_start() [function.session-start]: Cannot send session cache limiter

Next Thread in PHP Forum Timeline: auction script

DaniWeb Message

Cancel Changes

User Name
Password