Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Page 4 of 4 FirstFirst ... 2 3 4
Results 31 to 34 of 34
  1. #31
    Junior Member
    Join Date
    Aug 2011
    Location
    England
    Posts
    16
    Member #
    29107
    Quote Originally Posted by mlseim, post: 218259
    OK, so now someone (like me) will have to know more information about that database.
    Can you cut and paste some lines of what you see? Especially from a page (or script) that
    displays the products.

    Copy paste some lines from:
    pdb_show_menu.php
    pdb_search.php

    I'm especially looking for lines that have things that look similar to this,
    but in this example, I'm making-up some variable names ...

    $query="SELECT * FROM mytable WHERE catalog='furniture'";

    The point of this is ... if I can determine the name of your database table, and some column names,
    I might be able to whip-up an XML sitemap generator.

    Also, at the top of those scripts, there should be some coding that describes "connecting" to the database.
    Copy those lines too, but if there are any passwords shown, XXX them out before posting it.

    .
    ok, I found this:

    "shop/pdb_search.php" style="margin:0; display:inline;">
    <input type="hidden" name="start_row" value="0" />
    <table border="0" cellpadding="0" cellspacing="0">
    <tr><td width="8" class="tabmenucell">&nbsp;</td>
    <td class="tabmenucell"><a href="shop/pdb_show_menu.php" >Enter Shop</a></td>
    <td width="16" class="tabmenucell">&nbsp;</td>
    <td class="tabmenucell"><a href="shop/pdb_search.php

    And this:
    "<h4>Ordered items</h4>" ;
    $query = "select pdb_basket.prod_id as prod_id, prod_name, pdb_basket.prod_price, item_num, prod_qty, " .
    "prod_qtyflg, prod_opt_type, prod_opt_val " .
    "from pdb_products, pdb_basket where basket_id = '$basket_id' and pdb_products.prod_id = pdb_basket.prod_id " .
    "order by item_num, prod_opt_type ;" ;
    $resultid = db_query($query, $chan) ;
    if(mysql_num_rows($resultid) > 0)

    and this:
    $query = "select opt_name, text from pdb_prod_opts, pdb_optiontypes, pdb_optionvalues " .
    "where parent_prod = '$prod_id' and pdb_optiontypes.opt_type = '$prod_opt_type' and opt_value = '$prod_opt_value' " .
    "and pdb_optiontypes.opt_type = '$prod_opt_type' " .

    Does any of that help? It's like looking at Chinese for me...

  2.  

  3. #32
    WDF Staff mlseim's Avatar
    Join Date
    Apr 2004
    Location
    Cottage Grove, Minnesota
    Posts
    7,720
    Member #
    5580
    Liked
    718 times
    OK ...
    Now at the very top of the file called "pdb_show.php", there will be a section of code
    that talks about "connecting" or "include" to the database.

    Or, better yet, use the private conversation feature to show me your code.

    Click on my "cat logo", and select the "start a conversation" link in the pop-up box.
    Paste your entire "pdb_show.php" file in there so I can see it privately.

    .


  4. #33
    Junior Member
    Join Date
    Aug 2011
    Location
    England
    Posts
    16
    Member #
    29107
    Quote Originally Posted by mlseim, post: 218287
    OK ...
    Now at the very top of the file called "pdb_show.php", there will be a section of code
    that talks about "connecting" or "include" to the database.

    Or, better yet, use the private conversation feature to show me your code.

    Click on my "cat logo", and select the "start a conversation" link in the pop-up box.
    Paste your entire "pdb_show.php" file in there so I can see it privately.

    .
    Would the file " pdb_show.inc.php " be ok? It's the only one I can find that's similar and that ends in php.

  5. #34
    WDF Staff mlseim's Avatar
    Join Date
    Apr 2004
    Location
    Cottage Grove, Minnesota
    Posts
    7,720
    Member #
    5580
    Liked
    718 times
    Yeah ... let's try that one. I'll look and see if it helps me out.

    .



Page 4 of 4 FirstFirst ... 2 3 4

Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -6. The time now is 07:24 PM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com