This is a migrated thread and some comments may be shown as answers.

GRID - how to POST variable to PHP file

2 Answers 262 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Przemek
Top achievements
Rank 1
Przemek asked on 21 Feb 2013, 10:52 PM
Hello,

I'm new to Kendo UI framework but i have some experience with jQuery / AJAX.

I have problem with submiting value from my JS script to php file (simple AJAX works fine).

Here are my both php and js code.

var userList = new kendo.data.DataSource({
                transport: {
                    read: {
                        url: "php/usersModel.php",
                        dataType: "json"},
                        data: {operationCode:"showUsers"},
                        type: "post"
                     
                            
                },
                pageSize:10
                 
                 
            });
Without posting data it works fine (I tried with one-funciton-only php file). But in php file i have Switch function, every time my usersModel.php is requested i POST operationCode. When operationCode =="showUsers", showUsers function should be called, when I POST "showLogs" showLogs funciton in PHP file should be called.

In Chrome Console im getting this error: Uncaught TypeError: Cannot read property 'slice' of null.
There is my php code:
$operationCode = $_POST['operationCode'];
$conn= new MySQLI($host,$user,$DBpassword,$baza);
 
if (!empty($operationCode))
{
    Switch($operationCode)
        {
        case "deleteUser" :
            if (!empty($id))
                    {
                    deleteUser($id,$conn,$baza);
                    }
            break;
             
        case "showUsers" :
            showUsers($conn,$baza);
            break;  
        case "addUser" :
            addUser($baza,$conn,$serializedData,$operationCode);
            break;
        case "editUser":
            editUser($conn,$baza,$serializedData,$operationCode);
            break;
        case "showLogs":
            showLogs($conn);
            break;
        }
}
 
function showUsers($conn,$baza)
{
     
    $queryString="select id,username,email,telefon,imie,nazwisko,userlevel from ".$baza.".users t1 left join user_dane t2 on t1.id=t2.userid where t1.userlevel<>9 order by t1.id";
    $results=mysqli_query($conn,$queryString);
 
        $usersResult = array();  
        while ($row=mysqli_fetch_assoc($results))
        {
             
             
            array_push($usersResult,
                       array('id'=>$row['id'],
                             'username'=>$row['username'],
                             'email'=>$row['email'],
                             'telefon'=>$row['telefon'],
                             'userlevel'=>$row['userlevel'],
                             'imie'=>$row['imie'],
                             'nazwisko'=>$row['nazwisko']
                              
                             )
                        
                        
                       );
                      
        }
        echo json_encode($usersResult);
         
}

Of course db,host and other variables are defined properly.

I hope someone here is able to help me. And sorry for my !perfect English ;)

Best regards.

2 Answers, 1 is accepted

Sort by
0
Przemek
Top achievements
Rank 1
answered on 21 Feb 2013, 11:38 PM
I solved my problem by using GET method.

var userList = new kendo.data.DataSource({
               transport: {
                   read: {
                       data:{operationCode:"showUsers"},
                       url: "php/usersModel.php",
                       dataType: "json"},
                        
                       type: "get",
                       
                           
               },
               pageSize:10
                
                
           });
Could anyone answer me, why POST method does not work ?

Best Regards
0
Hemant
Top achievements
Rank 1
answered on 11 May 2013, 12:14 PM
@Przemek,
can u share your add ,delete and update code with kendo grid and php.
I am only able to do read the reacords,rest are not working for me.please share rest.
thanks
Tags
Grid
Asked by
Przemek
Top achievements
Rank 1
Answers by
Przemek
Top achievements
Rank 1
Hemant
Top achievements
Rank 1
Share this question
or