1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

PHP Database GUI for displaying info

Discussion in 'Off Topic' started by Ryan Kent, Apr 28, 2011.

  1. Ryan Kent

    Ryan Kent Well-Known Member

    I need to make a page which displays information contained in a table within a database. This would be a simple "display-only" page. I do not need to every administrate the data or have users change data.

    I am an experienced database developer but I have never developed a web interface. In the past I used Excel and Access to display data. It took me a couple hours to realize I need PHP and not JS for this function :)

    An example of what I am trying to do is here: http://teracodex.com/database/

    User selects an item, then the database is queried and the results are shown. The results can be small images, URL links, and basic text info.

    Can anyone recommend a tool for performing this type of function?
     
  2. Ryan Kent

    Ryan Kent Well-Known Member

    wanted to ask again if anyone has any ideas here
     
  3. Jethro

    Jethro Well-Known Member

    Oracle how complex do you want the code, simple select all print? Also what language, can throw some php code your way, but you might prefer asp.net or asp?

    Okay this is a cut and paste from one of our scripts, for an upcoming product, warning is about 2 generations behind waht Kier and Mike are acheiving with xenForo, but might give you an idea of how to do it. Sure Brogan or someone else can hack it around about as haven't taken out our common routine calls etc.

    This is for a simple Country table with only a couple of fields.

    Code:
        function showall()
        {
            
            global $templates, $lib, $graphics, $admin_lang;
            
            include($lib."dbconfig.php");
            
            
            $q = "SELECT * FROM lb_country";
            
            $result = mysql_query($q);
            
            $num = mysql_num_rows($result);
            
            $heading = $admin_lang['ctycurrent'];
    
            $header_row[0] = $admin_lang['ctyid'];
            $header_row[1] = $admin_lang['ctyname'];
            $header_row[2] = $admin_lang['flag'];
            $header_row[3] = $admin_lang['oedit'];
            $header_row[4] = $admin_lang['odelete'];
            $header_num    = 4;
                    
            include($templates."admin_header_html.php");
            include($templates."admin_header_table.php");
            
            // Looping madness
            $i = 0; 
            $a = 1;
            $row_num = 4;
            
            while( $i < $num)
            {
                $country_id = mysql_result($result,$i,"cid");
                $row[0] = $country_id;
                $row[1] = mysql_result($result,$i,"cname");
                $flag   = $graphics."flags/".$country_id.".gif";
                $row[2] = "<img src='".$flag."' />";
                $row[3] = "<a href='admin_country.php?mod=edit&id=".$country_id."'>".$admin_lang['oedit']."</a>";
                $row[4] = "<a href='admin_country.php?mod=del&id=".$country_id."'>".$admin_lang['odelete']."</a>";
                
                if($a == 1)
                {
                    include($templates."admin_table_row.php");
                    $a = 0;
                } else {
                    include($templates."admin_table_row_alt.php");
                    $a = 1;
                }
                
                $i++;
            }
            
            mysql_close($connect);
            
            include($templates."admin_footer_table.php");
            include($templates."admin_footer_html.php");
            
             
            exit();
        }
    
     
  4. Ryan Kent

    Ryan Kent Well-Known Member

    The languages I have experience with are VB and SQL. If given the choice I would prefer to stay as close to languages already in use by XF so php would be my desire unless there was some code that was packaged together and solid.

    When I made this post I was thinking more of any software package that performed this function, but if your code will do it then that works too. I'll try to learn some php and see if I can't get it to work.

    Thanks for the help.
     
  5. Johnny Large

    Johnny Large New Member

  6. Ryan Kent

    Ryan Kent Well-Known Member

    ty Johnny, I'll check it out
     
  7. principia

    principia Well-Known Member

    Im using Php Maker. Really nice programm, but costs a lot of money.
    Creating databases is very easy and fast.
    try the Demo.
     

Share This Page