Use this to create a slug from a string field.
Pinakin Patel
PHP Web Developer
updating custom field values in mailwizz using direct SQL
In mailwizz you can create custom fields which get assigned a field_id in the database table. So in my case the customer field is called rank and the field_id = 24.
Format Telephone numbers into US format in MySQL
if you have a telephone field in a table where numbers have been entered in the format 1234567890 then use this to format it as 123-456-7890
Driving School Price Comparison using wpDataTables
How to create a searchable and sortable data...
Resetting your wordpress password using SQL
https://www.domain.com/help/article/wordpress-how-to-change-or-reset-your-admin-passwordhttps://www.domain.com/help/article/wordpress-how-...
Massing deleting customers except admins in x-cart for for a test server
When creating a test store for developers to work on you should clean down any customer data for privacy
Sorting products so out of stock appear at the bottom in X-Cart 4
These instructions are for sorting products in...
How to reset a wordpress admin password when you server will not send out the password reset email
Need to reset the admin password on wordpress directly in SQL?
How to Import a .sql file using terminal
How to import a .sql file using terminal. You mush have the database username, password and database name at hand
How to export a mysql database using terminal and zip at the same time
Sometimes a database is just too big for phpMyadmin to export so you need to be able to export the database to a .sql file and maybe zipped too.
How to change WordPress URLs in MySQL Database
Here is how to replace the old url in wordpress
How to find the menu data in the wordpress database
Sometimes you just need to update the menu...