Thursday, August 21, 2014

Installing phpmyadmin for Developers

Before installing phpMyAdmin, you should have already installed a webserver. Apache or IIS are solid options.
Step 1:
     Install php with MySQL support
If you haven't done this already, you can download phpMyAdmin here.
Step 2:
     If your webserver is Apache, first unpack file like so: phpMyAdmin-x.y.z.zip under C:\apache\htdocs\ Rename the directory.
Again, if you were using Apache, you might do this: C:\apache\htdocs\phpMyAdmin-x.y.z to C:\apache\htdocs\phpMyAdmin
Step 3:
     Rename the config
Apache example: C:\apache\htdocs\phpMyAdmin\config.sample.inc.php to 'config.inc.php'
For a single-user (root or trusted) environment, update config.inc.php as:
$cfg['Server'][$i]['auth_type'] ='config';
$cfg['Server'][$i]['user'] = 'root';
$cfg['Server'][$i]['password'] = 'root-password';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = true;
Step 4 :
     Access myphpadmin
If access is performed from localhost, use -> http://localhost/phpMyAdmin/
If access is not performed from localhost, use -> http://[URL of the website]/phpMyAdmin/

Auto Complete issue in Chrome’s Devel tool console

The Chrome Dev tools provide a lot of functionality to developer when making changes to scripts. Best features of editing CSS is the auto-complete that allows you to quickly add style elements. Begin typing and Chrome will provide a list of CSS properties, arrow keys used to select an item, hit tab and you'll then be able to set the value. When setting a value hit ctrl+space and you'll get a list of values appropriate for the property.

Friday, July 18, 2014

Description of our project

We are going to develop auto complete enabled SQL Query editor based on codemirror and Chrome Devel tool ,We should make a autocomplete part like chrome's developer console .Databases, tables, columns (Just the names) must stored temporally when SQL editor is open because making request for every suggestion is not good for quick suggestion and for the developers it will not help if it have a delay , After the successful execution of a SQL query we can wipe the temporary memory .