Jump to content

All Activity

This stream auto-updates     

  1. Today
  2. Thank you both. I will give your solution a shot later in the day. I am grateful for your time and expertise.
  3. Your code uses bootstrap, the code is already set up for flex box usage. But you are missing part of bootstrap code that uses display: flex; the class 'row' element that must wrap round all the elements with class 'col-*'. So by inserting your original code (once you have fixed missing quotes) where the html comment is, will correct it how it should've been used to achieve the flex box effect.
  4. document.getElementById("lastentry") instead of document.getElementryById("lastentry")
  5. Funce

    Will not ADD

    You might be missing a quote mark in your $con line. What output are you getting? Any errors?
  6. Thank you! Flexbox requires me to spend sometime before I am able to do it. I will look into it later. @dsonesuk I am bit confused with your answer. Can you please clarify a bit?
  7. I've removed the link as the site linked seems sketchy. You should be able to find another example.
  8. I've removed the link as the site linked seems sketchy. You should be able to find another example.
  9. Funce

    Northwind Database

    Please do not reply to old topics.
  10. Please do not reply to old topics.
  11. Yesterday
  12. What I was going to get to, is that while the manner at which you create the HTML is different, its still going to be HTML. This means that you while you can create a fixed link like the following <tr width:100%=""> <td text-align:="" left;="" width:="" 50%;="">Good Morning!</td> <td text-align:="" center;="" width:="" 50%;=""><a href="https://www.website.com/goodmorning.php">https://www.website.com/goodmorning.php</a></td> </tr> Because you know how to make a link. To make a link with something from a database is the same. You know that referencing your database fields resolves them to Text. You just need to put that text in the right spaces inside your HTML. Just because we make it with PHP, doesn't stop this. Including dsonesuk's solution: <?php 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%;><a href='" . $row["the_url"] . "'>" . $row["the_url"] . "</a></td> </tr>"; } echo "</table>"; } else { echo "0 results"; } echo "The URL--> " . $the_url;
  13. The code of the link works !00% of the time. What does your code look like? I can view the code of the former, but have no idea what your code looks like. Please include some. BTW, welcome to the forums. :)
  14. '<td style="text-align: center; width: 50%;"><a href="' . $row["the_url"] . '">' . $row["the_url"] . '</a></td>';
  15. 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!
  16. function get_finacial_year_range() { $year = date('Y'); $month = date('m'); if($month<4){ $year = $year-1; } $start_date = date('d/m/Y',strtotime(($year).'-04-01')); $end_date = date('d/m/Y',strtotime(($year+1).'-03-31')); $response = array('start_date' => $start_date, 'end_date' => $end_date); return $response; }
  17. Hi all i need to duplicate a string using javascript problem is the string was taken from an xml node so, lots of things can go wrong. this is the string: <RunList Class="Parameter" Pages="0 ~ 3" Run="1" xmlns="http://www.CIP4.org/JDFschema_1_1"> <LayoutElement> <FileSpec URL="file://xxx/xxx/Jobs/xxx/xxx/xxx/xxx/xxx/xxx.pdf"></FileSpec> </LayoutElement> </RunList> any sugetions? thanks guy
  18. Hello, @Raymond Herrera Please try this code,To how to install jQuary on Linux. Get jQuery up and running in a minute or less: Insert this into your HTML (most commonly in the head, but you can throw it before the end body tag too): <script type="text/javascript" src="http://code.jquery.com/jquery-latest.min.js"></script> Then place a script element after your jQuery one. This would alert 'hello' after the DOM is ready. <script>$(function() { alert('hello') });</script> Using jQuery locally: After you get a feel, try downloading jQuery locally to your computer, and link it from your script file. The structure is like so: C:/web/index.html C:/web/js/jquery.js index.html: <head> <script src="js/jquery.js"></script> <script>$(function() { alert('hi') })</script> </head> You have the advantage of relying on your saved version offline if you don't have the Internet/Wi-Fi. You can also make custom edits to the jQuery source and modify it at will. I hope this code will be useful for you. Thank you.
  19. Open this. It will be able to solve your problem. https://github.com/debsmita99/SQLite/blob/master/Northwind.sql
  20. I'd like my video to start playing automatically when the page is launched without sound just like on this page: [LINK REMOVED] I've tried any possible jQuery/javascript/CSS option I could find online but I always end up with Google error that's blocking the video from autoplay unless there was an interaction. How did they do it in the link above?
  21. I'd like my video to start playing automatically when the page is launched without sound just like on this page: [LINK REMOVED]. I've tried any possible jQuery/javascript/CSS option I could find online but I always end up with Google error that's blocking the video from autoplay unless there was an interaction. How did they do it in the link above?
  22. Once you have done valid html by adding closing quotes to class names, all you have to do is add <div class="container"> <div class="row"> <!-- existing VALID html code --> </div></div>
  23. If instead of bootstrap you use CSS, you can use the flexbox: https://www.w3schools.com/css/css3_flexbox.asp With the align-items CSS property, you can make all of the items in the flexbox have the same height. To display a different amount of items per row, you can enable flex-wrap and give each box a percentage width using media queries.
  24. Last week
  25. HTML: <section data-quickedit-entity-id="block_content/43" id="block-acquisitionpractices" class="col-lg-6 col-md-6 col-sm-6 col-xs-12> <div> one </div> <div> two </div> <div> three </div> </section> <section data-quickedit-entity-id="block_content/43" id="block-acquisitionpractices" class="col-lg-6 col-md-6 col-sm-6 col-xs-12> <div> one </div> <div> two </div> <div> three </div> <div> four </div> </section> <section data-quickedit-entity-id="block_content/43" id="block-acquisitionpractices" class="col-lg-6 col-md-6 col-sm-6 col-xs-12> <div> one </div> <div> two </div> </section> <section data-quickedit-entity-id="block_content/43" id="block-acquisitionpractices" class="col-lg-6 col-md-6 col-sm-6 col-xs-12> <div> one </div> <div> two </div> <div> three </div> <div> one </div> <div> two </div> <div> three </div> </section> As you can see, different blocks have different sizes of strings. However, I like to set the height equal. Height:650px works but some devices do not fit the contents, some devices show too much padding in the bottom, etc. What would be the best way to set the height equal(html plus css) in all devices when blocks may not have equal number of characters? Thanks!
  26. Think about it like this. Your output is just straight HTML. <tr width:100%=""> <td text-align:="" left;="" width:="" 50%;="">Good Morning!</td> <td text-align:="" center;="" width:="" 50%;="">https://www.website.com/goodmorning.php</td> </tr> Do you know how to add a link in HTML?
  27. 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 . . .
  28. D-Graphics

    automatic lines

    Hi Everyone I'm working with the billing software BILLIT. When I'm editing the lay-out of my bills e came to this following problem. I have A line for the product description, price, amount, ... I like it when there is some structure in it so i have put a line under those cels. the problem is that the software fills the page with empty lines till the end of the page. So if there are many or few products the page is filled with lines till the end of the page. Is there some code i can use to stop creating new lines if there are no products anymore? this is my code now <table style="height: 220.859px;" width="100%"> <tbody> <tr> <td style="width: 595.276px;"><br /> &nbsp;</td> </tr> </tbody> </table> <table style="height: 102.121px;" width="100%"> <tbody> <tr> <td style="width: 70.866px;">&nbsp;</td> <td style="vertical-align:top; width: 324.567px;"><span style="font-family:verdana,geneva,sans-serif;"><span style="color:#009fe3;"><b>D-Graphics</b></span><br /> <span style="font-size:9px;">Brugse Heirweg 51<br /> 8211 Aartrijke<br /> +32 (0) 495 77 56 93<br /> BE0821.859.224<br /> www.d-graphics.pro<br /> info@d-graphics.pro<br /> IBAN: BE97 9795 9873 6949</span></span></td> <td style="text-align:left; vertical-align:top; width: 199.843px;"><span style="font-family:verdana,geneva,sans-serif;"><span style="font-size:9px;"><strong>Factuurdatum:</strong>&nbsp;$Order.OrderDate$<br /> <strong>Factuurnummer:</strong>&nbsp;$Order.OrderNumber$<br /> <strong>Klantnummer:</strong>&nbsp;$Customer.Nr$<br /> $Customer.CompanyName$<br /> $Customer.ContactFullName$<br /> $Customer.StreetAndNumber$<br /> $Customer.ZipCode$&nbsp;$Customer.City$<br /> $Customer.VAT$</span></span></td> </tr> </tbody> </table> <table style="height: auto;" width="100%"> <tbody> <tr> <td style="width: 595.276px;">&nbsp;</td> </tr> </tbody> </table> <table style="height: 17.48px;" width="100%"> <tbody> <tr> <td style="width: 50%; text-align: center;"> <table border="0" cellpadding="20" cellspacing="0" style="width: 100%;"> <tbody style="background-color: #c0e9fd;"> <tr> <td style="text-align: center;"><span style="font-family:verdana,geneva,sans-serif;"><span style="font-size:10px;"><strong>Indien u betaald voor $Order.FinancialReductionDate$ Dan geniet u een financi&euml;le korting. Het te betalen bedrag is dan<br /> $Order.TotalInclWithFReduction$</strong></span></span></td> </tr> </tbody> </table> </td> <td style="text-align: center; width: 50%;"><span style="font-family:verdana,geneva,sans-serif;"><span style="font-size:9px;"><b>Gelieve deze factuur te betalen voor $Order.ExpiryDate$, met volgende gestructureerde mededeling: $Order.OGM$</b></span></span></td> </tr> </tbody> </table> <table cellspacing="0" style="height: 14.173px;" width="100%"> <tbody> <tr> <td class="none" style="width: 32.135px;">&nbsp;</td> <td class="none" style="width: 263px;">&nbsp;</td> <td class="none" style="width: 165px;">&nbsp;</td> <td class="none" style="width: 241px;">&nbsp;</td> <td style="width: 32.135px;">&nbsp;</td> </tr> </tbody> </table> <table cellspacing="0" class="bottomborder" style="height: 14.173px;" width="100%"> <tbody style="background-color: deepskyblue;"> <tr> <td class="none" style="width: 32.135px;">&nbsp;</td> <td class="none" style="width: 281px;"><strong><span style="font-family:verdana,geneva,sans-serif;"><span style="font-size:9px;">TOTAAL EXCL BTW:&nbsp;</span></span></strong><span style="font-family:verdana,geneva,sans-serif;"><span style="font-size:9px;">$Order.TotalExcl$</span></span></td> <td class="none" style="width: 198px; text-align: center;"><strong><span style="font-family:verdana,geneva,sans-serif;"><span style="font-size:8px;">TOTAAL BTW (21%):&nbsp;</span></span></strong><span style="font-family:verdana,geneva,sans-serif;"><span style="font-size:9px;">$Order.TotalVAT$</span></span></td> <td class="none" style="width: 241px; text-align: right;"><strong><span style="font-family:verdana,geneva,sans-serif;"><span style="font-size:9px;">TOTAAL TE BETALEN:&nbsp;</span></span></strong><span style="font-size:11px;"><span style="font-family:verdana,geneva,sans-serif;"><strong>$Order.TotalIncl$</strong></span></span></td> <td style="width: 32.135px;">&nbsp;</td> </tr> </tbody> </table> &nbsp; <table cellspacing="0" style="height: 14.173px;" width="100%"> <tbody> <tr> <td class="none" style="width: 32.135px;">&nbsp;</td> <td class="none" style="width: 263px;">&nbsp;</td> <td class="none" style="width: 165px;">&nbsp;</td> <td class="none" style="width: 241px;">&nbsp;</td> <td style="width: 32.135px;">&nbsp;</td> </tr> </tbody> </table> <table cellspacing="0" class="bottomborder" style="height: 14.173px;" width="100%"> <tbody> <tr> <td class="none" style="width: 32.135px;">&nbsp;</td> <td class="none" style="width: 191.235px;"><strong><span style="font-family:verdana,geneva,sans-serif;"><span style="font-size:9px;">OMSCHRIJVING</span></span></strong></td> <td class="none" style="width: 101.14px;"><strong><span style="font-family:verdana,geneva,sans-serif;"><span style="font-size:9px;">PRIJS&nbsp;</span><span style="font-size:8px;">(EXCL BTW)</span></span></strong></td> <td class="none" style="width: 78.576px;"><strong><span style="font-family:verdana,geneva,sans-serif;"><span style="font-size:9px;">KORTING</span></span></strong></td> <td class="none" style="width: 54.425px;"><strong><span style="font-family:verdana,geneva,sans-serif;"><span style="font-size:9px;">AANTAL</span></span></strong></td> <td class="none" style="width: 167.764px; text-align: center;"><strong><span style="font-family:verdana,geneva,sans-serif;"><span style="font-size:9px;">TOTAAL</span><span style="font-size:8px;">(EXCL BTW)</span></span></strong></td> <td style="width: 32.135px;">&nbsp;</td> </tr> </tbody> </table> <table cellspacing="0" style="height: auto;" width="100%"> <tbody> <tr> <td class="none" style="width: 32.135px;">&nbsp;</td> <td class="bottomborder" style="width: 191.235px; "><span style="font-family:verdana,geneva,sans-serif;"><span style="font-size:9px;">$Line.Description$</span></span></td> <td class="bottomborder" style="width: 101.14px; "><span style="font-family:verdana,geneva,sans-serif;"><span style="font-size:9px;">$Line.AmountExcl$</span></span></td> <td class="bottomborder" style="width: 78.576px; "><span style="font-family:verdana,geneva,sans-serif;"><span style="font-size:9px;">$Line.ReductionPerc$</span></span></td> <td class="bottomborder" style="width: 54.425px; "><span style="font-family:verdana,geneva,sans-serif;"><span style="font-size:9px;">$Line.Quantity$</span></span></td> <td class="bottomborder" style="width: 167.764px; text-align: center;"><span style="font-family:verdana,geneva,sans-serif;"><span style="font-size:9px;">$Line.TotalExcl$</span></span></td> <td style="width: 32.135px;">&nbsp;</td> </tr> </tbody> </table> next tho this i have this also in the software .border td { padding: 3px 5px; } .cellborders td { border: 1px solid black; } /* !important is necessary to show the lines in editor(otherwise they are overridden by the dotted borders to visualize table cells) */ .border { border: 1px solid black !important; } .bottomborder { border-bottom: 1px solid deepskyblue !important; } .bottomright { border-right: 1px solid black !important; } .bottomtop { border-top: 1px solid deepskyblue !important; } .bottomleft { border-left: 1px solid black !important; } .bottomrightborder { border-bottom: 1px solid black !important; border-right: 1px solid black !important; } .celkleur { background-color: deepskyblue; } td{ line-height:18px; font-size: 12px; } body{ line-height:18px; font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; } table, tr, td, th, tbody, thead, tfoot { page-break-inside: auto; } .allowpagebreak{ page-break-inside: initial !important; } tr{page-break-inside: avoid !important;} the software that billit uses tho generate the lay-out is: CKEditor 4.12.1 (revision 64749bb245) Factuur_202000017_CarbonezStijn-7.pdf Factuur_202000017_CarbonezStijn-6.pdf
  1. Load more activity
×
×
  • Create New...