hey i get this error message SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 how do i fix it, which page you got this error message, show your codes because all codes are perfectly worked, I started coding ...but stuck. After that, the variables are declared and an error array is created. The JSP is... Today I create an easy tutorial using Ajax in JSP which is jQuery onchange select option value. how we can try it if there isn't link to download it even we can't copy it from the page !! How to redirect a user to the registration if he has not logged in? Check your login codes all accessories like button name attribute click event, text box name attribute, select query, folder path location etc. ; Use a SQL INSERT statement to insert the data into the table. otherwise, the required message will be displayed. 14:16. How to pop an alert message box using PHP ? Adding Product After Login Into Cart. The data type for username, email and password will be varchar. Then at that time chances of SQL Injection will increase. At the point the user logs in, put his username in the session. close, link This is the user dashboard code. In this file, along with click logout hyperlink, we destroy the session from the whole role's account and send it all to the index/login page. This video will show you how to make a web server response according to user request for your social network web application. 18:18. 3. I have already inserted admin dumping records in a table here. How to Upload Image into Database and Display it using PHP ? And only the admin can access and delete some users in the system. These Codes Paste before form tag all error messages are displaying perfectly.prepare('SELECT userprofile FROM users WHERE userid =:uid'); $stmt_select->execute(array(':uid' =>$_GET['delete_id'])); $imgRow=$stmt_select->fetch(PDO::FETCH_ASSOC); unlink("user_images/".$imgRow['userprofile']); $stmt_delete = $DB_con->prepare('DELETE FROM users WHERE userid =:uid'); It will handle the registration process along with suitable validation. There are other cases you'll... Hi coder, In this tutorial, you will see how to get all the value of the multiple selected checkbox in Servlet. How to change the Content of a