Jump to content

PShannon

Members
  • Posts

    21
  • Joined

  • Last visited

Posts posted by PShannon

  1. I've been doing this since 1966 and I build stuff quick and fast with patterns, components, templates, borrowed code or whatever gets me to where I want to be as fast as possible and I have no problem with tweaking code, but then again, my question had nothing to do with code. You didn't read it and if you did, you certainly didn't understand it. 

    You did not contribute a single word responding to my inquiry. You just decided to lecture a guy you didn't know about what he needed.

    Now, please go away. You have nothing to contribute.

  2. I have used the W3 template to produce a script that uploads image changes to a directory on my server, updates the URL in my database and logs the event. Works beautifully IF the  source folder is:

    \Pictures or \Pictures\Personal

    But fails if it is any other source folder, even the peer folder \Pictures\BarImages

    Why?

     

  3. Forgive my omission. I should have identified the source up front. My bad!

    The target URL is stored in a MySQL database as a VARCHAR field in the "bars" table.

    The target "bar" is selected via a series of drop-downs -- also sourced from MySQL tables -- that answer the questions:

    What neighborhood do you want?
     Do you want a bar or a club/hotel/restaurant bar?
    Select from list of bars/clubs/hotels/restaurants in "neighborhood."

    Here's a page that shows a "selected" bar and demonstrates the application (cursor down to below image).

    http://www.database39.com/page.php?id=519

    Again, I am extremely grateful for your consult. I can live with what you have provided, but if it can be polished that last bit by ridding the "URL/link" row above the "action" tab, that would be superb.

     

  4. This works! You're a bloody genius! I have been chasing this for weeks. Thank you!

    I could use some help cleaning it up a bit.

    If you look at the resulting webpage --  http://www.database39.com/page.php?id=17 -- the code produces two rows.

    The first row contains https://www.110grill.com/

    The second, "action," row contains the legend "Website"

    Can the first row be made to "go away?"

    Again, I am very grateful.

  5. <input type="url" id="homepage" name="homepage" value="https://shakingcrab.com/">&nbsp;&nbsp;<input type="button" onclick="triggerlink()" value="go to url">

    This is on the right track, but I do not have the value of the target. The value of the target is in a variable, $website.

    How does the <input> statement change, given that?

    You can see what I am trying to do here: http://www.database39.com/page.php?id=13

    (cursor down, below image)

    I appreciate you responding. I've been struggling with this for some time . . .

  6. Because I am vested in:

    <input type="url" id="website" name="website" value="<?php echo "<a href='$website'>Website</a>"; ?> ">

    That's just one line of code from that form. There's a bunch of data in the form.

    Can you help me without suggesting other ways to accomplish this task?

    Here's how the Edge browser sees the statement at execution:

    <input type="url" id="website" name="website" value="'http://www.barracudatavern.com/'>Website</a> ">

    I know I'm close. Any ideas?

    I appreciate your input . . .

  7. Here's what I have:

    $website = "https://shakingcrab.com/"  (unquoted)

    <input type="url" id="website" name="website" value="<?php echo "<a href='$website'>Website</a>"; ?> ">

    This is what the HTML interpreter sees at execution:

    <input type="url" id="website" name="website" value="'https://shakingcrab.com/'>Website</a> ">

    Thanks . . .

  8. I have two tables to manage the hierarchical structure of a corporation (does BOM as well).

    tblOrganization
       id
       formal_name
       short_name
       etc . . .

    tblStructure
       parent_id (tblOrganization.id)
       child_id (tblOrganization.id
       relationship

    Done this a ton in SQL Server and Oracle (even MS Access) by using:

     tblOrganization ---> tblStructure <--- tblOrganization_1

    I can find no equivalency in MySQL????

    What does the MySQL SQL SELECT look like to retrieve that corporate structure?

    Thank you . . .

     

  9. Yes. I've been developing in HTML for 20 years, built a dozen sites in HTML, PHP and JAVA, but I've never displayed an URL retrieved from a MYSQL table in an HTML table, and have been unable to find a working solution on the Net -- and I've been looking for a week..

    In your example. you know what the URL is. That's ice cream.

    <td text-align:="" center;="" width:="" 50%;="">https://www.website.com/goodmorning.php</td>

    In my case, I have no idea what the URL is. It's coming from the database. It now displays in the table as text. My problem is how do I tell the HTML interpreter it is an hyperlink and not text.

    <td text-align: center; width: 50%;>" . $row["the_url"] . "</td>

    I do appreciate your assistance, Funce, and am here because W3 has the clearest and best presented documentation on the Net.

    I'm a newbee here, but I've been doing this stuff in a variety of languages and environments since 1967, spent 25 years training professional developers and at age 81, may be the worlds oldest blogger. I'm pretty good, but this problem has me by the nads!

  10. Thank you for responding. I appreciate it.

    Would you kindly show me where the anchor (<a>) is placed, Funce? Placement is everything.

        while($row = $result->fetch_assoc()) {
            $the_url = $row["the_url"];
        echo "<tr width:100%>
             <td text-align: left; width: 50%;>" . $row["some_text"] . "</td>
             <td text-align: center; width: 50%;>" . $row["the_url"] . "</td>
             </tr>";
        }
        echo "</table>";
        } else { echo "0 results"; }
            echo "The URL--> " . $the_url;

    You guys have some pretty good rag sailors down there . . .

  11. I am displaying data from a MySQL table in an HTML table.  I have one field that I would like to display as an hyperlink (hot link). I have been all over the web for three days looking for a solution to do this.

    I have placed all of the problem elements on a webpage:

    1. MySQL table specs

    2. PHP display MySQL table data in HTML table

    3. HTML table as seen in website

    http://www.database39.com/testtableurl.php

    Thank you for your help . . .

×
×
  • Create New...