DatabasePHPSnippets

Database-related PHP snippets

Issue 135016.

Two templates will be available under the Generate Code action (Alt+Insert):

Connect to Database...
Display Database Table...

The templates only work for MySQL connections. For other connections, the UI is disabled with a meaningful message (or non-MySQL connections are not displayed at all).

Connect to Database:

This template generates code to connect to a given database connection from in the DB Explorer. When invoked, the following dialog is displayed.

+-------------------------------------------------+
| Connect to Database                             |
+-------------------------------------------------+
|                                                 |
| Database Connection:                            |
| [[V| jdbc:mysql://localhost:3306/test           ]] |
|                                                 |
| Connection variable:                            |
| [Conn                ]                          |
|                                                 |
|                               [[OK  |  OK ]] [Cancel ] |
|                                                 |
+-------------------------------------------------+

Generated code:

$conn = mysqli_connect('localhost', 'user', 'password', 'database');
if (!$conn) {
    die('Could not connect to MySQL: ' . mysqli_connect_error());
}
mysqli_query($conn, 'SET NAMES \'UTF-8\'');
// TODO: Insert your code here.
mysqli_close($conn);            

Display Database Table:

This snippet generates code to display the data a HTML table. When invoked, the following dialog is displayed:

+-------------------------------------------------+
| Display Database Table                          |
+-------------------------------------------------+
|                                                 |
| Database Connection:                            |
| [[V| jdbc:mysql://localhost:3306/test           ]] |
|                                                 |
| Table:                                          |
| [[V|  CUSTOMER ]]                                  |
|                                                 |
| Columns:                                        |
| +---------------------------------------------+ |
| | [X] CUSTOMER_ID                             | |
| | [X] DISCOUNT_CODE                           | |
| | ...                                         | |
| +---------------------------------------------+ |
|                                                 |
| Connection variable:                            |
| [Conn                ]                          |
|                                                 |
|                               [[OK  |  OK ]] [Cancel ] |
|                                                 |
+-------------------------------------------------+

Generated code:

echo '<table>';
echo '<tr>';
echo '<th>CUSTOMER_ID</th>';
echo '<th>DISCOUNT_CODE</th>';
echo '</tr>';
$result = mysqli_query($conn, 'SELECT CUSTOMER_ID, DISCOUNT_CODE, ... FROM CUSTOMER');
while (($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) != NULL) {
    echo '<tr>';
    echo '<td>' . $row[CUSTOMER_ID] . '</td>';
    echo '<td>' . $row[DISCOUNT_CODE] . '</td>';
    echo '</tr>';
}
mysqli_free_result($result);
echo '</table>';
Not logged in. Log in, Register

By use of this website, you agree to the NetBeans Policies and Terms of Use. © 2012, Oracle Corporation and/or its affiliates. Sponsored by Oracle logo