问如何在我的数据库中查找@img::value

EN

$string = '@img::56';

// Explode the string as the delimiter.
$components = explode('::', $string);

// Ensure the components array has two elements.
if(count($components) < 2) {

   // Do something here to indicate an error has occurred. 
   //Throw an exception (preferred) or emit an error

}

$id = $components[1];

// You can use even more type checking here to ensure you have the right piece of data.
if(!ctype_digit($id)) {

    //Throw an exception (preferred) or emit an error

}

// Accessing the database using a PDO object and prepared statements

$pdo = new \PDO('mysql:host=...', 'username', 'password')

$statement = $pdo->prepare('SELECT * FROM tblgallary WHERE g_id = :id');

$statement->bindParam(':id', $id, \PDO::PARAM_INT);

if(!$statement->execute()) {

    //Throw an exception (preferred) or emit an error

}

$result = $statement->fetchAll(\PDO::FETCH_ASSOC);

// End the database connection
$pdo = null;