Ibshas25 Posted November 12, 2010 Share Posted 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> Quote Link to comment Share on other sites More sharing options...
Ibshas25 Posted November 12, 2010 Author Share Posted 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; } } ?> Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.