After you have installed XAMPP then you will want to test that everything is working. In this tutorial we are going to make sure that we have everything working properly before we dive into the programming. You will also want to Read More
We have completed the Absolute Beginner Web Development Courses. It has help a lot of people with the basics of HTML, CSS and JavaScript. However when it comes to web development there are a couple more things that you need to know in order to grow your knowledge. It is Read More
This is a lost password script tutorial. It is written in AJAX, jQuery, Boostrap, PHP and MySql. Frequently people lose their passwords. Password reset scripts are almost mandatory with people expecting software to do everything for them. Writing Read More
In this tutorial we create a contact form that enters contact information into a database. It will then send an email to you from your website. We do this with AJAX, jQuery, Bootstrap, PHP and MySql. AJAX jQuery Functions Used * ready() function to check the Read More
Lets create a login script with AJAX jQuery, PHP and MySql in this tutorial. We will create a form to login to the system and use AJAX with jQuery for the process. Next we will use PHP to process the form and return data to the webpage without Read More
You need to sanitize your string before you insert them into your databases. We show you how to do that in this lesson with “FILTER_SANITIZE_STRING”, “FILTER_SANITIZE_EMAIL” and “FILTER_FLAG_STRIP_HIGH”. We use jQuery and AJAX to pass the variables to the processor. This lesson is a continuation of the last lesson Create Read More
Create a database and a table at the same time with php in mysql. All you will need is the connection information to your database. This is what you will need. Preliminary Information Needed * Connection to the host. For most Read More
This post covers how to make a free website backup. Once finished you will be able to download a complete website backup zip file. This Read More
Custom column output names in terminal. SELECT [column] AS [custom-column] FROM [table]; Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408
To update a record you can use this command. UPDATE [table] SET [column] = ‘[updated-value]’ WHERE [column] = [value]; Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408
To select with a customer order and limit the results use this command. SELECT * FROM [table] WHERE [column] ORDER BY [column] ASC LIMIT [value]; You can order by ascending. ASC Or you can order by descending. DESC Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408
To select a range use this code. Take out the brackets and replace the values. SELECT * FROM [table] WHERE [column] BETWEEN [value1] and [value2]; Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408
To find records that start and end with a certain value use this command. SELECT * FROM [table] WHERE [column] LIKE ‘[val_ue]’; Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408
To find something that starts with a certain string use this code. SELECT * FROM [table] WHERE [column] LIKE ‘[value]%’; Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408
To export a database use this command in terminal. mysqldump -u [username] -p [database] > db_backup.sql
