Page 3 - Edit problem

Dev Shed Forums Sponsor:

#31

August 14th, 2008, 12:21 PM

jadi

Contributing User

Join Date: Aug 2008

Location: New Jersey, USA

Posts: 190

Time spent in forums: 1 Day 7 h 24 m 28 sec
Reputation Power: 4

I even tried this but now it is not displaying even the id??????????????????

PHP Code:


		
			
<?php

$connection = mysql_connect("localhost", "root", "") or die("Cannot connect to MySQL server: " . mysql_error());

$db_selected = mysql_select_db('tmetrix', $connection);



$id=$_GET['id'];

echo "$id";





$sql="SELECT * FROM comments WHERE c_id='$id'";

$result=mysql_query($sql);



$rows=mysql_fetch_array($result);



echo "<tr><td style='color: #666666;text-align:left;font-size:small;font-family:Tahoma'>" .$row['name'] . "</td> "; 

echo "<td style='color: #666666;text-align:left;font-size:small;font-family:Tahoma'>" .$row['CELLID'] . "</td> "; 

echo "<td style='color: #666666;text-align:left;font-size:small;font-family:Tahoma'>" .$row['problem'] . "</td> "; 

echo "<td style='color: #666666;text-align:left;font-size:small;font-family:Tahoma'>" .$row['solution'] . "</td> "; 

echo "<td style='color: #666666;text-align:left;font-size:small;font-family:Tahoma'>" .$row['comments'] . "</td>"; 

echo "<td style='color: #666666;text-align:left;font-size:small;font-family:Tahoma'>" .$row['rf'] . "</td></tr>"; 







?>

#32

August 14th, 2008, 12:23 PM

jadi

Contributing User

Join Date: Aug 2008

Location: New Jersey, USA

Posts: 190

Time spent in forums: 1 Day 7 h 24 m 28 sec
Reputation Power: 4

hey ur code worked

It gave me the output :
Array
(
[c_id] => 125
[problem] => Misc - Hardware related
[solution] => Being Monitered.......
[comments] => ON THE 6PM REPORT TECH FOUND THREE RADIOS LOCKED WILL MONITOR
[username] => pamato
[date] => 2008-08-14
[rf] => no
)

#33

August 14th, 2008, 12:24 PM

jsampsonPC

stick a scissor in you eye

Dev Shed Intermediate (1500 - 1999 posts)

Join Date: Jun 2004

Location: Pensacola, Florida

Posts: 1,572

Time spent in forums: 1 Week 6 Days 15 h 37 m 59 sec
Reputation Power: 434

What does the link look like that opens that page? Are you positive you're sending the value across still?

__________________
FREE Web Development Videos | PHP Reference | MySQL Reference | jQuery Documentation

Markup Validation | CSS Validation | Web Developers, get FireBug & IE Developer Toolbar

When seeking help:
Submit clear questions and code. Use syntax highlighting.
Be patient, and respectful. Don't abuse your access to
professional guidance - nobody here is obligated to answer
your questions, be thankful that they do.

Are you a good person?

#34

August 14th, 2008, 12:25 PM

jsampsonPC

stick a scissor in you eye

Join Date: Jun 2004

Location: Pensacola, Florida

Posts: 1,572

Time spent in forums: 1 Week 6 Days 15 h 37 m 59 sec
Reputation Power: 434

Quote:

Originally Posted by jadi

Bah, you're confusing me now! One minute it doesn't work, and the next it does - make up your mind!

Haha. Okay, so tell me when you're ready to continue.

#35

August 14th, 2008, 12:26 PM

jadi

Contributing User

Join Date: Aug 2008

Location: New Jersey, USA

Posts: 190

Time spent in forums: 1 Day 7 h 24 m 28 sec
Reputation Power: 4

I am ready now..............!!

#36

August 14th, 2008, 12:27 PM

jsampsonPC

stick a scissor in you eye

Join Date: Jun 2004

Location: Pensacola, Florida

Posts: 1,572

Time spent in forums: 1 Week 6 Days 15 h 37 m 59 sec
Reputation Power: 434

Alright, so of the information that we successfully extracted from the db, what do you want to allow them to edit in the form?

#37

August 14th, 2008, 12:30 PM

jadi

Contributing User

Join Date: Aug 2008

Location: New Jersey, USA

Posts: 190

Time spent in forums: 1 Day 7 h 24 m 28 sec
Reputation Power: 4

Well, they definitely cannot edit C_id , date & CELLID

They can only edit Problem, Solution, Comments & RF

Comments can be reposted in the textbox but Problem and Solution is just the same drop downs but just displayed with the selected value of the one they are trying to edit.

#38

August 14th, 2008, 12:47 PM

jsampsonPC

stick a scissor in you eye

Join Date: Jun 2004

Location: Pensacola, Florida

Posts: 1,572

Time spent in forums: 1 Week 6 Days 15 h 37 m 59 sec
Reputation Power: 434

Alright, so let's build our form - once you have this done, we'll setup the auto-select for the dropdown, and the checkbox. You can also design your form here too the way you want it:

php Code:

Original - php Code

# Note, we should watch these values closely!
$commentid = $_GET["c_id"];
$comment = getComment($commentid);
 
$form = "<form method='post'>
           <p><input type='text' name='comment' value='{$comment["comments"]}' /></p>
           <p>
             <select name='problem'>
               ...put your options here...
             </select>
           </p>
           <p>
             <input type='checkbox' name='rf' />
           </p>
           <p>
             <input type='hidden' name='cid' value='{$commentid}' />
             <input type='submit' name='update' value='Update' />
           </p>
         </form>";
 
print $form;
 
function getComment($commentid) {
  $comment = array();
  $sql = "SELECT id, problem, solution, comments, username, date, rf 
          FROM comments 
          WHERE id = {$commentid}";
  $rst = mysql_query($sql) or die(mysql_error());
  if (mysql_num_rows($rst) > 0) {
    $comment = mysql_fetch_assoc($rst);
  }
  return $comment;
}

Last edited by jsampsonPC : August 14th, 2008 at 12:50 PM.

#39

August 14th, 2008, 12:58 PM

jadi

Contributing User

Join Date: Aug 2008

Location: New Jersey, USA

Posts: 190

Time spent in forums: 1 Day 7 h 24 m 28 sec
Reputation Power: 4

it gets the comments into the text box.
A drop down and a radio button:

TO GET THE VALUES INTO THE DROP DOWN I TRIED:

PHP Code:


		
			
<?php

$connection = mysql_connect("localhost", "root", "") or die("Cannot connect to MySQL server: " . mysql_error());

$db_selected = mysql_select_db('tmetrix', $connection);





$commentid = $_GET["c_id"];

$comment = getComment($commentid);



$form = "<form method='post'>

           <p><input type='text' name='comment' value='{$comment["comments"]}' /></p>

           <p>

          <select name="problem">

                  <option selected="selected" value=\"$comment[problem]\">$comment[problem]</option>

                  <option>High ICM specefic TRX</option>

                  <option>High ICM entire sector</option>

                  <option>Misc RF </option>

                <option>Misc - T1 / PCM </option>

                  <option>Misc - Hardware related</option>

                  <option>Misc - Sudden losses (BTS reset)</option>

                  <option>Misc - Sudden losses RF (Tunnels, IB, Terrain)</option>

                  <option>RF - SS DL specefic TRX</option>

                  <option>RF - SS DL entire sector</option>

                  <option>RF - SS UL specefic TRX </option>

                  <option>RF - SS UL entire sector </option>

                  <option>RF - SS BL coverage change </option>

                  <option>RF - QA DL specefic TRX</option>

                  <option>RF - QA DL entire sector </option>

                  <option>RF - QA UL specefic TRX</option>

                  <option>RF - QA UL entire sector </option>

                  <option>RF - QA BL specefic TRX</option>

                  <option>RF - QA BL entire sector</option>

                </select>















                      </p>

           <p>

             <input type='checkbox' name='rf' />

           </p>

         </form>";



print $form;



function getComment($commentid) {

  $comment = array();

  $sql = "SELECT c_id, problem, solution, comments, username, date, rf 

          FROM comments 

          WHERE c_id = {$commentid}";

  $rst = mysql_query($sql) or die(mysql_error());

  if (mysql_num_rows($rst) > 0) {

    $comment = mysql_fetch_assoc($rst);

  }

  return $comment;

}



?>

iT IS SAYING ERROR ON LINE 12

Parse error: syntax error, unexpected T_STRING in C:\WAMP\www\tmetrix\edit.php on line 12

#40

August 14th, 2008, 01:03 PM

jsampsonPC

stick a scissor in you eye

Join Date: Jun 2004

Location: Pensacola, Florida

Posts: 1,572

Time spent in forums: 1 Week 6 Days 15 h 37 m 59 sec
Reputation Power: 434

Yeah; the error is from not escaping your double-quotes. But that isn't how you want to do the drop down selection anyway. Work on your drop-down until you have it working like the example in the code below. Each option in your <select> should look like this.

php Code:

Original - php Code
print "<option value='Problem Text' ".(("Problem Text" == $comment["problem"]) ? "selected" : "").">{$comment["problem"]}</option>";

print "<option value='Problem Text' ".(("Problem Text" == $comment["problem"]) ? "selected" : "").">{$comment["problem"]}</option>";

Last edited by jsampsonPC : August 14th, 2008 at 01:05 PM.

#41

August 14th, 2008, 01:06 PM

jadi

Contributing User

Join Date: Aug 2008

Location: New Jersey, USA

Posts: 190

Time spent in forums: 1 Day 7 h 24 m 28 sec
Reputation Power: 4

i got it by changing " to '

#42

August 14th, 2008, 01:07 PM

jadi

Contributing User

Join Date: Aug 2008

Location: New Jersey, USA

Posts: 190

Time spent in forums: 1 Day 7 h 24 m 28 sec
Reputation Power: 4

I did it for both the drop down but how can we do the radio button?

#43

August 14th, 2008, 01:08 PM

jsampsonPC

stick a scissor in you eye

Join Date: Jun 2004

Location: Pensacola, Florida

Posts: 1,572

Time spent in forums: 1 Week 6 Days 15 h 37 m 59 sec
Reputation Power: 434

Your checkbox will be similar:

php Code:

Original - php Code
print "<input type='checkbox' name='rf' ".(($comment["rf"] != "no") ? "checked" : )." />";

print "<input type='checkbox' name='rf' ".(($comment["rf"] != "no") ? "checked" : )." />";

#44

August 14th, 2008, 01:09 PM

jsampsonPC

stick a scissor in you eye

Join Date: Jun 2004

Location: Pensacola, Florida

Posts: 1,572

Time spent in forums: 1 Week 6 Days 15 h 37 m 59 sec
Reputation Power: 434

Quote:

Originally Posted by jadi

i got it by changing " to '

You should go back and do it the way I suggested. Don't get in the habbit of finding fixes when you need to be using solutions :P With your way you will have the same value in your dropdown twice, and that isn't what you want.

#45

August 14th, 2008, 01:17 PM

jadi

Contributing User

Join Date: Aug 2008

Location: New Jersey, USA

Posts: 190

Time spent in forums: 1 Day 7 h 24 m 28 sec
Reputation Power: 4

Say if we make the radio button to dropdown with yes and no then I have a problem:

In the above drop downs, i am displaying all my options with the repeat of the chosen one.

But in yes or no i cant have 2 yes and 1 no or viseversa.

How can we solve this problem of reduenducy?

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: