Advanced Search

Results 1 to 2 of 2

Thread: Mixed results with javascript.

  1. #1
    Join Date
    Apr 2009
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Mixed results with javascript.

    Hi, this php site is for an admin to add, delete and update events now for this one, it can only delete but can not perform the update_data1() and save_data1() functions for some wierd reason. Here is the php code:
    Code:
    <?php
    include("includes/host_conf.php");
    include("includes/mysql.lib.php");
    $obj=new connect;
    $mode=$_GET["mode"];
    
          echo "<table width='550' border='0' cellpadding='4' cellspacing='1' bgcolor='#eeeeee' align='center'>";
          echo "<tr>";
             echo "<td colspan=3> <a href=\"javascript:requestInfo1('showTable.php?mode=new&id=$id','showTable','')\">Add New Events</a>||<a href=\"javascript:requestInfo1('showTable.php?mode=list','showTable','')\">Refresh</a></td>";
          echo "</tr>";
          
          echo "<tr>";
             echo "<th> ID ";
             echo "<th> Author";
             echo "<th> Last Updated";
             echo "<th> Category";
             echo "<th> Event";
             echo "<th> Summary";
          echo "</tr>";
          // For Delete 
          if($mode=="delete") {      
             $var_id=$_GET["id"];
             $sqlDelete="Delete from events where id='$var_id'";
             $obj->query($sqlDelete);
             echo "<td><a href=\"javascript:delete_data();\">Delete</a>";
             echo "<tr>";
                echo "<td colspan=3>Data Deleted";
             echo "</tr>";
             
          }
          // End of Delete 
                      // For Add New Data -- Display Text box and the Cancel and Save Option 
          if($mode=="new") {
             echo "<tr>";
                echo "<td> <input id='id' size=5> ";
                echo "<td> <input id='author' size=10> ";
                echo "<td> <input id='last_updated' size=10> ";
                echo '<td> <select name="category">
                         <option value="category1">category1</option>
                         <option value="category2">category2</option>
                         <option value="category3">category3</option>
                         <option value="category4">category4</option>
                         </select> ';
                echo '<td> <textarea name="event" rows="12" cols="25"></textarea><td><textarea name="summary" rows="5" cols="25"></textarea> ';
                echo "<td<a href=\"javascript:requestInfo1('showTable.php?mode=list&id=$id','showTable','')\">Cancel</a></td>";
                echo "<td><a href=\"javascript:save_data1();\">Save</a>";
                
             echo "</tr>";
          }
          // End of Add New Data
            // After Click on Add >> Save option the data is save into the database 
          if($mode=="save_new") {
             $id=$_GET["id"];
             $author=$_GET["author"];
             $last_updated=$_GET["last_updated"];
             $category=$_GET["category"];
             $event=$_GET["event"];
             $summary=$_GET["summary"];
             $sqlSave="Insert into events values('$id','$author','$last_updated','$category','$events','$summary')";
             $obj->query($sqlSave);
             echo "<tr>";
                echo "<td colspan=3>Data Saved";
             echo "</tr>";
          }
          // End of save_new 
           // For Update save Option
          if($mode=="update_data") {
             $id=$_GET["id"];
             $author=$_GET["author"];
             $last_updated=$_GET["last_updated"];
             $category=$_GET["category"];
             $event=$_GET["event"];
             $summary=$_GET["summary"];
             $sqlUpdate="Update events set id='$id', author = '$author', last_updated = '$last_updated', category = '$category', event = '$event', summary = '$summary' where id='$prev_id'";
             $obj->query($sqlUpdate);
             echo "<tr>";
                echo "<td colspan=3>Data Updated";
             echo "</tr>";
          }
          // End of Update
            // Display all the data from the table 
             $sql="SELECT id,author,last_updated,category,event,summary FROM events order by id desc";
             $obj->query($sql);   
             while($row=$obj->query_fetch(0)) {
                $id=$row['id'];
                $author=$row['author'];
                $last_updated=$row['last_updated'];
                $category=$row['category'];
                $event=$row['event'];
                $summary=$row['summary'];
             echo "<tr bgcolor='#ffffff'>";
             // if Mode is Update then get the ID and display the text field with value Other wise print the data into the table 
             if($mode=="update") {
                $id_=$_GET["id"];
                }
             if($id_==$id) {
                echo "<input type='hidden' value='$id_' name='prev_id' id='prev_id'>";
                echo "<td> <input type='number' value='$id' id='id' size='5'> </td> ";
                echo "<td> <input type='text' value='$author' id='author' size='10'> </td> ";
                echo "<td> <input type='text' value='$last_updated' id='last_updated' size='10'> </td> ";
                ?><td> <select name="category">
                         <option><? echo $category; ?></option><? echo '
                         <option value="category1">category1</option>
                         <option value="category2">category2</option>
                         <option value="category3">category3</option>
                         <option value="category4">category4</option>
                         </select> ';
                ?><td> <textarea name="event" rows="12" cols="25"><? echo $event; ?></textarea><td><textarea name="summary" rows="5" cols="25"><? echo $summary; ?></textarea> <?
                echo "<td> <a href=\"javascript:requestInfo1('showTable.php?mode=list&id=$id','showTable','')\">Cancel</a> </td> ";
                echo "<td><a href=\"javascript:update_data1();\">Save</a>";
                }  else {
                echo "<td>$id</td>";
                echo "<td>$author</td>";
                echo "<td>$last_updated</td>";
                echo "<td>$category</td>";
                echo "<td>$event</td>";
                echo "<td>$summary</td>";
                echo "<td> <a href=\"javascript:requestInfo1('showTable.php?mode=update&id=$id','showTable','')\">Update</a> </td> ";
                echo "<td> <a href=\"javascript:requestInfo1('showTable.php?mode=delete&id=$id','showTable','');\" onclick='return confirmLink(this);'>Delete</a></td>";
             }      
             echo "</tr>";
             }
          echo "</table>";
    ?>
    I'll post the javascript code next in a separate post as the characters go over the limit.

  2. #2
    Join Date
    Apr 2009
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    And here is the javascript code:
    Code:
    function getHTTPObject() {
      var xmlhttp;
     
      if(window.XMLHttpRequest){
        xmlhttp = new XMLHttpRequest();
      }
      else if (window.ActiveXObject){
        xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
        if (!xmlhttp){
            xmlhttp=new ActiveXObject("Msxml2.XMLHTTP");
        }
       }
      return xmlhttp;
    }
    var http = getHTTPObject(); // We create the HTTP Object
    
        function requestInfo1(url,id,redirectPage) {     
          var temp=new Array();
             http.open("GET", url, true);
             http.onreadystatechange = function() {
                if (http.readyState == 4) {
                  if(http.status==200) {
                     var results=http.responseText;
                   if(redirectPage=="" || results!="1") {
                      
                      var temp=id.split("~"); // To display on multiple div
                      //alert(temp.length);
                      var r=results.split("~"); // To display multiple data into the div
                      //alert(temp.length);
                      if(temp.length>1) {
                         for(i=0;i<temp.length;i++) {   
                            //alert(temp[i]);
                            document.getElementById(temp[i]).innerHTML=r[i];
                         }
                      } else {
                         document.getElementById(id).innerHTML = results;
                      }   
                   } else {
                      //alert(results);
                      window.location.href=redirectPage;         
                   }
                  }
                  }
             };
             http.send(null);
           }
    function emptyValidation1(fieldList1) {
          
          var field1=new Array();
          field1=fieldList1.split("~");
          var counter1=0;
          for(i=0;i<field1.length;i++) {
             if(document.getElementById(field1[i]).value=="") {
                document.getElementById(field1[i]).style.backgroundColor="#FF0000";
                counter1++;
             } else {
                document.getElementById(field1[i]).style.backgroundColor="#FFFFFF";   
             }
          }
          if(counter1>0) {
                alert("The Field mark as red could not left empty");
                return false;
                
          }  else {
             return true;
          }
          
    }
    function loginProcess() {
       var var_username=document.getElementById("username").value;
       var var_password=document.getElementById("password").value;
       
       var checkValidation1=emptyValidation1('username~password');
       
       if(checkValidation1==true) {
          requestInfo1('login_check.php?username='+var_username+'&password='+var_password,'loginDetails','welcome.php');
       } else {
          return false;
       }
    }
    function init_table() {
          requestInfo1('showTable.php?mode=list','showTable','');
       }
       
       function save_data1() {
             var id=document.getElementById("id").value;
             var author=document.getElementById("author").value;
             var last_updated=document.getElementById("last_updated").value;
             var category=document.getElementById("category").value;
             var event=document.getElementById("event").value;
             var summary=document.getElementById("summary").value;
             var checkValidation1=emptyValidation1('id~author~last_updated~category~event~summary');
       
          if(checkValidation1==true) {
             requestInfo1('showTable.php?mode=save_new&id='+id+'&author='+author+'&last_updated='+last_updated+'&category='+category+'&event='+event+'&summary='+summary,'showTable','');
          }
       }
       
       function update_data1() {
             var prev_id=document.getElementById("prev_id").value;
             var id=document.getElementById("id").value;
             var author=document.getElementById("author").value;
             var last_updated=document.getElementById("last_updated").value;
             var category=document.getElementById("category").value;
             var event=document.getElementById("event").value;
             var summary=document.getElementById("summary").value;
             var checkValidation1=emptyValidation1('id~author~last_updated~category~event~summary');
       
          if(checkValidation1==true) {
             requestInfo1('showTable.php?mode=update_data&id='+id+'&author='+author+'&last_updated='+last_updated+'&category='+category+'&event='+event+'&summary='+summary+'&prev_id='+prev_id,'showTable','');
          
          }
       }
       
    function confirmLink(theLink)
    {
       
        var is_confirmed = confirm('Are you sure to delete this record?\n\nThis will permanently delete the Record!');
        if (is_confirmed) {
            theLink.href += '';
        }
    
        return is_confirmed;
    }
    Now I dont see any difference to why the javascript shouldnt work? Is there something missing?

    Thanks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •