PDO prepared statements
Maintainers usually reply within 3 days
@astrophysik is already working on this.
Since Feb 22, 2023.
Assessment
This issue has not been assessed yet.
Description
In PHP there are prepared statements to speed up and simplify the work with PDO
Example:
$request = $db->prepare('SELECT * FROM issues WHERE likes < :likes AND author = :author');
$request->execute(['likes' => 100, 'author' => 'Einstein']);
$answers = $request->fetchAll();
This functionality should be added to KPHP because:
- It can protect code from SQL injections
- It helps speed up queries, since the database can parse the expression
- Dominant language
- C++
- Stars
- 1.5k
- Forks
- 116
- Avg merge
- 3d 23h
- Merged PRs (30d)
- 8
Getting set up
- Ships a Dockerfile or Docker Compose file
- No pull request template
- No contributing guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from VKCOM/kphp
-
SendOpen
Difficulty 5/5 Over a week Newbie friendliness 10/100
Maintainers usually reply within 3 days
-
TontontuOpen
Difficulty 5/5 Over a week Newbie friendliness 10/100
VKCOM/kphp#1698 · 2 comments ·
Maintainers usually reply within 3 days
-
Difficulty 5/5 Over a week Newbie friendliness 10/100
VKCOM/kphp#1656 · 3 comments · 4 reactions ·
Maintainers usually reply within 3 days
-
KhanOpen
Difficulty 5/5 Over a week Newbie friendliness 10/100
VKCOM/kphp#1655 · 2 reactions ·
Maintainers usually reply within 3 days
-
.github/CODEOWNERSOpen
Difficulty 3/5 1-2 days Newbie friendliness 25/100
VKCOM/kphp#1645 · 1 comment · 2 reactions ·
Maintainers usually reply within 3 days