Jump to content

add function not working???

Ibshas25

By Ibshas25
in PHP Coding Help

 Share

Recommended Posts

Ibshas25 Member

Ibshas25

Posted
Posted

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>

Link to comment
Share on other sites
Ibshas25 Member

Ibshas25

Posted
  • Author
Posted 

<?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;
   } 
   
}  
   ?>

Link to comment
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.