4
votes
1answer
3k views

MySQL data fetching without page refresh

I've recently finished a prototype for a little Raspberry Pi website. The main page of the site displays current users found in the room (through bluetooth). I wanted this list updated regularly from ...
4
votes
1answer
185 views

Database syncing playback of videos

I made a website last night that allows people to sync HTML5 <video>s (playing/pausing). The way it does this is by using Ajax to run a MySQL query every 2 ...
3
votes
2answers
333 views

Is my login system secure?

I am recently making a CMS and I need a secure login system, so this is my code. How is it? First: the HTMLcode for signup and login: ...
7
votes
2answers
174 views

Student status form

I'm programming a system and I want to know if this is the correct way or if there is a better way to do it. Container: I have more fields but I only added one to show you the container. ...
4
votes
1answer
462 views

Random select in two MySQL tables

I wrote a simple AJAX request that performs a random select in two MySQL tables. My current script involves connecting to the database and creating a new PDO every time the ...
3
votes
1answer
10k 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! Let ...
5
votes
1answer
1k 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
1k 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: ...
2
votes
1answer
641 views

Managing a user database

In my system there are 3 main functionalities: 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, a ...
2
votes
1answer
126 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
1k 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 ...
3
votes
3answers
1k 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. ...
-1
votes
1answer
133 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 ...