Posts by Emerson Matheus • 28 points
3 posts
-
0
votes1
answer44
viewsA: How do I delete and edit database data?
If you just want to delete and edit the user the commands are these: Erase: $statement = $connection->prepare('DELETE FROM users WHERE email = :email'); Edit: $statement =…
-
1
votes2
answers53
viewsQ: Select with LEFT JOIN and LIKE
Hello, I have created a search field, and I need to return the results of tb_orders based on the client’s name. However, only the client’s id is saved in this table, and the search is done by name.…
-
0
votes3
answers4076
viewsA: SELECT with PDO and variable
$teste = 'noticia tal'; $sqlNoticias = $pdo->prepare('SELECT * FROM noticias WHERE titulo LIKE :titulo'); $sqlNoticias->execute(array( ':titulo' =>…