Update help

  • Mr. Wiggles
  • Graduate
  • Graduate
  • Mr. Wiggles
  • Posts: 160
  • Loc: Brizzle

Post 3+ Months Ago

I'm trying to make an update apge. I know I'm ognna get a few errors and I'll need help. So heres the first on this certain aprt.
PHP Code: [ Select ]
 
<?php
 
   session_start();
 
  if ($auth !== "yes"){
 
     header("Location: <!-- m --><span class="postlink">http://animyst.gracious.me.uk/admin.php</span><!-- m -->");
 
     exit();
 
  }else{
 
      include ("update_main.inc.php");
 
      $connection = mysql_connect("localhost","","")  or die ("Couldn't connect to the server <br>");
 
      $db         = mysql_select_db("",$connection)    or die ("Couln't find database <br>");
 
      $query      = "SELECT * from users WHERE user='£logname'";
 
      $result     = mysql_query($query)                               or die ("Couldn't execute user query <br>");
 
         while ($row = mysql_fetch_array($result)){
 
                  extract($row);
 
                  echo "$user $email";}
 
  }  
 
?>
  1.  
  2. <?php
  3.  
  4.    session_start();
  5.  
  6.   if ($auth !== "yes"){
  7.  
  8.      header("Location: <!-- m --><span class="postlink">http://animyst.gracious.me.uk/admin.php</span><!-- m -->");
  9.  
  10.      exit();
  11.  
  12.   }else{
  13.  
  14.       include ("update_main.inc.php");
  15.  
  16.       $connection = mysql_connect("localhost","","")  or die ("Couldn't connect to the server <br>");
  17.  
  18.       $db         = mysql_select_db("",$connection)    or die ("Couln't find database <br>");
  19.  
  20.       $query      = "SELECT * from users WHERE user='£logname'";
  21.  
  22.       $result     = mysql_query($query)                               or die ("Couldn't execute user query <br>");
  23.  
  24.          while ($row = mysql_fetch_array($result)){
  25.  
  26.                   extract($row);
  27.  
  28.                   echo "$user $email";}
  29.  
  30.   }  
  31.  
  32. ?>

This should in theory echo the two variables. But obviously it isnt. The db connects fine. Its the displaying the variables that doesnt work. Anyone?
  • Scorpius
  • Proficient
  • Proficient
  • User avatar
  • Posts: 401
  • Loc: Scorpion Hole

Post 3+ Months Ago

Um I don't know if I'm just seeing things but should it be
PHP Code: [ Select ]
$logname

and not
PHP Code: [ Select ]
£logname

You should put something like this:
PHP Code: [ Select ]
if(mysql_num_rows($result) < 1) {
 
     echo "That user cannot be found";
 
} else {
 
     //show what you wanna show.
 
}
  1. if(mysql_num_rows($result) < 1) {
  2.  
  3.      echo "That user cannot be found";
  4.  
  5. } else {
  6.  
  7.      //show what you wanna show.
  8.  
  9. }
  • Mr. Wiggles
  • Graduate
  • Graduate
  • Mr. Wiggles
  • Posts: 160
  • Loc: Brizzle

Post 3+ Months Ago

Hehe, oopsy. I make that mistake alot.
OK. The main .php page can echo the variables. But when I try to echo those variables on an .inc.php page which I include, they show blank. Please help?
  • Mr. Wiggles
  • Graduate
  • Graduate
  • Mr. Wiggles
  • Posts: 160
  • Loc: Brizzle

Post 3+ Months Ago

help?!
  • Rabid Dog
  • Web Master
  • Web Master
  • User avatar
  • Posts: 3245
  • Loc: South Africa

Post 3+ Months Ago

I didn't see any assignment for the two variables, so I think this might solve it.

PHP Code: [ Select ]
 
while ($row = mysql_fetch_array($result)){
 
                        $user = $row['user'];
 
                        $email = $row['email'];
 
                        echo "$user $email";
 
}
 
 
  1.  
  2. while ($row = mysql_fetch_array($result)){
  3.  
  4.                         $user = $row['user'];
  5.  
  6.                         $email = $row['email'];
  7.  
  8.                         echo "$user $email";
  9.  
  10. }
  11.  
  12.  
  • Mr. Wiggles
  • Graduate
  • Graduate
  • Mr. Wiggles
  • Posts: 160
  • Loc: Brizzle

Post 3+ Months Ago

Sorted that out. includes have to be the last thing in the php.

OK. When users login their name a login DATETIME is added to the MySQL database. The time is wrong. Can i change the db itself so it is in GMT? I have access to phpMyAdmin. Or would I have to change the NOW() value?

Also, when users enter text into the update form. I want to to either be saved as it is, i.e. the return key strokes are logged or for it to be displayed that way. Any ideas?
  • Rabid Dog
  • Web Master
  • Web Master
  • User avatar
  • Posts: 3245
  • Loc: South Africa

Post 3+ Months Ago

As far as I know the NOW() function returns the time of the server that the DBMS is running on.

Maybe try using the PHP functions to deal with converting the time etc.
  • Mr. Wiggles
  • Graduate
  • Graduate
  • Mr. Wiggles
  • Posts: 160
  • Loc: Brizzle

Post 3+ Months Ago

I'll have to try and figure that out myself then. I wish I had a decent book to learn from at least. No suggesitons though please, I have no money at all.

Heres my update script, so far it isnt working, giving me an unexpected else on line 22. I don't think this will work anyway, the programming is shoddy.
PHP Code: [ Select ]
 
<?php
 
   session_start();
 
  if ($auth !== "yes"){
 
     header("Location: <!-- m --><span class="postlink">http://animyst.gracious.me.uk/admin.php</span><!-- m -->");
 
     exit();
 
  }else{
 
         $doAction    = (empty($_GET['do'])) ? "": $_GET['do'];
 
         $username    = (empty($_POST['post_main'])) ? "" : $_POST['post_main'];
 
      if ($doAction != "" && $doAction == "update") {
 
      $connection = mysql_connect("localhost","","")  or die ("Couldn't connect to the server <br>");
 
      $db         = mysql_select_db("animyst_parkour",$connection)    or die ("Couln't find database <br>");
 
      $query      = "SELECT * from users WHERE user='$logname'";
 
      $result     = mysql_query($query);
 
      $num        = mysql_num_rows($result);
 
     
 
         if ($num > 0) {
 
               while ($row = mysql_fetch_array($result)) {
 
               extract($row);
 
               $query = "INSERT INTO post_news (post_user,post_main,post_date,post_user_email) VALUES ('$user','$post_main',NOW(),'$email')";
 
          mysql_query($query)  or die("Couldn't execute insert query");
 
          header("Location: <!-- m --><span class="postlink">http://animyst.gracious.me.uk/update_confirm.php</span><!-- m -->");
 
         }else{
 
            echo "That user cannot be found";        
 
         }
 
         include ("update_main.inc.php");
 
         }
 
   include ("update_main.inc.php");
 
  }
 
   }     
 
?>
  1.  
  2. <?php
  3.  
  4.    session_start();
  5.  
  6.   if ($auth !== "yes"){
  7.  
  8.      header("Location: <!-- m --><span class="postlink">http://animyst.gracious.me.uk/admin.php</span><!-- m -->");
  9.  
  10.      exit();
  11.  
  12.   }else{
  13.  
  14.          $doAction    = (empty($_GET['do'])) ? "": $_GET['do'];
  15.  
  16.          $username    = (empty($_POST['post_main'])) ? "" : $_POST['post_main'];
  17.  
  18.       if ($doAction != "" && $doAction == "update") {
  19.  
  20.       $connection = mysql_connect("localhost","","")  or die ("Couldn't connect to the server <br>");
  21.  
  22.       $db         = mysql_select_db("animyst_parkour",$connection)    or die ("Couln't find database <br>");
  23.  
  24.       $query      = "SELECT * from users WHERE user='$logname'";
  25.  
  26.       $result     = mysql_query($query);
  27.  
  28.       $num        = mysql_num_rows($result);
  29.  
  30.      
  31.  
  32.          if ($num > 0) {
  33.  
  34.                while ($row = mysql_fetch_array($result)) {
  35.  
  36.                extract($row);
  37.  
  38.                $query = "INSERT INTO post_news (post_user,post_main,post_date,post_user_email) VALUES ('$user','$post_main',NOW(),'$email')";
  39.  
  40.           mysql_query($query)  or die("Couldn't execute insert query");
  41.  
  42.           header("Location: <!-- m --><span class="postlink">http://animyst.gracious.me.uk/update_confirm.php</span><!-- m -->");
  43.  
  44.          }else{
  45.  
  46.             echo "That user cannot be found";        
  47.  
  48.          }
  49.  
  50.          include ("update_main.inc.php");
  51.  
  52.          }
  53.  
  54.    include ("update_main.inc.php");
  55.  
  56.   }
  57.  
  58.    }     
  59.  
  60. ?>


This is the html i am using in the update_main.inc.php

PHP Code: [ Select ]
 
<form action="update.php?do=update" method=post>
 
<tr><td align=right><b>Post Main</b></td>
 
<td><input type="text" name="post_main" size="1000" maxsize="3000">
 
</td></tr>
 
<tr><td align="center" colspan="2">
 
<br><input type="submit" name="log" value="Enter"></td></tr>
 
</form>
  1.  
  2. <form action="update.php?do=update" method=post>
  3.  
  4. <tr><td align=right><b>Post Main</b></td>
  5.  
  6. <td><input type="text" name="post_main" size="1000" maxsize="3000">
  7.  
  8. </td></tr>
  9.  
  10. <tr><td align="center" colspan="2">
  11.  
  12. <br><input type="submit" name="log" value="Enter"></td></tr>
  13.  
  14. </form>
  • Rabid Dog
  • Web Master
  • Web Master
  • User avatar
  • Posts: 3245
  • Loc: South Africa

Post 3+ Months Ago

okay I don't know what you are including here but you forgot to close your while statement

PHP Code: [ Select ]
 
 session_start();
 
  if ($auth !== "yes"){
 
      header("Location: <!-- m --><span class="postlink">http://animyst.gracious.me.uk/admin.php</span><!-- m -->");
 
      exit();
 
  }else{
 
      $doAction    = (empty($_GET['do'])) ? "": $_GET['do'];
 
      $username    = (empty($_POST['post_main'])) ? "" : $_POST['post_main'];
 
      if ($doAction != "" && $doAction == "update") {
 
          $connection = mysql_connect("localhost","","")  or die ("Couldn't connect to the server <br>");
 
          $db         = mysql_select_db("animyst_parkour",$connection)    or die ("Couln't find database <br>");
 
          $query      = "SELECT * from users WHERE user='$logname'";
 
          $result     = mysql_query($query);
 
          $num        = mysql_num_rows($result);
 
          if ($num > 0) {
 
             while ($row = mysql_fetch_array($result)) {
 
                extract($row);
 
                $query = "INSERT INTO post_news (post_user,post_main,post_date,post_user_email) VALUES ('$user','$post_main',NOW(),'$email')";
 
                mysql_query($query)  or die("Couldn't execute insert query");
 
                header("Location: <!-- m --><span class="postlink">http://animyst.gracious.me.uk/update_confirm.php</span><!-- m -->");
 
           }
 
          }else{
 
            echo "That user cannot be found";            
 
          }
 
        //include ("update_main.inc.php");
 
      }
 
    include ("update_main.inc.php");
 
  }
 
 
  1.  
  2.  session_start();
  3.  
  4.   if ($auth !== "yes"){
  5.  
  6.       header("Location: <!-- m --><span class="postlink">http://animyst.gracious.me.uk/admin.php</span><!-- m -->");
  7.  
  8.       exit();
  9.  
  10.   }else{
  11.  
  12.       $doAction    = (empty($_GET['do'])) ? "": $_GET['do'];
  13.  
  14.       $username    = (empty($_POST['post_main'])) ? "" : $_POST['post_main'];
  15.  
  16.       if ($doAction != "" && $doAction == "update") {
  17.  
  18.           $connection = mysql_connect("localhost","","")  or die ("Couldn't connect to the server <br>");
  19.  
  20.           $db         = mysql_select_db("animyst_parkour",$connection)    or die ("Couln't find database <br>");
  21.  
  22.           $query      = "SELECT * from users WHERE user='$logname'";
  23.  
  24.           $result     = mysql_query($query);
  25.  
  26.           $num        = mysql_num_rows($result);
  27.  
  28.           if ($num > 0) {
  29.  
  30.              while ($row = mysql_fetch_array($result)) {
  31.  
  32.                 extract($row);
  33.  
  34.                 $query = "INSERT INTO post_news (post_user,post_main,post_date,post_user_email) VALUES ('$user','$post_main',NOW(),'$email')";
  35.  
  36.                 mysql_query($query)  or die("Couldn't execute insert query");
  37.  
  38.                 header("Location: <!-- m --><span class="postlink">http://animyst.gracious.me.uk/update_confirm.php</span><!-- m -->");
  39.  
  40.            }
  41.  
  42.           }else{
  43.  
  44.             echo "That user cannot be found";            
  45.  
  46.           }
  47.  
  48.         //include ("update_main.inc.php");
  49.  
  50.       }
  51.  
  52.     include ("update_main.inc.php");
  53.  
  54.   }
  55.  
  56.  
  • Mr. Wiggles
  • Graduate
  • Graduate
  • Mr. Wiggles
  • Posts: 160
  • Loc: Brizzle

Post 3+ Months Ago

The insert query isnt working now, any way to solve this?
  • Rabid Dog
  • Web Master
  • Web Master
  • User avatar
  • Posts: 3245
  • Loc: South Africa

Post 3+ Months Ago

What part isn't working?
  • Mr. Wiggles
  • Graduate
  • Graduate
  • Mr. Wiggles
  • Posts: 160
  • Loc: Brizzle

Post 3+ Months Ago

PHP Code: [ Select ]
 
<?php
 
   session_start();
 
  if ($auth !== "yes"){
 
     header("Location: <!-- m --><span class="postlink">http://animyst.gracious.me.uk/admin.php</span><!-- m -->");
 
     exit();
 
  }else{
 
         $post_main  = (empty($_POST['post_main'])) ? "" : $_POST['post_main'];
 
      $connection = mysql_connect("localhost","","")  or die ("Couldn't connect to the server <br>");
 
      $db         = mysql_select_db("animyst_parkour",$connection)    or die ("Couln't find database <br>");
 
      $query      = "SELECT * from users WHERE user='$logname'";
 
      $result     = mysql_query($query);
 
      $num        = mysql_num_rows($result);
 
     
 
      $doAction    = (empty($_GET['do'])) ? "": $_GET['do'];
 
         if ($doAction != "" && $doAction == "update") {
 
         
 
         if ($num > 0) {
 
         
 
               while ($row = mysql_fetch_array($result)) {
 
               extract($row);
 
               $query2 = "INSERT INTO post_news (post_user,post_main,post_date,post_user_email) VALUES ('$user','$post_main',NOW(),'$email')";
 
          mysql_query($query2)  or die("Couldn't execute insert query");
 
          header("Location: <!-- m --><span class="postlink">http://animyst.gracious.me.uk/update_confirm.php</span><!-- m -->");
 
          }
 
         
 
         }else{
 
         
 
            echo "That user cannot be found";
 
                       
 
         }
 
         
 
         include ("update_main.inc.php");
 
         }
 
   include ("update_main.inc.php");
 
  }  
 
?>
 
 
  1.  
  2. <?php
  3.  
  4.    session_start();
  5.  
  6.   if ($auth !== "yes"){
  7.  
  8.      header("Location: <!-- m --><span class="postlink">http://animyst.gracious.me.uk/admin.php</span><!-- m -->");
  9.  
  10.      exit();
  11.  
  12.   }else{
  13.  
  14.          $post_main  = (empty($_POST['post_main'])) ? "" : $_POST['post_main'];
  15.  
  16.       $connection = mysql_connect("localhost","","")  or die ("Couldn't connect to the server <br>");
  17.  
  18.       $db         = mysql_select_db("animyst_parkour",$connection)    or die ("Couln't find database <br>");
  19.  
  20.       $query      = "SELECT * from users WHERE user='$logname'";
  21.  
  22.       $result     = mysql_query($query);
  23.  
  24.       $num        = mysql_num_rows($result);
  25.  
  26.      
  27.  
  28.       $doAction    = (empty($_GET['do'])) ? "": $_GET['do'];
  29.  
  30.          if ($doAction != "" && $doAction == "update") {
  31.  
  32.          
  33.  
  34.          if ($num > 0) {
  35.  
  36.          
  37.  
  38.                while ($row = mysql_fetch_array($result)) {
  39.  
  40.                extract($row);
  41.  
  42.                $query2 = "INSERT INTO post_news (post_user,post_main,post_date,post_user_email) VALUES ('$user','$post_main',NOW(),'$email')";
  43.  
  44.           mysql_query($query2)  or die("Couldn't execute insert query");
  45.  
  46.           header("Location: <!-- m --><span class="postlink">http://animyst.gracious.me.uk/update_confirm.php</span><!-- m -->");
  47.  
  48.           }
  49.  
  50.          
  51.  
  52.          }else{
  53.  
  54.          
  55.  
  56.             echo "That user cannot be found";
  57.  
  58.                        
  59.  
  60.          }
  61.  
  62.          
  63.  
  64.          include ("update_main.inc.php");
  65.  
  66.          }
  67.  
  68.    include ("update_main.inc.php");
  69.  
  70.   }  
  71.  
  72. ?>
  73.  
  74.  


Thi is the main php

The submit form is pretty much the same. The form can't insert the things into the db. The post_news table structure is like this.
Field Type Null Default
post_user varchar(20) No
post_main text No
post_date datetime No 0000-00-00 00:00:00
post_user_email varchar(40) No
  • Mr. Wiggles
  • Graduate
  • Graduate
  • Mr. Wiggles
  • Posts: 160
  • Loc: Brizzle

Post 3+ Months Ago

The php doesn't normally look like that, but today it's decided to.
  • Mr. Wiggles
  • Graduate
  • Graduate
  • Mr. Wiggles
  • Posts: 160
  • Loc: Brizzle

Post 3+ Months Ago

Help!

Post Information

  • Total Posts in this topic: 14 posts
  • Users browsing this forum: No registered users and 43 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.