Jump to content

Fatal error: Call to undefined function json_decode() in

Ibshas25

By Ibshas25
in Javascript Help

 Share

Recommended Posts

Ibshas25 Member

Ibshas25

Posted
Posted

i seem to be getting this error and cant figure it out..

 


?php
  require_once("connectdb.php"); 
/*Connect to your Database
  $conn = mysql_connect("127.0.0.1", "root", "kasapogluo") 
or die("Could not connect to MySQL Server: " . mysql_error());

//Select your Database
  mysql_select_db("test") 
or die("Could not select database");
*/

$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_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>Is Active</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'];
	  $reslist .= "<tr><td><a href='#' onclick='javascript:UserSearchChoose(".$row['usr_id'].",".chr(34).$row['usr_name'].chr(34).",".chr(34).$row['usr_surname'].chr(34).");'>".$row['usr_id']."</a></td><td>" . $row['usr_username'] . "</td><td>" . $row['usr_name'] . "</td>";
	  $reslist .= "<td>" . $row['usr_surname'] . "</td><td>" . $row['usr_isuseractive'] . "</td></tr>"; 
   }
	// error_log("$reslist: ".$reslist, 3, $logFile);
   $reslist .= "</table>";
   
   // error_log("$reslist: ".$reslist, 3, $logFile);
   // error_log("\n", 3, $logFile);
   
   
   $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'] == "rolesearch") // select için veri geldi
   {
	$sql= "select rol_Id, rol_name from roles order by rol_name";
	$result = mysql_query($sql);
	$reslist = "<select id='roles' name='roles'>";
         while($row = mysql_fetch_array($result))
          {	
		$reslist .= "<option value='".$row['rol_Id']."' ";

		if($row['rol_Id']==1)
		{
			$reslist .= " selected ";
		}
		$reslist .= " >".$row['rol_name']."</option>";
	 }
	//error_log("$reslist: ".$reslist, 3, $logFile);
	//error_log("\n", 3, $logFile);


	$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'] == "teamslist") // select için veri geldi
   {
   // error_log("isl==teamslist select oluþuyor: ", 3, $logFile);
   $sql="select tea.tea_id,tea.tea_projectId, prj.prj_projectname , tea.tea_userId,usr.usr_name,usr.usr_surname,tea.tea_rolId,rol.rol_name 
   from teams as tea  
   LEFT JOIN projects as prj  ON prj .prj_id  =  tea.tea_projectId 
   LEFT JOIN users as usr  ON usr.usr_id  =  tea.tea_userId   
   LEFT JOIN roles as rol  ON rol.rol_Id  =  tea.tea_rolId  
where tea.tea_projectId =".$req['teams'][0][projectid];
$sql.=" order by usr.usr_name , usr.usr_surname ,prj.prj_projectname ";
/*
  (usr.usr_name is null or  usr.usr_name  like 'ib%' )  and 
           (usr.usr_surname is null or usr.usr_surname  like '%' )   
order by usr.usr_name , usr.usr_surname ,prj.prj_projectname
    $sql= "select usr_id, usr_username,usr_name,usr_surname,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: ".$sql, 3, $logFile);
//error_log("\n", 3, $logFile);

    $result = mysql_query($sql);
    $reslist = "<table border='1'><tr><th>Team Id</th> <th>Role</th> <th>Name</th> <th>Surname</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'];
	  $reslist .= "<tr><td><a href='#' onclick='javascript:TeamListChoose(".$row['tea_id'].",".$row['tea_projectId'].",".$row['tea_userId'].",".$row['tea_rolId'].",".chr(34).$row['usr_name'].chr(34).",".chr(34).$row['usr_surname'].chr(34).");'>".$row['tea_id']."</a></td><td>" . $row['rol_name'] . "</td><td>" . $row['usr_name'] . "</td>";
	  $reslist .= "<td>" . $row['usr_surname'] . "</td></tr>"; 
   }
	// error_log("$reslist: ".$reslist, 3, $logFile);
   $reslist .= "</table>";
   
   // error_log("$reslist: ".$reslist, 3, $logFile);
   // error_log("\n", 3, $logFile);
   
   
   $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'] == "teamdelete") // teams silmek için geldi.
   {
      //error_log("isl==teamdelete: ", 3, $logFile);
      //$sql="delete from teams where tea_id=".$req['teamid']; 
      mysql_query("delete from teams where tea_id=".$req['teamid']);
  
//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'] == "teamadd") // teams silmek için geldi.
   {
      //error_log("isl==teamdelete: ", 3, $logFile);
      //$sql="delete from teams where tea_id=".$req['teamid']; 
     
  $sql="insert into teams VALUES (null,". $req['projectId'].",".$req['userId'].",".$req['rolId'].",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 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;
   } 
?>

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.