3
votes
1answer
126 views

Update database, reload page then show a success message

I have spent a long time trying to find a way to do the following: Update a MySQL database with AJAX Reload the Page to show changes Show a success message I think I have finally found a way! ...
4
votes
1answer
240 views

PDO prepared statement - binding variable number of values

Please let me know if I have over/under explained my question :) HTML table row - the numerals from each id attribute, in this example "408" and "409", are the database tables primary ID numbers, one ...
3
votes
1answer
114 views

Dynamically-loading interactive table

I've got a page on a website that shows a table, and upon clicking on a row in the table, it can dynamically load in more results. I am new to jQuery though. index.php page: ...
4
votes
0answers
157 views

How can I optimize this query to improve performance? [closed]

I'm building a wordpress website using advanced custom fields and the repeater plugin. I've managed to put this query together after re-organizing my data using the repeater plugin. The query below ...
2
votes
1answer
329 views

How should I re-factor this code?

In my system there are 3 main functionalists. Add users to database Delete users from database Updater users This is the screenshot in my UI When clicking on the button of add new user, ...
2
votes
1answer
88 views

I've embedded several PHP/HTML/Javascript in one page. How can I improve on the efficiency/performance?

Just a quick preface, I'm not a web developer. I'm simply doing this as a favor for a friend. My goal is to be done with it as quickly as possible, but still not have the coding be horrendous. With ...
0
votes
1answer
452 views

Authentication system using AJAX

I'm building an authentication system using a combination of PHP, MySQL, jQuery, and AJAX. The way I'm doing it right now is I have a form that takes in a username and password. When the user clicks ...
2
votes
3answers
615 views

CodeIgniter AJAX messages submission security issue

I have a small social networking site built in CodeIgniter. Any registered user can send messages to others by visiting their profile. Today I noticed that one user sent bulk messages to 200 users. ...
0
votes
1answer
94 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 ...