The mysql tag has no wiki summary.
0
votes
0answers
23 views
User Authentication/Permissions for php MySQL CRUD [closed]
Just remembered CodeReview existed. I posted some code for review in the main forum but it may belong here. I dont want to double post so Ill link to it instead.
...
3
votes
1answer
13 views
User Authentication/Permissions for php MySQL CRUD
So I took my first stab at a user authentication function. I invented my own way of doing this. Is this a safe and efficient way of giving a user Read/Edit/Delete permission on tables in a MySQL ...
1
vote
0answers
30 views
TinyMVC Model / Plugin how to implement?
Recently I started working with TinyMVC, wrote a simple menu model and I have few questions for those who are using it... or used before.
For the following code should I keep it as Model or as a ...
1
vote
1answer
45 views
Return the ids of failed logins
I have a query to return the ids of failed logins that are newer than a supplied date, and new than the last successful login.
Table:
#######################################################
# ...
1
vote
1answer
38 views
Sorting with combobox
i need some help from you :)...when we select 'info' list in the combobox,automatically the article with type 'info' charateristic showed up, and when we select 'Berita' list in combobox,automatically ...
1
vote
2answers
71 views
Better way to Rewrite?
The output result is perfect to what I wanted, but takes a tad bit too long to pull data then render into a graph. Is there a better way to rewrite this code to speed up the process? I'm all ears ...
0
votes
1answer
41 views
displaying data from from many-to-many table
ok, I'm new with MySQL, and this is a simple exercise for practice, so please bare with me.
My goal is to display all posts with their categories underneath them. The code below accomplishes this, ...
2
votes
1answer
55 views
need help improving mysql and php filter code
I only recently started coding so I know my code is not very good, but i would really appreciate any help on improving my code.
my database table looks like this
game_id |title |developer ...
2
votes
2answers
83 views
PHP prepared statements
Is this correct coding for prepared statements in php. I've done some reading but the best way to learn is criticism from peers. Any suggestions to improve this code? Anything I've done wrong? Thanks ...
1
vote
2answers
122 views
How can make this MySQL SELECT query faster?
I have the following query which works as it should, but I'd like to know how I can make it run faster.
For info, tables cl, jo and mi all have column ref as the auto_inc primary key and ID as the ...
2
votes
1answer
221 views
Please review my database design for an online organization tool
The problem I'm trying to solve.
I'm a big fan of David Allen's Getting Things Done, but the myriad software tools and sites I've tried haven't impressed me that much. That's why I've decided to ...
2
votes
2answers
77 views
PHP-Mysqli example secure?
I'm just writing my first PHP-Mysqli sample (think about a Wiki 0.0.1) and I would like to ask you if this example is secure or not or if there are any other problems/suggestions you might recommend?
...
0
votes
1answer
57 views
How can I improve my search script? [closed]
I have this search script on my page which search through the displayed table. The table is displayed with PHP from a database. It is actually a list, and this list is sorted out alphabetically with ...
2
votes
1answer
78 views
I'm designing a DB for an online school. Am I on the Right Track?
Okay, so I'm a not-really-recent-anymore graduate of Michigan Tech. I've been a cook since graduation and I'm an eensie teensie bit rusty in pretty much all my learnin'. Couple weeks ago I got hired ...
4
votes
2answers
142 views
Am I on the right track? PHP/MySQL
I have the following table called info:
info_name | info_value
name | Susan
desc | Human
I'm trying to print Susan without knowing that the value is Susan.
The following ...
