PUT, DELETE, POST not working for some reason. about php-crud-api

[clh021]

Hey! @kimeeo What wrong? Me too.

@mevdschee Maybe this tool should write some log or debug.
return null. And no more .I 'm cray......

curl -X POST "http://localhost/api.php/posts" -H "accept: application/json" -H "Content-Type: application/json" -d "{ \"user_id\": 44, \"category_id\": 3, \"content\": \"这是一个测试\"}"

Code | Details
--       |   --
200 | Response body     null
         Response headers content-type: application/json; charset=utf-8


Code | Description
-- | --
200 | Identifier of created item.
Example Value
Model   0

Sorry..................

user_id and category_id must be exist.

[mevdschee]

@xouaib it is probably another exception, please replace "PDOException" with "Exception" or "Throwable" depending on your PHP version.

[mevdschee]

@xouaib You are now sending post parameters and expect it to be a JSON document, that's not correct.

[kimeeo]

Try this with

PUT http://kimeeo.com/restDemo/api.php/categories/2
name=my_name

POST
http://kimeeo.com/restDemo/api.php/categories
name=my_name

DELETE
http://kimeeo.com/restDemo/api.php/categories/2

all it does is return null.

[mevdschee]

I would love to help, but I need more information. Which database engine do you use? Which SQL file did you load? What platform are you on? Which client do you use (like PostMan or curl)? Please provide more information.

[mevdschee]

Went to "http://editor.swagger.io/" and clicked "File" - "Import URL" and entered "http://kimeeo.com/restDemo/api.php". There I tested your API and it works fine!

[kimeeo]

Which database engine do you use.
-> MySQL

Which SQL file did you load
->blog_mysql.sql

What platform are you on?
-> PHP 5.6

Which client do you use
-> PostMan

As I said, GET is working

but if PUT, DELETE, POST it reutnr's null

[kimeeo]

My Bad, Something was wrong at my end.

[mevdschee]

No problem, enjoy the software!

[mevdschee]

I don't know, probably returning an header with the error message would make most sense.. but only in the case some debug flag is true.. for security reasons.. or yes.. logging.. that could also work..

[xouaib]

@mevdschee hi dear,
pl i create CRUD system API using PHP and MySQL, then the POST not working :

<?php
include 'config/database.php';
if ($_POST) {

    try {

        $query = "INSERT INTO products SET p_name=:name, p_description=:description, p_price=:price";

        $stmt = $con->prepare($query);

        $name = $_POST['name'];
        $description = $_POST['description'];
        $price = $_POST['price'];

        $stmt->bindParam(':name', $name);
        $stmt->bindParam(':description', $description);
        $stmt->bindParam(':price', $price);

        if ($stmt->execute()) {
            echo json_encode(array('result' => 'success'));
        } else {
            echo json_encode(array('result' => 'fail'));
        }
    } catch (PDOException $exception) {
        die('ERROR: ' . $exception->getMessage());
    }
}

the database file contains already all header that we need , i check the CREATE with POST method using POSTMAN but not working

CORDIALLY
CORD

[xouaib]

i still strive with it without ay advance Mr @mevdschee

[xouaib]

@mevdschee thank you so much it's working perfectly