Search Results for "sql dump viewer"

Run sql dump in your Mysql server, then Put the codes in your server. This webservice always gives JSON output. This project is created for who wants to learn basic PHP webservice. So it is for PHP beginners. We have just one table whose name is "users". Here is its sql: CREATE TABLE IF NOT EXISTS `users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `unique_id` varchar(64) CHARACTER SET utf8 NOT NULL, `name` varchar(50) CHARACTER SET utf8 NOT NULL, `email` varchar(100) CHARACTER SET utf8 NOT NULL, `encrypted_password` varchar(64) CHARACTER SET utf8 NOT NULL, `salt` varchar(16) CHARACTER SET utf8 NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; You can add/login a user with using GET or POST. ...

It can support a small clinic or hospital in managing patient personal, medical, and billing records through an easy to use Swing user interface. How to install: i. Simply import the database dump from the database folder to create the necessary tables for the system to run. You can use either phpMyAdmin for localhost; Microsoft SQL Server; or simply Query Browser for MySQL. Other database environments have not been tested hence I don't guarantee their adaptability. ii. Run and Build the system in NetBeans IDE 7.0. Other IDEs have not been tested for this system. ...