Click here to Skip to main content
15,352,465 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have an html table and submit button that sends the tabledata with a GET to another file. My co-worker has created an OO php class that connects to the DB and has several functions that already writes or reads from the MS SQL DB.

I'm a little confused about the best way to go from my php file with the GET to the OO php class so I can use his functionality with the DB write. Should I stick the GET data (in visEupload.php) in an array and send it as a parameter to the StoreViseData function from there? What's the best way to intercept the GET data in visEupload.php without handling the pieces before I send them as a parameter to StoreViseData()? The GET data will be over 50 data pieces long eventually.

Most of our php in production is not OO.

I have been referring to this link:[^]

This is an excerpt from the BigTable.php (which is just html right now):

    <h1> Visual Evaluation Entry Table </h1>
    <form method="get" action="visEupload.php">
<table id="bigTable" border="1">
       <th id="bandY" class="col3">Bands @263mm Y</th><th id="bandM" class="col3">Bands @263mm M</th><th id="bandC" class="col3">Bands @263mm C</th><th id="bandK" class="col3">Bands @263mm K</th><th id="Comments" class="col3">Comments</th>
        <tr >
            <td><input name="bandY" ></td> <!-- //Row 0 Column 1-->
            <td><input name="bandM" ></td>  <!--//Row 0 Column 2-->
            <td><input name="bandC" ></td>  <!--//Row 0 Column 3-->
            <td><input name="bandK" ></td>  <!--//Row 0 Column 4-->
            <td><input name="comment" ></td>  <!--//Row 0 Column 4-->

  <input id="submit" type="submit" class="list" name="submit" value="Submit To Database" >


This is an excerpt from the visEupload.php where I have the GET, and intend to access the OLAP Database class. I'm not sure the best way to send the data to the $OLAPdb class/function:



    require_once( "../classes/class.OLAPdatabase.php");
    require_once( "../common/Session.php");
    $OLAPdb = new OLAPdatabase;

    if (isset($_GET['submit'])){
        $bandY= $_GET['bandY'];
        $bandM= $_GET['bandM'];
        $bandC= $_GET['bandC'];
        $bandK= $_GET['bandK'];


        $OLAPdb->StoreViseData(); //I'm not sure how to send GET data up here so I can process the data later in the OLAPdb class instead.
Updated 17-Jun-14 10:20am
Mohibur Rashid 17-Jun-14 20:17pm
You are lack of basic php programming knowledge.
MichCl 18-Jun-14 8:10am
Thank you that was very helpful

1 solution

You can pass the get parameters to the relevant methods of a class object through method arguments. Learn OOP PHP
MichCl 18-Jun-14 9:27am
It seems like there should be a good php way to do it using the php arrays and such that are used with GET. I found this example, but it's not making use of the php workings behind the scenes, so to speak.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900