API tools faq
paste
Advertisement
devbenjamin

dbconn.php

devbenjamin
Feb 29th, 2016
412
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 7.02 KB | None | 0 0
raw download clone embed print report
  1. <html>
  2. <head>
  3.     <title>test</title>
  4.     <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.11/css/jquery.dataTables.min.css"/>
  5.     <script type="text/javascript" src="https://code.jquery.com/jquery-1.12.0.min.js"></script>
  6.     <script type="text/javascript" src="https://cdn.datatables.net/1.10.11/js/jquery.dataTables.min.js"></script>
  7.     <script type="text/javascript" src="app.js"></script>
  8. </head>
  9. <body>
  10.     <p>Search</p>
  11.     <form action="dbconn.php" method="post">
  12.         Everywhere: <input type="text" name="global"><br>
  13.         <input type="radio" name="area" value="country" checked>: Country<br>
  14.         <input type="radio" name="area" value="first_name">: First Name<br>
  15.         <input type="radio" name="area" value="last_name">: Last Name<br>
  16.         <input type="radio" name="area" value="city">: City<br>
  17.         <input type="submit" name="submit">
  18.     </form>
  19.     <table id="example" class="display" cellspacing="0" width="100%">
  20.         <thead>
  21.             <tr>
  22.                 <th>CUS_MDM_ID</th>
  23.                 <th>CUS_FIRST_NAME</th>
  24.                 <th>CUS_LAST_NAME</th>
  25.                 <th>CUS_FULL_NAME</th>
  26.                 <th>CUSA_ADDRESS_LINE_1</th>
  27.                 <th>CUSA_CITY_NAME</th>
  28.                 <th>CUSA_COUNTRY</th>
  29.             </tr>
  30.         </thead>
  31.         <tfoot>
  32.             <tr>
  33.                 <th>CUS_MDM_ID</th>
  34.                 <th>CUS_FIRST_NAME</th>
  35.                 <th>CUS_LAST_NAME</th>
  36.                 <th>CUS_FULL_NAME</th>
  37.                 <th>CUSA_ADDRESS_LINE_1</th>
  38.                 <th>CUSA_CITY_NAME</th>
  39.                 <th>CUSA_COUNTRY</th>
  40.             </tr>
  41.         </tfoot>
  42.         <?php
  43.         $conn = oci_connect('user', 'pass', 'server', 'AL32UTF8');
  44.         if (!$conn) {
  45.             $e = oci_error();
  46.             trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
  47.         }
  48.         //if the form was submitted
  49.         if (isset($_POST['submit'])) {
  50.  
  51.             if($_POST['global'] != "") {
  52.  
  53.                 if($_POST['area'] != "") {
  54.                     //search in country if countr ywas selected
  55.                     if ($_POST['area'] == "country") {
  56.                         echo "country was selected, search in country";
  57.                         $stid = oci_parse($conn,'select HCP.CUS_MDM_ID, HCP.CUS_FIRST_NAME, HCP.CUS_LAST_NAME, HCP.CUS_FULL_NAME, ADR.CUSA_ADDRESS_LINE_1,
  58.                        ADR.CUSA_CITY_NAME, ADR.CUSA_COUNTRY from MDM_CUSTOMER HCP,MDM_CUSTOMER_ADDRESSES ADR where HCP.CUS_MDM_ID = ADR.CUSA_MDM_ID and (
  59.                            (lower(ADR.CUSA_COUNTRY) LIKE lower(\'%'.$_POST['global'].'%\'))
  60.                            )');
  61.                         oci_execute($stid);
  62.                     } else if ($_POST['area'] == "first_name") {
  63.                         $stid = oci_parse($conn,'select HCP.CUS_MDM_ID, HCP.CUS_FIRST_NAME, HCP.CUS_LAST_NAME, HCP.CUS_FULL_NAME, ADR.CUSA_ADDRESS_LINE_1,
  64.                        ADR.CUSA_CITY_NAME, ADR.CUSA_COUNTRY from MDM_CUSTOMER HCP,MDM_CUSTOMER_ADDRESSES ADR where HCP.CUS_MDM_ID = ADR.CUSA_MDM_ID and (
  65.                            (lower(HCP.CUS_FIRST_NAME) like lower(\'%'.$_POST['global'] .'%\'))
  66.                            )');
  67.                         oci_execute($stid);
  68.                     } else if ($_POST['area'] == "last_name") {
  69.                         $stid = oci_parse($conn,'select HCP.CUS_MDM_ID, HCP.CUS_FIRST_NAME, HCP.CUS_LAST_NAME, HCP.CUS_FULL_NAME, ADR.CUSA_ADDRESS_LINE_1,
  70.                        ADR.CUSA_CITY_NAME, ADR.CUSA_COUNTRY from MDM_CUSTOMER HCP,MDM_CUSTOMER_ADDRESSES ADR where HCP.CUS_MDM_ID = ADR.CUSA_MDM_ID and (
  71.                            (lower(HCP.CUS_LAST_NAME) like lower(\'%'.$_POST['global'] .'%\'))
  72.                            )');
  73.                         oci_execute($stid);
  74.                     } else if ($_POST['area'] == "city") {
  75.                         $stid = oci_parse($conn,'select HCP.CUS_MDM_ID, HCP.CUS_FIRST_NAME, HCP.CUS_LAST_NAME, HCP.CUS_FULL_NAME, ADR.CUSA_ADDRESS_LINE_1,
  76.                        ADR.CUSA_CITY_NAME, ADR.CUSA_COUNTRY from MDM_CUSTOMER HCP,MDM_CUSTOMER_ADDRESSES ADR where HCP.CUS_MDM_ID = ADR.CUSA_MDM_ID and (
  77.                            (lower(ADR.CUSA_CITY_NAME) like lower(\'%'.$_POST['global'] .'%\'))
  78.                            )');
  79.                         oci_execute($stid);
  80.                     } else
  81.                         echo "failed --------";
  82.                 }
  83.  
  84.                 // if(is_numeric($_POST['global'])){
  85.  
  86.                 //     $stid = oci_parse($conn,'select HCP.CUS_MDM_ID, HCP.CUS_FIRST_NAME, HCP.CUS_LAST_NAME, HCP.CUS_FULL_NAME, ADR.CUSA_ADDRESS_LINE_1,
  87.                 //         ADR.CUSA_CITY_NAME, ADR.CUSA_COUNTRY from MDM_CUSTOMER HCP,MDM_CUSTOMER_ADDRESSES ADR where HCP.CUS_MDM_ID = ADR.CUSA_MDM_ID and
  88.                 //         HCP.CUS_MDM_ID = '.$_POST['global']);
  89.                 //     oci_execute($stid);
  90.                 // } else {
  91.                 //     $stid = oci_parse($conn,'select HCP.CUS_MDM_ID, HCP.CUS_FIRST_NAME, HCP.CUS_LAST_NAME, HCP.CUS_FULL_NAME, ADR.CUSA_ADDRESS_LINE_1,
  92.                 //         ADR.CUSA_CITY_NAME, ADR.CUSA_COUNTRY from MDM_CUSTOMER HCP,MDM_CUSTOMER_ADDRESSES ADR where HCP.CUS_MDM_ID = ADR.CUSA_MDM_ID and (
  93.                 //             (lower(HCP.CUS_FIRST_NAME) like lower(\'%'.$_POST['global'] .'%\'))
  94.                 //             or (lower(HCP.CUS_LAST_NAME) LIKE lower(\'%'.$_POST['global'].'%\'))
  95.                 //             or (lower(HCP.CUS_FULL_NAME) LIKE lower(\'%'.$_POST['global'].'%\'))
  96.                 //             or (lower(ADR.CUSA_ADDRESS_LINE_1) LIKE lower(\'%'.$_POST['global'].'%\'))
  97.                 //             or (lower(ADR.CUSA_CITY_NAME) LIKE lower(\'%'.$_POST['global'].'%\'))
  98.                 //             or (lower(ADR.CUSA_COUNTRY) LIKE lower(\'%'.$_POST['global'].'%\'))
  99.                 //             )');
  100.                 //     oci_execute($stid);
  101.                 // }
  102.             }
  103.  
  104.             while ($row = oci_fetch_array($stid, OCI_ASSOC+OCI_RETURN_NULLS)) {
  105.                 echo "</thead>\n<tr>\n";
  106.                 foreach ($row as $item) {
  107.                     echo "    <td>" . ($item !== null ? htmlentities($item, ENT_QUOTES) : "&nbsp;") . "</td>\n";
  108.                 }
  109.                 echo "</tr>\n</thead>\n";
  110.             }
  111.  
  112.         } else { $stid = oci_parse($conn, 'select HCP.CUS_MDM_ID, HCP.CUS_FIRST_NAME, HCP.CUS_LAST_NAME, HCP.CUS_FULL_NAME, ADR.CUSA_ADDRESS_LINE_1,
  113.            ADR.CUSA_CITY_NAME, ADR.CUSA_COUNTRY from MDM_CUSTOMER HCP,MDM_CUSTOMER_ADDRESSES ADR where HCP.CUS_MDM_ID = ADR.CUSA_MDM_ID and rownum <= 500');
  114.         oci_execute($stid);
  115.  
  116.         while ($row = oci_fetch_array($stid, OCI_ASSOC+OCI_RETURN_NULLS)) {
  117.             echo "</thead>\n<tr>\n";
  118.             foreach ($row as $item) {
  119.                 echo "    <td>" . ($item !== null ? htmlentities($item, ENT_QUOTES) : "&nbsp;") . "</td>\n";
  120.             }
  121.             echo "</tr>\n</thead>\n";
  122.         }
  123.     }
  124.     echo "</table>\n";
  125.  
  126.     ?>
  127. </body>
  128. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!