add function not working???

Ibshas25 · November 12, 2010

deleting works, but can't seem to get the add to work???? any ideas

<!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>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Search User</title>
<link href="stylesheet1.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery-1.4.3.js"></script>
<script type="text/javascript" src="jquery.json-2.2.js"></script>
<style type="text/css">
body {
font-size:12px;
font-family:Arial, Helvetica, sans-serif;
}
form {
display:block;  
width:260px;
}
form .input{
width:120px;
float:right;
}

form label {
display:block;
width:260px;
clear:both;
}

form textarea {
display:block;
width:260px;
}
</style>
<script type="text/javascript">
// alert("document loaded 1");
// $(document).ready(function(){ 
//$("#projectid").html("1");
// alert("document loaded 1");

function userlistgenerate(){
var data = 
  { 
   "operation" : "userlist",
    "users": [ 
      { "userid" : "usr_id"},
    ] // end of sales array
  }
  //alert("geldi 2");

  //var dataString = JSON.(data);
  var dataString = $.toJSON(data);
  //alert("geldi 3");
  // alert(dataString);
  $.post('UserSearchPBT.php', { data: dataString}, userlistResult, "text");
  $("#selectedUserName").html("");
  // $("selectedUserName").hide("fast");
}



function userlistResult(res)
{

  var obj = $.evalJSON(res);

  //alert(obj.ResultData);

  //$("#sales1Lastname").html("Lastname of sales[1]: " +obj.sales[0].lastname);

  $("#userlist").html(obj.ResultData);

  $("#selectedUserName").html("");

  //$("selectedUserName").hide("fast");
}



function UserSearchChoose(userid,username ,name,surname,email,phone,mobphone,isactive){

  $("#userid").val(userid);
  $("#username").val(username);
  $("#name").val(name);
  $("#surname").val(surname);
  $("#email").val(email);
  $("#phone").val(phone);
  $("#mobphone").val(mobphone);
  $("#isuseractive").val(isactive);
  $("#useradd").hide("fast");
  

}

function usersearch() {

       $("#useradd").show();
	var name=$("#name").attr("value");
	var surname=$("#surname").attr("value");
	var data = 
         { 
	     "operation" : "usersearch",
             "user": [ 
               { "name" : name, "surname" :  surname }

            ] // end of sales array
         }
       var dataString = $.toJSON(data);
       $.post('UserSearchPBT.php', { data: dataString}, usersearchResult, "text");
}


function usersearchResult(res)
{

  var obj = $.evalJSON(res);
  $("#userlist").html(obj.ResultData);

}



function userdelete() {
        var useridval = $("#userid").attr("value");
    alert (useridval);
	var data = 
         { 
	     "operation" : "teamdelete",
		 "userid" : useridval
         }

       var dataString = $.toJSON(data);
       $.post('UserSearchPBT.php', { data: dataString}, userdeleteResult, "text");

}

function userdeleteResult(res)
{
  var obj = $.evalJSON(res);
  $("#successfailmessage").html(obj.SuccFailMessage);
  userlistgenerate();
  
}


function useradd() { 
    //alert ("team add a geliyor");
    var userId = $("#userid").attr("value");
	var username = $("#username").attr("value");
	var usersurname = $("#surname").attr("value");
	var useremail = $("#useremail").attr("value");
	var userphone = $("#userphone").attr("value");
	var usermob = $("#usermob").attr("value");

	var useractive = $("#useractive").attr("value");

  //  alert ("--".projectId."-".userId."-".rolId."--");
	var data = 
         { 
	     "operation" : "useradd",
		 "userId" : userId,
		 "username" : username,

		 "useremail" : useremail,
		 "userphone" : userphone,
		 "usermob" : usermob,
		 "useractive" : useractive,

		 "recuser" : 1 
         }

       var dataString = $.toJSON(data);
       $.post('UserSearchPBT.php', { data: dataString}, userdeleteResult, "text");
    alert ("user add a geliyor ajax bitti");   

}





</script>
</head>
<body>

<form id="iletisim">
<div id="formdiv">
    <table><tr>
	    <td><span id="successfailmessage"></span></td>
            <tr><td><span id="userlist"></span> </td></tr>

		<tr><td><span id="selectedUserName"></span></td></tr>
		<tr><td><label for="name">User Name<input class="input" name="username" id="username" type="text" value=""  /></label></td></tr>
<tr><td><label for="name">Name<input class="input" name="name" id="name" type="text" value=""  /></label></td></tr>
			<tr><td><label for="surname">Surname<input class="input" name="surname" id="surname" type="text" value="" /></label><tr>
			<tr><td><label for="email">Email<input class="input" name="email" id="email" type="text" value="" /></label><tr>
			<tr><td><label for="phone">Phone<input class="input" name="phone" id="phone" type="text" value="" /></label><tr>
			<tr><td><label for="phone">Mobile Phone<input class="input" name="mobphone" id="mobphone" type="text" value="" /></label><tr>

		<tr><td><label for="phone">Is User Active(Y/N)<input class="input" name="isuseractive" id="isuseractive" type="text" value="" /></label></td></tr>
		<tr><td><a href='#' onclick="javascript:usersearch();">Search User</a> </td></tr><tr>
		<tr><td><a href='#' id="useradd" onclick="javascript:useradd();">Add</a> </td></tr><tr>
		<tr><td><a href='#' id="userdelete" onclick="javascript:userdelete();">Delete</a> </td></tr><tr>
		<tr><td><a href='#' id="userupdate" onclick="javascript:userupdate();">Update</a> </td></tr><tr>
		</table>
	<input  type="hidden"  id = "userid" value="" name="userid" />
</div>
</form>
</body>
</html>

Ibshas25 · November 12, 2010


<?php
include("JSON.php");

  require_once("connectdb.php"); 


$req = json_decode(stripslashes($_POST['data']), true);

$req["SuccFail"]="fail";

$req["SuccFailMessage"]="Error Occured.";
//$logFile = 'logFile';
// error_log("isl=baþladý: ", 3, $logFile);

if ($req['operation'] == "usersearch") // select için veri geldi
{
   // error_log("isl==select oluþuyor: ", 3, $logFile);
    $sql= "select usr_id, usr_username,usr_name,usr_surname,usr_email,usr_mobphone,usr_phone,usr_isuseractive from  users";

    $sql.=" where (usr_name is null or  usr_name like '".  $req['user'][0]['name']."%'  )  and ";

    $sql.= "(usr_surname is null or usr_surname  like '".  $req['user'][0]['surname']."%'  ) ";  

$sql .= " order by usr_name , usr_surname";
// error_log($sql, 3, $logFile);

// error_log("sql: ".$sql, 3, $logFile);
// error_log("\n", 3, $logFile);

    $result = mysql_query($sql);

    $reslist = "<table border='1'><tr><th>User Id</th><th>Username</th><th>Name</th><th>Surname</th><th>Email</th><th>Is Active</th></tr>";
    
   while($row = mysql_fetch_array($result))
   {
	// error_log("user: ".$row['usr_name']." surname :".$row['usr_username'], 3, $logFile);
$reslist .= "<tr><td><a href='#' onclick='javascript:UserSearchChoose(".$row['usr_id'].", ".chr(34).$row['usr_username'].chr(34).",".chr(34).$row['usr_name'].chr(34).", ".chr(34).$row['usr_surname'].chr(34).",".chr(34).$row['usr_email'].chr(34).", ".chr(34).$row['usr_phone'].chr(34).",".chr(34).$row['usr_mobphone'].chr(34).", ".chr(34).$row['usr_isuseractive'].chr(34).");' >".$row['usr_id']."</a></td><td>".$row['usr_username']."</td><td>".$row['usr_name']."</td><td> ".$row['usr_surname']."</td><td>".$row['usr_email']."</td><td>".$row['usr_isuseractive']."</td></tr>";

   }
  // error_log($reslist, 3, $logFile);
	// error_log("$reslist: ".$reslist, 3, $logFile);
   $reslist .= "</table>";
   $req["SuccFail"]="success"; //operation success or fail
   $req["SuccFailMessage"]="successfully selected.";
   //alert($reslist);
   $req["ResultData"]=$reslist;
     mysql_close($conn); 
   header("Content-type: text/plain");
   echo json_encode($req); 
   return;
   } 
   
   else if ($req['operation'] == "userlist") // select için veri geldi
   {
   // error_log("isl==teamslist select oluþuyor: ", 3, $logFile);
   $sql="select usr.usr_name,usr.usr_surname  
where usr.usr_id =".$req['user'][0][usr_id];
$sql.=" order by usr.usr_name , usr.usr_surname ";


    $result = mysql_query($sql);
    $reslist = "<table border='1'><tr><th>Users Info</th> </tr>";
    
     while($row = mysql_fetch_array($result))
   {
	 // error_log("user: ".$row['usr_name']." surname :".$row['usr_username'], 3, $logFile);
	  //$user = $row['usr_name']." ".$row['usr_surname'];

	 //$user = $row['usr_name']." ".$row['usr_surname'];
	  $reslist .= "<tr><td><a href='#' onclick='javascript:userListChoose(".$row['usr_name'].chr(34).",".chr(34).$row['usr_surname'].chr(34).");'> </a></td></tr>"; 
   
   $reslist .= "</table>";
   
   
      $req["SuccFail"]="success"; //operation success or fail
   $req["SuccFailMessage"]="successfully selected.";
   //alert($reslist);
   $req["ResultData"]=$reslist;
   mysql_close($conn); 
   header("Content-type: text/plain");
   echo json_encode($req); 
   return;
   } 
   
     if ($req['operation'] == "userdelete") // teams silmek için geldi.
   {
      //error_log("isl==teamdelete: ", 3, $logFile);
      //$sql="delete from teams where tea_id=".$req['teamid']; 
      mysql_query("delete from users where usr_id=".$req['userid']);
  
//error_log("mysql_affected_rows= ".mysql_affected_rows($con), 3, $logFile); 
      //var $affrows = mysql_affected_rows();
  
   if ( mysql_affected_rows() > 0 ) {
	  $req["SuccFail"]="success"; //operation success or fail
	  $req["SuccFailMessage"]="successfully deleted.";
	  //error_log("isl==teamdelete:success ", 3, $logFile);
   }
   else {
	   $req["SuccFail"]="fail"; //operation success or fail
	   $req["SuccFailMessage"]="error occured ". mysql_error();
	  // error_log("isl==teamdelete:fail ", 3, $logFile);
   }
      
   mysql_close($conn); 
   header("Content-type: text/plain");
   echo json_encode($req); 
   return;
   } 
   
    else if ($req['operation'] == "useradd") // teams silmek için geldi.
   {
      //error_log("isl==teamdelete: ", 3, $logFile);
      //$sql="delete from teams where tea_id=".$req['teamid']; 
  $sql="insert into users VALUES (null,". $req['userId'].",".$req['username'].",".$req['usersurname'].", ".$req['useremail']." , ".$req['userphone'].", ".$req['usermob'].", ".$req['useractive'].",now(),".$req['recuser'].")";
   mysql_query($sql);

  
//error_log($sql, 3, $logFile); 
      //var $affrows = mysql_affected_rows();
  
   if ( mysql_affected_rows() > 0 ) {
	  $req["SuccFail"]="success"; //operation success or fail
	  $req["SuccFailMessage"]="successfully added.";
	  //error_log("isl==teamdelete:success ", 3, $logFile);
   }
   else {
	   $req["SuccFail"]="fail"; //operation success or fail
	   $req["SuccFailMessage"]="error occured ". mysql_error();
	  // error_log("isl==teamdelete:fail ", 3, $logFile);
   }
      
   mysql_close($conn); 
   header("Content-type: text/plain");
   echo json_encode($req); 
   return;
   } 
   
}  
   ?>

Sign In

add function not working???

Recommended Posts

Ibshas25

Link to comment

Share on other sites

Ibshas25

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information