News

Database

Cara memperbaiki Error establishing a database connection pada Wordpress

Minggu, 21 Oktober 2018
Anda punya situs website dar Wordpress dengan trafik tinggi ? dan tiba-tiba muncul Error establishing a database connection. Bingung cara memperbaikinya ? ini berarti ada kerusakan pada database Anda. Selain itu, Anda juga akan mendapat pesan One or more database tables are unavailable. The database may need to be repaired. Perlu diingat bahwa Anda hanya akan mendapat pesan ini di back-end dan Anda akan mendapat pesan error establishing a database connection di fron...

Cara menghapus Plugin WordPress lewat Database Phpmyadmin

Selasa, 25 Agustus 2015
Bagi anda pengguna wordpress yang mengalami masalah tidak bisa akses dashboard setelah menginstall suatu plugin, biasanya anda mencoba merename folder plugin yang ada di /wp-content/plugins/, tapi sayangnya tidak semua plugin dapat di nonaktifkan dengan trik tersebut, beberapa plugin seperti contohnya wp-super-cache atau plugin cache lainnya akan menambah pesan error lain jika di nonaktifkan dengan trik tersebut Solusinya anda dapat menonaktifkan plugin seperti itu melalui ph...

How to secure a database

Rabu, 12 Desember 2012
This practical, hands-on training and reference guide is perfect for developers who need to learn MySQL. Written by Joel Murach, the author of bestselling “Java Servlets and JSP” and “PHP and MySQL” books, this is exactly the database book that web developers should have on their desks. As you would expect, this book shows how to code all of the essential SQL statements for creating and working with a MySQL database. But beyond that, this book also sho...

Creating Automatic MySQL Database backups

Jum`at, 18 November 2011
Every database needs to be backed up and if you're currently doing it manually you can stop because there's a simple solution using PHP. With this script you can either pass a specific table to backup or choose to backup the whole database.How to implement The best way to use the script below is to copy the code and put it in a folder called ‘database_backups' as shown below. Then whenever you call the backup.php file it will create a database backup which is stored on ...

Use PHP Database Connectivity to connect MySQL

Kamis, 10 November 2011
PHP is an open-source server scripting language. It is typically used in conjunction with database systems such as MySQL, which provides the back-end database functionality for database-driven websites. MySQL is a free database application that is used extensively with PHP-based Web application systems. To connect to a MySQL database, you need to use the PHP Open Database Connectivity (ODBC) function "odbc_connect" within specific syntax.   1. Launch Microsoft Wind...
1 | 2 | Next »