Author Archive

How to convert MySQL to MySQLi procedural methods

These are nothing but the APIs of PHP that is used to access the MySQL databases and tables. The developers can choose either one of them for their project, however, the use of MySQL extension is deprecated and will not be available in future versions. It is recommended to use the MySQLi extension with PHP 5.5 and above.

Let’s have some more information about each of them:

MySQL: This was the main extension that was designed to help PHP applications send and receive data from the MySQL database. However, the use of MySQL has been deprecated and removed as of PHP 7 and its newer versions. This is why it is not recommended for new projects, and that’s the reason why MySQLi extensions are used more nowadays.
MySQLi: The ‘i’ in MySQLi stands for Improved. Therefore, this is also known as the improved version of MySQL. It has many useful features.

  • An Object-oriented interface
  • Support for prepared statements
  • Support for multiple statements
  • Support for transactions
  • Enhanced debugging capabilities
  • Embedded server support.

Read more »

Create a shortcut to open an FTP site in Windows Explorer

  1. Open My Computer by clicking the Start button, and then clicking Computer.

  2. Right-click anywhere in the folder, and then click Add a Network Location.

  3. This displays the Add Network Connection wizard. Click Next.

  4. In the wizard, select Choose a custom network location, and then click Next.

  5. Enter the name of the FTP site, with the full FTP:// in front of it, and then click Next.

  6. To use a name and password, clear the Log on anonymously check box. Type a user name, and then click Next.

  7. By default, the name of the shortcut is the same as the FTP address. If you want to give the shortcut a different name, type it in the Type a name for this network location box. Click Next.

  8. If you do not want the FTP site to open after you're done setting up the shortcut, clear the Open this network location when I click Finish check box. Click Finish. A shortcut to the FTP site appears in the Computer folder. You can drag that shortcut to your desktop so that it's easy to find later.

Read more »

DROP multiple TABLE / TRIGGER / FUNCTON in oracle using PL SQL

To drop more than one tables having a matching criteria then we should use a PL SQL statement, in oracle there is a table called USER_OBJECTS having name of all the tables for that particular user.

DROP TABLE is a DDL statement so that we need EXECUTE IMMEDIATE privilege for dropping table from a script, more easy way to drop table is to generate DROP TABLE command using a script and run that command.

The following PL SQL script generate drop table command for all tables having table name contains  word 'test'

SET SERVEROUTPUT ON;

DECLARE
  object_name varchar2(100);
  cursor cur1 is SELECT object_name FROM user_objects WHERE object_type='TABLE' AND object_name LIKE '%test%';
BEGIN

  open cur1;
  loop
        fetch cur1 into object_name;
        exit when cur1%notfound;
      dbms_output.put_line('DROP TABLE ' || object_name || ';' );
    end loop;
    close cur1;

END ;

Output

anonymous block completed

DROP TABLE USER_TEST;

Read more »