mysql

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 scripts that lets people reset their passwords do pose some risks. Are they using a secure email Read More

Cool People Share:

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 readiness of the DOM {Document Object Model} click() function to Read More

Cool People Share:

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 reloading. Then we will set session variables Read More

Cool People Share:

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 Secure Password Sign Up Script With Read More

Cool People Share:

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 Please like, share and subscribe. Advanced Programming Made EasyI hope you enjoyed the article. If I was able to help you please consider a tip for the content. One Time Tip more tips $5 Tip $5.00 USD $10 Tip Read More

Cool People Share:

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 Please like, share and subscribe. Advanced Programming Made EasyI hope you enjoyed the article. If I was able to help you please consider a tip for the content. One Time Tip more Read More

Cool People Share:

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 Please like, share and subscribe. Advanced Programming Made EasyI hope you enjoyed the Read More

Cool People Share:

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 Please like, share and subscribe. Advanced Programming Made EasyI hope you enjoyed the article. If I was able to help you please consider a tip for the Read More

Cool People Share:

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 Please like, share and subscribe. Advanced Programming Made EasyI hope you enjoyed the article. If I was able to help you please consider a tip for the content. One Time Read More

Cool People Share:

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 Please like, share and subscribe. Advanced Programming Made EasyI hope you enjoyed the article. If I was able to help you please consider a tip for the content. One Time Tip Read More

Cool People Share:

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 Please like, share and subscribe. Advanced Programming Made EasyI hope you enjoyed the article. If I was able to help you please consider a tip for the content. One Time Tip more tips $5 Tip $5.00 USD $10 Tip Read More

Cool People Share:

Import A Database Dump MySql Terminal

Import A database Dump Terminal MySql

To import a database dump use this command. mysql -u [username] -p -h localhost [database] < db_backup.sql Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408 Please like, share and subscribe. Advanced Programming Made EasyI hope you enjoyed the article. If I was able to help you please consider a tip for the content. One Time Tip more tips $5 Read More

Cool People Share:

Delete Records MySql Terminal Command

Delete Records MySql Terminal Command

To delete records in mysql use this terminal command. DELETE FROM [table] WHERE [column] = [value]; Delete all records without dropping the table. This will also reset the increment number value. DELETE FROM [table]; Delete all records in a table. truncate table [table]; Remove table columns. ALTER TABLE [table] DROP COLUMN [column]; Deleting tables. DROP TABLE Read More

Cool People Share:

Select Records Containing Terminal MySql

Select Records Containing Terminal MySql

To find records containing something use this command. SELECT * FROM [table] WHERE [column] LIKE ‘%[value]%’; Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408 Please like, share and subscribe. Advanced Programming Made EasyI hope you enjoyed the article. If I was able to help you please consider a tip for the content. One Time Tip more tips $5 Tip $5.00 Read More

Cool People Share:

Selecting Specific Records MySql Terminal Command

Selecting Specific Records MySql Terminal Command

To select specific records in terminal use this code. SELECT * FROM [table] WHERE [column] = [value]; You can also use these selectors. Less Than < Greater Than > Not Equal To != And and Or or Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408 Please like, share and subscribe. Advanced Programming Made EasyI hope you enjoyed the article. If Read More

Cool People Share: