) ENGINE= InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci Database Configuration (dbConfig.php) `status` tinyint( 1) NOT NULL DEFAULT 1 COMMENT '1=Active | 0=Inactive', `country` varchar( 20) COLLATE utf8_unicode_ci NOT NULL, `gender` enum( 'Male', 'Female') COLLATE utf8_unicode_ci NOT NULL, `email` varchar( 50) COLLATE utf8_unicode_ci NOT NULL, `last_name` varchar( 25) COLLATE utf8_unicode_ci NOT NULL, `first_name` varchar( 25) COLLATE utf8_unicode_ci NOT NULL, The following SQL creates a members table with some basic fields in the MySQL database. To store the data, a table needs to be created in the database. Export MySQL data and download it in a CSV file using PHP.
0 Comments
Leave a Reply. |