updating error

bamfon · January 21, 2011

well here my page i tryed and tryed to get it working but it shows the data but it dont update it

[code=php:0]<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head><?php include "../config.php";

$id = $_GET['id'];
$con = database_connect();
$sql = "SELECT * FROM anime1 WHERE animeid ='$id'";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)) {

$title = $row['title'];
$type = $row['type'];
$episode = $row['episode'];
$year = $row['year'];
$genre = $row['genre'];
$status = $row['status'];
$summary = $row['summary'];
$pictures = $row['pictures'];


}mysql_query($sql) or exit(mysql_error());
mysql_close($con);
?>

<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript"> 
$(document).ready(function(){
$(".flip").click(function(){
    $(".panel").slideToggle("slow");
  });
});

</script>

<style type="text/css"> 

</style>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Transdmin Light</title>

<!-- CSS -->
<link href="style/css/transdmin.css" rel="stylesheet" type="text/css" media="screen" />
<!--[if IE 6]><link rel="stylesheet" type="text/css" media="screen" href="style/css/ie6.css" /><![endif]-->
<!--[if IE 7]><link rel="stylesheet" type="text/css" media="screen" href="style/css/ie7.css" /><![endif]-->

<!-- JavaScripts-->
<script type="text/javascript" src="style/js/jquery.js"></script>
<script type="text/javascript" src="style/js/jNice.js"></script>
</head>

<body>
<div id="wrapper">
    	<!-- h1 tag stays for the logo, you can use the a tag for linking the index page -->
    	<h1><a href="#"><span>Transdmin Light</span></a></h1>
        
        <!-- You can name the links with lowercase, they will be transformed to uppercase by CSS, we prefered to name them with uppercase to have the same effect with disabled stylesheet -->
        <ul id="mainNav">
        	<li><a href="#">DASHBOARD</a></li> 
        	<!-- Use the "active" class for the active menu item  -->
        	<li><a href="./anime.php" class="active">Anime</a></li>
        	<li><a href="#">DESIGN</a></li>
        	<li><a href="#">OPTION</a></li>
        	<li class="logout"><a href="#">LOGOUT</a></li>
        </ul>
        <!-- // #end mainNav -->
        
        <div id="containerHolder">
          <div id="container">
            <div id="sidebar">
              <ul class="sideNav">
                <li><?php echo $lbox1 ?></li>
                <li><?php echo $lbox2 ?></li>
                <li><?php echo $lbox3 ?></li>
                <li><?php echo $lbox4 ?></li>
                <li> <?php echo $lbox5 ?></li>
                <li><?php echo $lbox6 ?></li>
              </ul>
              <!-- // .sideNav -->
            </div>
            <!-- // #sidebar -->
            <!-- h2 stays for breadcrumbs -->
            <h2><a href="#">Anime</a> » edit » <?php echo "$title"; ?></h2>
            <div id="main">
              <form action="<?php echo $_SERVER['PHP_SELF']."?id=$id" ; ?>" method="post" class="jNice">
            <h3>Editing <?php echo "$title"; ?>, when finished click submit</h3>
              <fieldset>
                <p>
                  <label>Series Title -- (Put the Title of the Series you are adding into here)</label>
                  <input name="title" type="text" class="text-long" id="title" value="<?php echo $title ?>" />
                  </p>
                  <p>
                    <label>Type -- (Put what type of anime is it?)</label>
                    <select name="type" id="type">
                      <option selected="selected">Select one</option>
                      <option>TV Series</option>
                      <option>OVA</option>
                      <option>TV Special</option>
                      <option>Movie</option>
                      <option>Web</option>
                      <option>DVD Special</option>
                      <option>Other</option>
                    </select>
                  </p>
                <p>
                  <label>Episodes -- (How many Episode are there?)</label>
                  <input name="episode" type="text" class="text-long" id="episode" value="<?php echo $episode ?>" />
                  </p>
                <p>
                  <label>Year -- (What year was the anime release in?)</label>
                  <input name="year" type="text"  class="text-long" id="year" value="<?php echo $year ?>"  />
                  </p>
                <p>
                  <label>genre <a href="./genre">(click this for the list and FAQ for adding in genre)</a></label>
                  <input name="genre" type="text"  class="text-long" id="genre" value="<?php echo $genre ?>"  />
                  </p>
                  <p>
                    <label>status -- (What Is the status of the anime, Completed, Ongoing or Stalled)</label>
                    <select name="status" id="status">
                      <option selected="selected">Select one</option>
                      <option>Complete</option>
                      <option>Ongoing</option>
                      <option>Stalled</option>
                    </select>
                  </p>
                  <p>
                    <label>Summary -- (Put in the Summary for the anime)</label>
                    <textarea name="summary" cols="1" rows="1" id="summary"><?php echo $summary
?></textarea>
                  </p>
                <p>
                  <label>Pictures -- (link to the Anime Pictures you upladed)</label>
                  <input name="pictures" type="text" class="text-long" id="pictures" value="<?php echo $pictures ?>" />
                  </p>
                  <?php
			  $con = database_connect();
			  $sql="UPDATE anime1 
SET title='$title', type='$type', episode='$episode', year='$year', genre='$genre', status='$status', summary='$summary', pictures='$pictures' WHERE animeid = '$id'";


$con = database_connect();
$title = $_POST['title'];
$type = $_POST['type'];
$episode = $_POST['episode'];
$year = $_POST['year'];
$genre = $_POST['genre'];
$status = $_POST['status'];
$summary = $_POST['summary'];
$pictures = $_POST['pictures'];
$title = mysql_real_escape_string($title);
$type = mysql_real_escape_string($type);
$episode = mysql_real_escape_string($episode);
$year = mysql_real_escape_string($year);
$genre = mysql_real_escape_string($genre);
$status = mysql_real_escape_string($status);
$summary = mysql_real_escape_string($summary);
$pictures = mysql_real_escape_string($pictures);
error_reporting(-1);

if (!mysql_query($sql,$con))
  {
  die('Error adding anime database: ' . mysql_error());
  }





?>	
                  <h3> </h3>
                  
              <?php

$con = database_connect();
$sql1 = "SELECT * FROM episodea WHERE animeid = '$id'
UNION ALL
SELECT * FROM episodeb WHERE animeid = '$id'";
$result1 = mysql_query($sql1);
while ($row = mysql_fetch_assoc($result1)) {
$ep = $row['ep'];
$epname = $row['epname'];
$animeid = $row['animeid'];
$video = $row['video'];
$video2 = $row['video2'];
$video3 = $row['video3'];

mysql_query($sql) or exit(mysql_error());






              echo "    <div class=\"panel\">\n";
echo "<p>\n";
echo "                    	    <label>Episodes -- (When this box says Anime episode finished, you have added in all the episodes)</label>\n";
echo "                    	    <input name=\"ep\" type=\"text\" class=\"text-long\" id=\"ep\" value=\" $ep\" readonly=\"readonly\" />\n";
echo "                  	    </p>\n";
echo "                    	  <p>\n";
echo "                    	    <label>Episodes Name-- (What is the name of the episode you are adding? --- If the episodes has no name enter episode number)</label>\n";
echo "                    	    <input name=\"epname\" type=\"text\" class=\"text-long\" id=\"epname\" value=\" $epname\" />\n";
echo "                  	    </p>\n";
echo "                    	  <p>\n";
echo "                    	    <label>Viewable -- (Is the episode your are adding in SUBBED or DUBBED or RAW?)</label>\n";
echo "                            <select name=\"viewable\" id=\"viewable\">\n";
echo "                            <option selected=\"selected\">Select one</option>\n";
echo "                            	<option>SUBBED</option>\n";
echo "                            	<option>DUBBED</option>\n";
echo "                            	<option>RAW</option>\n";
echo "                            </select>\n";
echo "                           </p>\n";
echo "                    	  <p>\n";
echo "                       	    <label>Video 1 -- (enter the embed code for the episode you are adding in)</label>\n";
echo "                   	      <textarea name=\"video\" cols=\"1\" rows=\"1\" id=\"video\"> $video</textarea></p>\n";
echo "                       	  <p>\n";
echo "                       	    <label>Video 2 -- ( If you have a 2ed embed code </label>\n";
echo "                       	    <textarea name=\"video1\" cols=\"1\" rows=\"1\" id=\"video1\"> $video2</textarea>\n";
echo "                   	      </p>\n";
echo "                       	  <p>\n";
echo "                       	    <label>Video 3 --( If you have a 3ed embed code </label>\n";
echo "                       	    <textarea name=\"video4\" cols=\"1\" rows=\"1\" id=\"video4\"> $video3</textarea>\n";
echo "<h3>\n";
echo "<a href=\"#submit\">IF you finished editing ep, click me to go to submit button</a></h3>\n";
echo "                   	      </p>\n";
echo "</div>\n";
echo " \n";
echo "	<br />";
echo "<br />";
echo "<p class=\"flip\">Click here to edit all Episodes For $title </p>\n";

echo "	<br />";
echo "<br />";
  
			   }
  ?>
			  <h3>
                    
                    
            remember to click submit before changing the page</h3>
                  <h3> </h3>
                  <h3>
                    <a name="submit" id="submit"></a>
                    <input type="submit" value="Submit Query" />
                  </h3>
                </fieldset>
              </form>
            </div>
            <!-- // #main -->
            <div class="clear"></div>
          </div>
          <!-- // #container -->
      </div>	
        <!-- // #containerHolder -->
        
        <p id="footer">Feel free to use and customize it. <a href="http://www.perspectived.com">Credit is appreciated.</a></p>
    </div>
    <!-- // #wrapper -->
</body>
</html>

[/code]

Maq · January 21, 2011

What does it do?

What have you done to debug it?

Are there any errors?

Because this is useless:

well here my page i tryed and tryed to get it working but it shows the data but it dont update it

bamfon · January 21, 2011

Well it 1st get the date from the db and puts it in to text box for editing

when you finished editing your press submit to reupload it back in to the db.

there no error

i checked all the sql coding in phpmyaddmin and they all worked in there :S

jcbones · January 21, 2011

Yes, but you make your variables AFTER you build your sql string. So, the sql string has no Idea what the variables are. You must move your sql string BELOW your variable instantiation.

bamfon · January 21, 2011

lol thanks just saw it its working now

Maq · January 21, 2011

lol thanks just saw it its working now

Good (I missed it too ;/ )

Sign In

updating error

Recommended Posts

bamfon

Link to comment

Share on other sites

Maq

Link to comment

Share on other sites

bamfon

Link to comment

Share on other sites

jcbones

Link to comment

Share on other sites

bamfon

Link to comment

Share on other sites

Maq

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information