Page 2 - Edit problem

Dev Shed Forums Sponsor:

#16

August 14th, 2008, 10:24 AM

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

Ahhh I feel so embarrassing to say "NO"!!

#17

August 14th, 2008, 10:30 AM

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

the comments table is very imp. Can I alter it now by adding a column id, autoincrement????
Will it affect data in there? Coz once I had scred the whole db and I was in trouble.
I dont want to do it again!!

Should i add one column of id and one column of update(link to update.php passing the row id)?????????????

#18

August 14th, 2008, 10:46 AM

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

You do need an auto-incrementing unique identifier in your comment table, yes. We need to have a way to reference each comment fast and easy.

__________________
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?

#19

August 14th, 2008, 11:05 AM

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

Ok i added the c_id with autoincrement .

So now all the comments has an id

#20

August 14th, 2008, 11:08 AM

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

Excellent. Did you want to leave the problems as text, or did you want to build a problems table, and build a relationship there by placing the problem id in the comments table as an integer?

#21

August 14th, 2008, 11:12 AM

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

there are not much options in there so would it be ok to leave it as it is???
Coz I will have to change many pages that are related to it.

Well for now we can try without making problem table. Later I will copy the whole db and try again.

#22

August 14th, 2008, 11:13 AM

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 also did this :
It has an edit button which takes you to the edit.php page.

Do I need to add anything to pass values?

PHP Code:


		
			
<?php





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

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







//   $mth = $_POST['month'];

//   $dt = $_POST['date'];    

//   $yr = $_POST['year'];



//  $whole1="$yr-$mth-$dt";

$whole1=DATE('Y-m-d');



//echo "$whole1";



$data = mysql_query("SELECT * FROM users JOIN comments ON users.username = comments.username where date = '$whole1'");





//$data = mysql_query("SELECT * FROM comments where date = '$whole1'"); 

Print "<table border=2 cellspacing=2 align=center bordercolor=#FFffff cellpadding=10 width=100% style='bordercolor:#CC0066;font-family:Tahoma;text-align:center;color:#CC0066'>"; 









$num_data = mysql_num_rows($data); 

echo "<tr><td bgcolor='#CCCCCC' style='width:60.75pt;text-align:left;font-size:small;font-family:Tahoma;font-weight:bold;padding:0in 0in 0in 0in'>USER NAME</td>";

//echo "<td bgcolor='#CCCCCC' style='width:60.75pt;text-align:left;font-size:small;font-family:Tahoma;font-weight:bold;padding:0in 0in 0in 0in'>TEST</td> "; 



echo "<td bgcolor='#CCCCCC' style='width:60.75pt;text-align:left;font-size:small;font-family:Tahoma;font-weight:bold;padding:0in 0in 0in 0in'>CELLID</td> "; 

echo "<td bgcolor='#CCCCCC'  style='width:60.75pt;text-align:left;font-size:small;font-family:Tahoma;font-weight:bold;padding:0in 0in 0in 0in'>PROBLEM</td> "; 

echo "<td bgcolor='#CCCCCC'  style='width:60.75pt;text-align:left;font-size:small;font-family:Tahoma;font-weight:bold;padding:0in 0in 0in 0in'>SOLUTION</td> "; 

echo "<td bgcolor='#CCCCCC' style='width:60.75pt;text-align:left;font-size:small;font-family:Tahoma;font-weight:bold;padding:0in 0in 0in 0in'>COMMENTS</td>";

echo "<td bgcolor='#CCCCCC' style='width:60.75pt;text-align:left;font-size:small;font-family:Tahoma;font-weight:bold;padding:0in 0in 0in 0in'>RF Assistance Needed?</td>";

echo "<td bgcolor='#CCCCCC' style='width:60.75pt;text-align:left;font-size:small;font-family:Tahoma;font-weight:bold;padding:0in 0in 0in 0in'>EDIT</td><tr>";







for ($i=0; $i <$num_data; $i++) 

{





$row = mysql_fetch_array($data); 



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

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>"; 

echo "<td>

          <form action=edit.php method=POST>

                   <input type=submit name=\"queryButton\" value=\"Edit\">

         </form></td></tr>";



}







?>

#23

August 14th, 2008, 11:29 AM

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

Having the edit button is good. Go ahead and append the variable to the end of the action value of the form.

Code:

<form method="post" action="edit.php?id={$commentid}">
  <p><input type="submit" name="edit" value="Edit" /></p>
</form>

On a side note, remember to always puts quotes around your values

#24

August 14th, 2008, 11:48 AM

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

Ahh, I did that already.....

Now lets move on to edit.php page

where to start? What do i do next?

#25

August 14th, 2008, 11:50 AM

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 on edit.php are you able to print the comment id from the $_GET array?

php Code:

Original - php Code
<?php print $_GET["id"]; ?>

<?php
 
  print $_GET["id"];
 
?>

#26

August 14th, 2008, 11:58 AM

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

Yup, it prints the id .

PHP Code:


		
			
<?php



  print $_GET["c_id"];







?>

#27

August 14th, 2008, 12:02 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

Now, I have this small window via which they had previously entered the data.
We can use that, but only thing that we have to do is to just have the values of dropdown, text, radio button, DISPLAYED apart form the other values.

I will post the code of that small window.

PHP Code:


		
			
<?php

session_start();

if(!isset($_SESSION['loggedin'])) {

// If the session 'loggedin' is NOT set forward the user back to the login form with the error set

header('Location: login.php');

exit(); // Otherwise show the rest of the page (admin section)

}

?>



              

              <?php  

              

 

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

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



$dt= DATE('Y-m-d');

//$user = $_SESSION['username'];



$user = $_COOKIE['Joe2Torials']['username'];



$query ="select CELLID from drops where date = '$dt' order by CELLID"; 

   

    

$result=mysql_query($query);



// start the select box

echo "<select name='CELLID'>\n";

while($row=mysql_fetch_assoc($result)){

  echo "<option value=\"$row[CELLID]\">$row[CELLID]</option>\n";

}

echo "</select>";  ?>

              </label></td>

            </tr>

            <tr>

              <td bgcolor="#999999" class="style6">Performance TroubleShooting:</td>

<td><label>

                <select name="problem" id="problem" tabindex="2">

                  <option selected="selected" value="">------------------Select--------------</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>

              </label></td>

            </tr>

            <tr>

              <td bgcolor="#999999"><span class="style6">Actual Resolution:</span></td>

              <td><label>

              <select name="solution" id="solution" tabindex="3">

                <option selected="selected" value="">------------------Select------------------</option>

                <option>Being Monitered.......</option>

        <option>High ICM TRX replaced</option>

                <option>High ICM Frequency problems refered to RF</option>

                <option>T1 TT out to Telco</option>

                <option>Reset Site</option>

                <option>Sudden Losses refered to RF</option>

                <option>TRX / PA / CCI</option>

                <option>TMA</option>

                <option>New Site OTA</option>

                <option>Azimuth / Tilt change on sector</option>

              </select>

              </label></td>

            </tr>

          </table>

        <p>

            <label><span class="style7">Please Enter Additional Comments Here:

            </span>

            <textarea name="comments" cols="60" rows="5" id="comments" tabindex="3"></textarea>

          </label>

        </p>

<p> 

  <label>

   <span class="style7">Need RF Assistance? : </span>

   <input type="radio" name="rfass" value="yes" id="yes" />

    YES</label>

  

  <label>

  <input name="rfass" type="radio" id="no" value="no" checked="checked" />

    NO</label>

  <br />

</p>

 

        <p>

          <label><form>

          <input type="submit" class="formbutton" name="Submit" id="Submit" value="Submit Comments" tabindex="4" />

        </label>

      </form></td>

  </tr>

</table>

</body>

</html>

#28

August 14th, 2008, 12:04 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

Cool! So let's write a function now that will get our comment information - what happens if you run this, does it output the comment details to the screen?

php Code:

Original - php Code

# Note, we should watch these values closely!
$commentid = $_GET["c_id"];
$comment = getComment($commentid);
 
print "<pre>";
print_r($comment);
print "</pre>";
 
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;
}

#29

August 14th, 2008, 12:11 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 this but it is printing :
0) { $comment = mysql_fetch_assoc($rst); } return $comment; } ?>

But there is no error???? I dont know y?

PHP Code:


		
			
<?

$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);



print "<pre>";

print_r($comment);

print "</pre>";



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;

}



?>

#30

August 14th, 2008, 12:15 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

Start your page with <?php instead of <?
Also, this is a .php file, right?

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: