Category Archives: MySql

TESTING APACHE PHP MYSQL SERVER ENVIRONMENT LESSON 2

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

INTERMEDIATE WEB DEVELOPMENT SET UP A SERVER LESSON 1

INTERMEDIATE WEB DEVELOPMENT SET UP A SERVER

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

Lost Password Script AJAX jQuery Bootstrap PHP and MySql

Lost Password Script AJAX jQuery Bootstrap PHP and MySql

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

Contact Form with AJAX jQuery Bootstrap PHP and MySql

Contact Form with AJAX jQuery Bootstrap PHP and MySql

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

Login Script with AJAX jQuery PHP and MySql

Login Script with AJAX jQuery PHP and MySql

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

SANITIZE STRINGS BEFORE INSERTING INTO DATABASE PHP MYSQL AJAX JQUERY

SANITIZE STRINGS BEFORE INSERTING INTO DATABASE PHP MYSQL AJAX JQUERY

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 Table At The Same Time With PHP

Create A Database and Table At The Same Time With PHP

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

How To Make A Free Website Backup PHP & MySql

How To Make A Free Website Backup PHP & MySql

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 Terminal MySql

Custom Column Output Names Terminal MySql

Custom column output names in terminal. SELECT [column] AS [custom-column] FROM [table]; Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408

Update Records In MySql Terminal

Update Records In MySql Terminal

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

Select With Custom Order Limit Terminal MySql

Select With Custom Order Limit Terminal MySql

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

Select A Range MySql Terminal

Select A Range MySql Terminal

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

Select Records Starting & Ending With Value MySql Terminal

Select Records Starting & Ending With Value MySql Terminal

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

Select Records Starting With A Value MySql Terminal

Select Records Starting With A Value MySql Terminal

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

Export A database Dump Terminal MySql

Export A database Dump Terminal MySql

To export a database use this command in terminal. mysqldump -u [username] -p [database] > db_backup.sql