Search Results
Search type | Search syntax |
---|---|
Tags | [tag] |
Exact | "words here" |
Author |
user:1234 user:me (yours) |
Score |
score:3 (3+) score:0 (none) |
Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
Views | views:250 |
Code | code:"if (foo != bar)" |
Sections |
title:apples body:"apples oranges" |
URL | url:"*.example.com" |
Saves | in:saves |
Status |
closed:yes duplicate:no migrated:no wiki:no |
Types |
is:question is:answer |
Exclude |
-[tag] -apples |
For more details on advanced search visit our help page |
MySQL is an open-source, relational database management system. If your PHP code uses MySQLi, use the MySQLi tag instead.
3
votes
1
answer
411
views
blog RESTFUL api with posts and comments
I have a mysql database for the posts and comments which columns are the same as the model.
for the posts and comments there is a controller that manages all the HTTP methods with a repository object that … c.id = :id")
void addLike(@Param("id") Integer id);
@Modifying
@Query("UPDATE comment c SET dislikes = dislikes + 1 WHERE c.id = :id")
void addDislike(@Param("id") Integer id);
}
MySQL …
1
vote
4
answers
173
views
Is it good practice to have all my back end in one single file with all functions being static?
package LoginSystem;
import java.sql.Statement;
import java.sql.Timestamp;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
//dat …
1
vote
2
answers
65
views
backend Database authorization app using MySQL [V2]
the salt it is not the same if I remove the salt from the original)
so for now only SHA-256.
what my code tries to achieve
I tried building a backed with a connection to a Database in my case I used MySQL … I have a constructor that creates a connection to my database once and each file that needs access to the backend creates an instance of it.
the columns in MySQL table are as follows in the same order: …
-1
votes
1
answer
228
views
is my code protected against SQL injections?
id) throws Exception {
repository.addDislike();
return 1;
}
}
and for the repository I have the PostRepository interface extending CrudRepository to query my data base (which is MySql …