# Slim 3 Giving 404 when passing parameters

**URL:** <https://discourse.slimframework.com/t/slim-3-giving-404-when-passing-parameters/481>\
**Category:** Questions\
**Created:** [July 7, 2016, 10:32am UTC](https://discourse.slimframework.com/t/slim-3-giving-404-when-passing-parameters/481 "2016-07-07T10:32:21Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![anupam\_4881](https://avatars.discourse-cdn.com/v4/letter/a/59ef9b/32.png) [@anupam\_4881](https://discourse.slimframework.com/u/anupam_4881)\
**Post date:** [July 7, 2016, 10:32am UTC](https://discourse.slimframework.com/t/slim-3-giving-404-when-passing-parameters/481/1 "2016-07-07T10:32:21Z")

</div>

Hi Team,

Need your help i am very new for API world, recently I installed slim 3 along with php7 and Apache 2.6 via composer, Installation has done successfully, and i am able to create and run first Hello Program and other API where no parameter is required.

Working.  
[http://192.168.0.205/api/another.php/wines](http://192.168.0.205/api/another.php/wines) outcome received.  
{“wine”:  
[{“id”:“2”,“name”:“aaa”,“grapes”:“sss”,“country”:“cc”,“region”:“dd”,“year”:"2016-07-04

16:43:36",“description”:“eeee”},{“id”:“1”,“name”:“piper”,“grapes”:“green”,“country”:"(IN",“region”:“Delhi”,“year”:“2016-07-05  
16:34:27”,“description”:"very old "}]}

Not Working ( but when i am passing parameters it start getting me 404 error pages.

[http://192.168.0.205/api/another.php/wines/1](http://192.168.0.205/api/another.php/wines/1) ( give 404 page) .

I have also check .htaccess option same situation with or without another.php file. this happen.

Need your input and help to fix his issue.

-------------------------------------------------------------another.php-------------------------------------------

\<?php use \Psr\Http\Message\ServerRequestInterface as Request; use \Psr\Http\Message\ResponseInterface as Response; require 'slim/vendor/autoload.php'; require 'db.php'; $app = new \Slim\App; $app-\>get('/hello/{name}', function (Request $request, Response $response) { $name = $request-\>getAttribute('name'); $response-\>getBody()-\>write("Hello, $name"); return $response; }); $app-\>get('/wines/:id','getWine', function ($id) { print $id; }); $app-\>get('/wines', 'getWines'); //$app-\>get('/wines/:id', 'getWine'); $app-\>get('/wines/search/:query', 'findByName'); $app-\>post('/wines', 'addWine'); $app-\>put('/wines/:id', 'updateWine'); $app-\>delete('/wines/:id', 'deleteWine'); $app-\>run(); function getWines() { $sql = "select \* FROM wine ORDER BY name"; try { $db = getConnection(); $stmt = $db-\>query($sql); $wines = $stmt-\>fetchAll(PDO::FETCH\_OBJ); $db = null; echo '{"wine": ' . json\_encode($wines) . '}'; } catch(PDOException $e) { echo '{"error":{"text":'. $e-\>getMessage() .'}}'; debug\_print\_backtrace(); } } function getWine($id) { $sql = "SELECT \* FROM wine WHERE id=:id"; try { $db = getConnection(); $stmt = $db-\>prepare($sql); $stmt-\>bindParam("id", $id); $stmt-\>execute(); $wine = $stmt-\>fetchObject(); $db = null; echo json\_encode($wine); } catch(PDOException $e) { echo '{"error":{"text":'. $e-\>getMessage() .'}}'; debug\_print\_backtrace(); } } function addWine() { $request = Slim::getInstance()-\>request(); $wine = json\_decode($request-\>getBody()); $sql = "INSERT INTO wine (name, grapes, country, region, year, description) VALUES (:name, :grapes, :country, :region, :year, :description)"; try { $db = getConnection(); $stmt = $db-\>prepare($sql); $stmt-\>bindParam("name", $wine-\>name); $stmt-\>bindParam("grapes", $wine-\>grapes); $stmt-\>bindParam("country", $wine-\>country); $stmt-\>bindParam("region", $wine-\>region); $stmt-\>bindParam("year", $wine-\>year); $stmt-\>bindParam("description", $wine-\>description); $stmt-\>execute(); $wine-\>id = $db-\>lastInsertId(); $db = null; echo json\_encode($wine); } catch(PDOException $e) { echo '{"error":{"text":'. $e-\>getMessage() .'}}'; } } function updateWine($id) { $request = Slim::getInstance()-\>request(); $body = $request-\>getBody(); $wine = json\_decode($body); $sql = "UPDATE wine SET name=:name, grapes=:grapes, country=:country, region=:region, year=:year, description=:description WHERE id=:id"; try { $db = getConnection(); $stmt = $db-\>prepare($sql); $stmt-\>bindParam("name", $wine-\>name); $stmt-\>bindParam("grapes", $wine-\>grapes); $stmt-\>bindParam("country", $wine-\>country); $stmt-\>bindParam("region", $wine-\>region); $stmt-\>bindParam("year", $wine-\>year); $stmt-\>bindParam("description", $wine-\>description); $stmt-\>bindParam("id", $id); $stmt-\>execute(); $db = null; echo json\_encode($wine); } catch(PDOException $e) { echo '{"error":{"text":'. $e-\>getMessage() .'}}'; } } function deleteWine($id) { $sql = "DELETE FROM wine WHERE id=:id"; try { $db = getConnection(); $stmt = $db-\>prepare($sql); $stmt-\>bindParam("id", $id); $stmt-\>execute(); $db = null; } catch(PDOException $e) { echo '{"error":{"text":'. $e-\>getMessage() .'}}'; } } function findByName($query) { $sql = "SELECT \* FROM wine WHERE UPPER(name) LIKE :query ORDER BY name"; try { $db = getConnection(); $stmt = $db-\>prepare($sql); $query = "%".$query."%"; $stmt-\>bindParam("query", $query); $stmt-\>execute(); $wines = $stmt-\>fetchAll(PDO::FETCH\_OBJ); $db = null; echo '{"wine": ' . json\_encode($wines) . '}'; } catch(PDOException $e) { echo '{"error":{"text":'. $e-\>getMessage() .'}}'; } } function getConnection() { $dbhost="localhost"; $dbuser="root"; $dbpass=""; $dbname="api"; $dbh = new PDO("mysql:host=$dbhost;dbname=$dbname", $dbuser, $dbpass); $dbh-\>setAttribute(PDO::ATTR\_ERRMODE, PDO::ERRMODE\_EXCEPTION); return $dbh; } ?\>
* * *

Regards  
Anupam

---

<div class="post-metadata">

**Author:** ![llvdl](https://yyz2.discourse-cdn.com/flex030/user_avatar/discourse.slimframework.com/llvdl/32/78_2.png) [@llvdl](https://discourse.slimframework.com/u/llvdl)\
**Post date:** [July 7, 2016, 9:33pm UTC](https://discourse.slimframework.com/t/slim-3-giving-404-when-passing-parameters/481/2 "2016-07-07T21:33:50Z")

</div>

Could you try:

```php
$app->get('/wines/{id}','getWine', function ($id) {
    print $id;
}); 

```

Instead of:

```php
$app->get('/wines/:id','getWine', function ($id) {
    print $id;
}); 

```

Placeholders have to start with { and end with }. There is more information on placeholders in routes in the [docs](http://www.slimframework.com/docs/objects/router.html#route-placeholders).

---

<div class="post-metadata">

**Author:** ![anupam\_4881](https://avatars.discourse-cdn.com/v4/letter/a/59ef9b/32.png) [@anupam\_4881](https://discourse.slimframework.com/u/anupam_4881)\
**Post date:** [July 8, 2016, 8:38am UTC](https://discourse.slimframework.com/t/slim-3-giving-404-when-passing-parameters/481/3 "2016-07-08T08:38:31Z")

</div>

Thanks for helping to fix issues i am facing, really appreciate.

Yes when i did changes as per your suggestion, i can able to fix 404 error however it now stuck on another error seems related to value of $id in sql query ( conversion issue)  
“Catchable fatal error: Object of class Slim\Http\Request could not be converted to string in /var/www/html/slim/public/api/index.php on line 70”

if simple use  
$sql = “SELECT \* FROM wine WHERE name=’$id’”;

if i hardcore the value of name of below sql it api work with fix value as expected just for testing.  
$sql = “SELECT \* FROM wine WHERE name=‘1’”;

if  
use $id = (int) $id;

showing same error but result come  
$sql = “SELECT \* FROM wine WHERE name=’$id’”;

Kindly suggest how to manage if parameter is int or string or any value just like in practical situation.

----------------------------------------------------------------------------code---------------------------------

$app-\>get(’/wines/{id}’, ‘getWine’, function ($id){  
});

function getWine($id) {  
//$id = (int) $id;  
$sql = “SELECT \* FROM wine WHERE name=’$id’”;

```
try {
    $db = getConnection();
   $stmt = $db->query($sql);
    $wines = $stmt->fetchAll(PDO::FETCH_OBJ);
    $db = null;
    echo '{"wine": ' . json_encode($wines) . '}';

} catch(PDOException $e) {
    echo '{"error":{"text":'. $e->getMessage() .'}}';
    debug_print_backtrace();
}

```

}

Regards  
Anupam

---

<div class="post-metadata">

**Author:** ![anupam\_4881](https://avatars.discourse-cdn.com/v4/letter/a/59ef9b/32.png) [@anupam\_4881](https://discourse.slimframework.com/u/anupam_4881)\
**Post date:** [July 8, 2016, 9:09am UTC](https://discourse.slimframework.com/t/slim-3-giving-404-when-passing-parameters/481/4 "2016-07-08T09:09:25Z")

</div>

Infact if i use new get

$app-\>get(’/books/{one}/{two}’, function ($one, $two) {  
echo "The first parameter is " . $one;  
echo "The second parameter is " . $two;  
});

it is also giving same error  
Catchable fatal error: Object of class Slim\Http\Request could not be converted to string in /var/www/html/slim/public/api/index.php on line 37

---

<div class="post-metadata">

**Author:** ![llvdl](https://yyz2.discourse-cdn.com/flex030/user_avatar/discourse.slimframework.com/llvdl/32/78_2.png) [@llvdl](https://discourse.slimframework.com/u/llvdl)\
**Post date:** [July 8, 2016, 11:26am UTC](https://discourse.slimframework.com/t/slim-3-giving-404-when-passing-parameters/481/5 "2016-07-08T11:26:17Z")

</div>

The callback function in Slim 3 has the following signature:

```php
function (Slim\Http\Request $request, Slim\Http\Response $response, array $args)

```

The placeholder values are stored in the `$args` argument. For example:

```php
$app->get('/hello/{name}', function ($request, $response, $args) {
    echo "Hello, " . $args['name'];
});

```

---

<div class="post-metadata">

**Author:** ![geggleto](https://yyz2.discourse-cdn.com/flex030/user_avatar/discourse.slimframework.com/geggleto/32/11_2.png) [@geggleto](https://discourse.slimframework.com/u/geggleto)\
**Post date:** [July 8, 2016, 12:40pm UTC](https://discourse.slimframework.com/t/slim-3-giving-404-when-passing-parameters/481/6 "2016-07-08T12:40:46Z")

</div>

We don’t support the string method of route middleware anymore ;(

If you want route middleware you use `$route->add();`

Example:

```php
$app->get()->add(function ($req, $res, $next) {
     return $next($req, $res);
});

```

---

<div class="post-metadata">

**Author:** ![anupam\_4881](https://avatars.discourse-cdn.com/v4/letter/a/59ef9b/32.png) [@anupam\_4881](https://discourse.slimframework.com/u/anupam_4881)\
**Post date:** [July 11, 2016, 7:11am UTC](https://discourse.slimframework.com/t/slim-3-giving-404-when-passing-parameters/481/7 "2016-07-11T07:11:08Z")

</div>

Thanks for your suggestion.

Now I am getting sql error, kindly guide me how to pass variable in getWine Function & in sql query ( what changes is required in function getWine & in $sql where id=$var1.

Will appreciate if you share me some doc for creating insert and other api, all reference available at internet are refer old version syntax.

Regards  
Anupam

$app-\>get(’/books/{var1}/{var2}’,‘getWine’, function ($request, $response, $args) {  
echo "Hello, " . $args[‘var1’] . ’&nbsp;‘. “and” .’&nbsp’. $args[‘var2’];  
});

function getWine ($var1) {

```
$sql = "SELECT * FROM wine WHERE id=$var1";

try {
    $db = getConnection();
   $stmt = $db->query($sql);
    $wines = $stmt->fetchAll(PDO::FETCH_OBJ);
    $db = null;
    echo '{"wine": ' . json_encode($wines) . '}';

} catch(PDOException $e) {
    echo '{"error":{"text":'. $e->getMessage() .'}}';
    debug_print_backtrace();
}

```

}  
function getConnection() {  
$dbhost=“localhost”;  
$dbuser=“root”;  
$dbpass="";  
$dbname=“api”;  
$dbh = new PDO(“mysql:host=$dbhost;dbname=$dbname”, $dbuser, $dbpass);  
$dbh-\>setAttribute(PDO::ATTR\_ERRMODE, PDO::ERRMODE\_EXCEPTION);  
return $dbh;  
}

---

<div class="post-metadata">

**Author:** ![llvdl](https://yyz2.discourse-cdn.com/flex030/user_avatar/discourse.slimframework.com/llvdl/32/78_2.png) [@llvdl](https://discourse.slimframework.com/u/llvdl)\
**Post date:** [July 11, 2016, 10:56am UTC](https://discourse.slimframework.com/t/slim-3-giving-404-when-passing-parameters/481/8 "2016-07-11T10:56:10Z")

</div>

Hello Anupam,

You can find the documentation for Slim 3 at [http://www.slimframework.com/docs/](http://www.slimframework.com/docs/)

The documentation contains a tutorial which includes database access: [http://www.slimframework.com/docs/tutorial/first-app.html](http://www.slimframework.com/docs/tutorial/first-app.html)  
The source code for the tutorial can be found at: [https://github.com/slimphp/Tutorial-First-Application/tree/master/src](https://github.com/slimphp/Tutorial-First-Application/tree/master/src)

---

<div class="post-metadata">

**Author:** ![anupam\_4881](https://avatars.discourse-cdn.com/v4/letter/a/59ef9b/32.png) [@anupam\_4881](https://discourse.slimframework.com/u/anupam_4881)\
**Post date:** [September 28, 2016, 6:15am UTC](https://discourse.slimframework.com/t/slim-3-giving-404-when-passing-parameters/481/9 "2016-09-28T06:15:04Z")

</div>

Thanks now able to call database call also. for get,post,delete,update ( slim 3 )

* * *

require ‘vendor/autoload.php’;  
require\_once ‘connection.php’;  
/\*\*

- Step 2: Instantiate a Slim application
- 
- This example instantiates a Slim application using
- its default settings. However, you will usually configure
- your Slim application now by passing an associative array
- of setting names and values into the application constructor.  
\*/  
$app = new Slim\App();

$app-\>group(’/login’, function () {

$this-\>get(’/wines/{name}/{anu}’,‘getWine’, function ($request, $response, $args) {});  
$this-\>post(’/wines’,‘getWines’, function ($request,$response,$args){} );  
$this-\>post(’/wines/search’,‘search’,function ($request,$response,$args){});  
$this-\>post(’/wines\_add’,‘addWine’,function ($request,$response,$args){});  
$this-\>put(’/wines/{id}’, ‘updateWine’,function ($request,$response,$args){});  
$this-\>delete(’/wines/{id}’, ‘deleteWine’,function ($request,$response,$args){});  
$this-\>post(’/createstudent’,‘createstudent’, function ($request,$response,$args){} );

} );

// Run app  
$app-\>run();

function getWine($request, $response, $args) {

$id=$args[‘name’];  
// check for required params  
//verifyRequiredParams(array(‘name’));

```
$sql = "SELECT * FROM wine WHERE id=$id";

try {
   $db = getConnection();
   $stmt = $db->prepare($sql);
   $stmt->bindParam("id", $id);
   $stmt->execute();
   $wines = $stmt->fetchAll(PDO::FETCH_OBJ);

```

if($wines) {  
#$wines1-\>response-\>setStatus(200);  
#$wines1-\>response()-\>headers-\>set(‘Content-Type’, ‘application/json’);  
echo json\_encode($wines);  
echo json\_encode(array(“status” =\> “success”, “code” =\> 1));  
$db = null;  
} else {  
throw new PDOException(‘No records found.’);  
}  
$db = null;  
##### echo '{“wine”: ’ . json\_encode($wines) . ‘}’;

```
} catch(PDOException $e) {
    echo '{"error":{"text":'. $e->getMessage() .'}}';
    debug_print_backtrace();
}

```

}

function getWines($request, $response, $args) {

```
$sql = "select * FROM wine ";
try {
    $db = getConnection();
$stmt = $db->prepare($sql);
$stmt->execute();
    $wines = $stmt->fetchAll(PDO::FETCH_OBJ);
    $db = null;
    echo '{"wine": ' . json_encode($wines) . '}';
} catch(PDOException $e) {
    echo '{"error":{"text":'. $e->getMessage() .'}}';
}

```

}

function addWine($request, $response, $args) {  
$value = json\_decode($request-\>getBody());

```
$sql = "INSERT INTO wine (name, grapes, country, region, year, description) VALUES (:name, :grapes, :country, :region, :year, :description)";
try {
    $db = getConnection();
    $stmt = $db->prepare($sql);
    $stmt->bindParam("name", $value->name);
    $stmt->bindParam("grapes", $value->grapes);
    $stmt->bindParam("country", $value->country);
    $stmt->bindParam("region", $value->region);
    $stmt->bindParam("year", $value->year);
    $stmt->bindParam("description", $value->description);
    $stmt->execute();
    //$wine->id = $db->lastInsertId();
    //$db = null;
    echo json_encode($value);
    $db = null;
} catch(PDOException $e) {
    echo '{"error":{"text":'. $e->getMessage() .'}}';
}

```

}

function search($request, $response, $args) {  
$value = json\_decode($request-\>getBody());

```
$sql= "select * from wine where country=:name";
try {
    $db = getConnection();
    $stmt = $db->prepare($sql);
    $stmt->bindParam("name", $value->country);
    $stmt->execute();
    $wines = $stmt->fetchAll(PDO::FETCH_OBJ);
    echo '{"wine": ' . json_encode($wines) . '}';
    $db = null;
} catch(PDOException $e) {
    echo '{"error":{"text":'. $e->getMessage() .'}}';
}

```

}

function updateWine($request, $response, $args) {  
$id=$args[‘id’];  
//echo “$id”;  
// $body = $request-\>getBody();  
// $wine = json\_decode($body);  
$value = json\_decode($request-\>getBody());  
#$data = $value-\>country;

```
  $sql = "UPDATE wine set name=:data WHERE id=$id";

```

// $sql = “select \* from wine where name=:data”;  
// $sql = “select \* from wine where name=‘piper’”;  
try {  
$db = getConnection();  
$stmt = $db-\>prepare($sql);  
$stmt-\>bindParam(“data”, $value-\>country);  
// $stmt-\>bindParam(“id”, $wine-\>id);  
$stmt-\>execute();  
// $wines = $stmt-\>fetchAll(PDO::FETCH\_OBJ);  
echo '{“wine”: ’ . json\_encode($value) . ‘}’;

```
    //$db = null;
    echo json_encode($value);
      $db = null;
} catch(PDOException $e) {
    echo '{"error":{"text":'. $e->getMessage() .'}}';
}

```

}

function deleteWine($request, $response, $args) {  
$id=$args[‘id’];

```
$sql = "DELETE FROM wine WHERE id=$id";
try {
    $db = getConnection();
    $stmt = $db->prepare($sql);
    $stmt->bindParam("id", $id);
    $stmt->execute();
    $app->response->setStatus(200);
$app->response()->headers->set('Content-Type', 'application/json');
    echo json_encode(array("status" => "success", "code" => 1));
    $db = null;
} catch(PDOException $e) {

```

$app-\>response()-\>setStatus(404);  
echo ‘{“error”:{“text”:’. $e-\>getMessage() .’}}’;  
}  
}

# function validation($parameters)

#{

# if ($\_SERVER[‘REQUEST\_METHOD’] == ‘PUT’) {

```
    //$app = \Slim\Slim::getInstance();

```

# parse\_str($app-\>request()-\>getBody(), $request\_params);

# }

#else if

#}

//function getConnection() {  
// $dbhost=“localhost”;  
// $dbuser=“root”;  
// $dbpass="";  
// $dbname=“api”;  
// $dbh = new PDO(“mysql:host=$dbhost;dbname=$dbname”, $dbuser, $dbpass);  
// $dbh-\>setAttribute(PDO::ATTR\_ERRMODE, PDO::ERRMODE\_EXCEPTION);  
// return $dbh;  
//}  
?\>

----------------------------------------------connection.php-------------------------

\<?php function getConnection() { $dbhost="localhost"; $dbuser="root"; $dbpass=""; $dbname="api"; $dbh = new PDO("mysql:host=$dbhost;dbname=$dbname", $dbuser, $dbpass); $dbh-\>setAttribute(PDO::ATTR\_ERRMODE, PDO::ERRMODE\_EXCEPTION); define('USER\_CREATED\_SUCCESSFULLY', 0); define('USER\_CREATE\_FAILED', 1); define('USER\_ALREADY\_EXISTED', 2); return $dbh; } ?\>

Regards  
Anupam