Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

4 Neutral

About charlieholder

  • Rank
    Prolific Member

Contact Methods

  • Website URL

Profile Information

  • Gender
  • Location
    Atlanta, GA
  1. charlieholder

    SELECT COUNT JOIN GROUP BY issue not showing all empty counts

    Ahhhh. I am teaching myself JOIN and I found example code that I tried to rewrite. That totally makes sense. The IFNULL part was something I read on SO and they said it was needed. I couldn't ever get 0 to show up when I used COUNT alone. Maybe I made more than one change at the same time without realizing and adding the INFULL combined with some other change got it working. When I added it the 0 counts started showing up. I still don't fully understand what the IFNULL part was doing, but my code isn't live yet and I was still trying to understand it before pushing it out. Guess I don't have to worry about that now. lol. Thanks for this rewrite.
  2. Hello! I'm trying to display a list of clients and count the number of items they have in another table including clients that have a count of 0. The structure of my two tables looks like this: clients ---------- id name items ---------- id client_id item_id The query I have so far is: SELECT c.*, IFNULL(COUNT(i.item_id), 0) as numItems FROM clients c LEFT JOIN items i on c.id = i.client_id GROUP BY i.client_id ORDER BY c.name I'm close, but it stops at the first client with 0 items and doesn't show anymore clients. If that client with 0 items finally gets some items, the next client with 0 items appears in the list. I'm not sure what I'm missing. This is the closest I've gotten and I'm now stumped from reading around here and SO. Thanks for a fresh pair of eyes.
  3. charlieholder

    Special Characters and Character Limits

    Ok thanks. lol
  4. charlieholder

    Special Characters and Character Limits

    Am I correct in thinking that my regex is returning the format error because encoding the input is creating a longer string behind the scenes? I cannot figure out why a string of less than 64 characters is throwing an error. I am using htmlentities() to make sure that the presence of a double quote doesn't break my HTML code. When I check the source code of the submitted form, things like & is converted to & and " to " as I would expect. <? $errors = FALSE; $e_name_e = FALSE; // error name empty $e_name_f = FALSE; // error name format if ( isset($_POST['submit']) && !empty($_POST['submit']) && $_POST['submit'] == "Add" ) { $link = db(); $raceName = mysqli_real_escape_string($link, htmlentities(trim($_POST['raceName']))); if ( empty($raceName) ) { $e_name_e = TRUE; $errors = TRUE; } if ( !preg_match('/^[a-zA-Z0-9 ~!@#$%^&*()+`{}|[\]\\\\:";\'<>?,.\/=_-]{1,64}$/', $raceName) ) { $e_name_f = TRUE; $errors = TRUE; } mysqli_close($link); } ?> <input type="text" value="<? echo ($errors) ? stripslashes($raceName) : '';?>" class="form-control" id="raceName" name="raceName" placeholder="Name of the race." maxlength="64" aria-labelledby="label_raceName" aria-describedby="help_raceName" /> <? echo ($e_name_f) ? getFormError('help_raceName','Bad form.') : ''; ?> // In an included file function getFormError($id, $message, $html='') { $html .= "<span class=\"fa fa-times fa-fw form-control-feedback\" aria-hidden=\"true\"></span>"; $html .= "<span id=\"{$id}\" class=\"help-block\">{$message}</span>".PHP_EOL; return $html; } I hate pasting huge blocks of text. Let me know if I trimmed too much and a few more lines would help diagnose. If I am correct, I'm unable to figure out the best way to limit to 64 characters but also handle any special characters. Should I switch the {1,64} to + in the regex and just let the HTML maxlength attribute do all the talking? If I'm not correct, I would appreciate any direction. It's 1am local and I'm unable to move forward on this and need some sleep. I feel like there's a better way to do this altogether. Maybe with some prepared statements to accept input from a form? I will be writing the information to the database eventually. But right now I'm only having problems with the regex.
  5. charlieholder

    PayPal Subscriptio Button

    I don't think you're showing enough code for us to really be able to help you. I'm going to make a HUGE assumption since I see a single quote at the very end of your HTML. Is all of this HTML output a single string with your PHP variables referenced inside? If that's the case, your syntax for referencing variables inside of quotes is incorrect. $output = 'My name is: ' . $name; $output = "My name is: " . $name; $output = "My name is: {$name}"; If you're using single quotes, you must concatenate the variable. If you're using double quotes, you can either concatenate or wrap the variable inside of braces. There are more/other options when you include concepts like heredoc and nowdoc syntax. If this doesn't help, you're probably going to need to show more code. It may help you to read over the manual page for strings since it references how to call variables.
  6. charlieholder

    .= causing errors

    TBH, and maybe it's me, since I don't do a lot of programming (it's a hobby not a career), small issues like trying to use/reference a variable I haven't defined yet tend to pop up more than I would like. Thanks for the help tracking down why the errors were showing up.
  7. charlieholder

    .= causing errors

    Thanks all. Work and family life hasn't left much time for me to revisit this. I'm finally able to circle back. I made a mistake when posting in that not only did I rename my files, but I also copy/pasted a bad version because I had made a copy of the file in order to pull out sensitive data to get help. The filename is lib.php and it's being referenced correctly. If I comment out the first getAlert() or make the $html line just an assignment statement, the result is the correct HTML and no errors/warnings. The error was showing on my HTML page when the page loaded and tried to run the PHP code for generating output. It was just right there where the table should have been. Tested and everything functions the same in terms of errors when doing just a variable assignment and using the concatenating assignment operator. So basically whoever authored the library didn't do a good job with the error reporting/checking? I feel like I've used the concatenating assignment operator before without the PHP Simple HTML DOM Parser, but I don't have an example to share. Seems like this is not a bug, I should define my variable before using it, and move on? Thanks!
  8. charlieholder

    .= causing errors

    Hey mac_gyver, thanks for the reply. Sorry if I wasn't more clear. The error is immediately after the function runs. getAlert() completes and echoes fine. I think it is originating in the for loop, but only happens when using the concatenating assignment operator inside of getAlert(). I added an echo statement at the top of the for loop to print an HTML comment and included that in the HTML output generated. I don't actually know where the php.ini file on my host is. When I do a phpinfo() dump into the browser, the error related fields are as follows for both Local Value and Master Value: error_append_string - no value error_log - syslog error_prepend_string - no value error_reporting - no value I put error_reporting(E_ALL); in the top of my functions.php file and it now shows: Line 40 is the first time we see $html in the getAlert() function. (I will highlight it below.) Strangely the block of code for getAlert() still executes and moves on. Nope. I know it's a reflex question and I'm pretty happy to say that because of this forum it's one of the first things I check when I'm doing redirects. Both $pause and $array and hardcoded variables near the top of my index.php file. I didn't think the full-blown code would be very useful so my apologies again. Let me show more. functions.php <?php error_reporting(E_ALL); session_start(); date_default_timezone_set('America/New_York'); function db() { $hostname = 'localhost'; $username = 'username'; $password = 'hunter2'; $database = 'database'; $link = mysqli_connect($hostname, $username, $password, $database); if ( !$link ) { echo "Error: Unable to connect to MySQL." . PHP_EOL; echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL; echo "Debugging error: " . mysqli_connect_error() . PHP_EOL; exit; } return $link; } function mksf($link, $string) { $s = get_magic_quotes_gpc() ? stripslashes($string) : $string; return mysqli_real_escape_string($link, $s); } /** * Get HTML for alert. * @param string $type * @param int $dismissable * @param string $message * @return string $html */ function getAlert($type,$dismissable,$message) { $dismiss = ($dismissable) ? ' alert-dismissible': ''; $html .= "<div class=\"alert alert-{$type}{$dismiss}\" role=\"alert\">"; // Line 40 $html .= ($dismissable) ? "<button type=\"button\" class=\"close\" data-dismiss=\"alert\" aria-label=\"Close\"><span aria-hidden=\"true\">×</span></button>" : ''; $html .= $message; $html .= "</div>"; return $html; } /** * Format swim, bike, run, and transition times. * @param string $text * @param string $tags * @param boolean $invert * @return string $text */ function formatTime($time) { $pieces = explode(':',$time); if ( count($pieces) == 2 ) { array_unshift($pieces,'00'); } return sprintf('%02d:%02d:%02d',$pieces[0],$pieces[1],$pieces[2]); } /** * Strip all HTML tags and their content. * @param string $text * @param string $tags * @param boolean $invert * @return string $text */ function stripTagsContent($text,$tags='',$invert=FALSE) { preg_match_all('/<(.+?)[\s]*\/?[\s]*>/si',trim($tags),$tags); $tags = array_unique($tags[1]); if ( is_array($tags) AND count($tags) > 0 ) { if ( $invert == FALSE ) { return preg_replace('@<(?!(?:'.implode('|',$tags).')\b)(\w+)\b.*?>.*?</\1>@si','',$text); } else { return preg_replace('@<('.implode('|',$tags).')\b.*?>.*?</\1>@si','',$text); } } elseif ( $invert == FALSE ) { return preg_replace('@<(\w+)\b.*?>.*?</\1>@si','',$text); } return $text; } ?> index.php <?php include_once('lib.php'); include_once('simple_html_dom.php'); $pause = FALSE; $showComments = FALSE; $rLink = 'http://www.example.com/page.php'; $rid = '1234567890'; $rshort = 'example'; $rlong = 'Example Title'; $bibs = array(552, 874, 1767, 2507, 1618, 566); $results = array(); $swimTimes = array(); $t1Times = array(); $bikeTimes = array(); $t2Times = array(); $runTimes = array(); $totalTimes = array(); ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"/> <meta http-equiv="X-UA-Compatible" content="IE=edge"/> <meta name="viewport" content="width=device-width, initial-scale=1"/> <title></title> <link rel="stylesheet" href="//maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" type="text/css"/> <link rel="stylesheet" href="//maxcdn.bootstrapcdn.com/font-awesome/4.6.1/css/font-awesome.min.css" type="text/css"/> <link rel="stylesheet" href="style.css" type="text/css"/> <!--[if lt IE 9]> <script src="//oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script> <script src="//oss.maxcdn.com/respond/1.4.2/respond.min.js"></script> <![endif]--> <script src="//code.jquery.com/jquery-2.2.3.min.js" type="text/javascript"></script> <script src="//maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js" type="text/javascript"></script> <script src="jquery.numeric.min.js" type="text/javascript"></script> <script src="script.js" type="text/javascript"></script> </head> <body> <div class="container-fluid"> <div class="row"> <div id="results" class="col-xs-12"> <?php if ( !$pause ) { echo getAlert('info',1,'Trying to gather the data.').PHP_EOL; if ( !empty($bibs) ) { foreach ( $bibs as $bib ) { echo '<!-- For loop. -->'; // Added to see where error might be coming from. $html = new simple_html_dom(); $html->load_file("{$rLink}?rid={$rid}&r={$rshort}&bib={$bib}"); $header = $html->find("header",0); $name = trim(stripTagsContent($header->find("h1",0)->innertext)); $overallRank = trim(stripTagsContent($header->find("div[id=div-rank]",0)->innertext)); $divisionRank = trim(stripTagsContent($header->find("div[id=rank]",0)->innertext)); $resultsTableWhite = $html->find("div[class=results-table-white]",0); $generalInfo = $resultsTableWhite->find("table[id=general-info]",0); $division = trim($generalInfo->find("td",4)->innertext); $atheleteDetails = $resultsTableWhite->find("table[id=athelete-details]",0); $swimTime = formatTime(trim($atheleteDetails->find("td",2)->innertext)); $bikeTime = formatTime(trim($atheleteDetails->find("td",4)->innertext)); $runTime = formatTime(trim($atheleteDetails->find("td",6)->innertext)); $totalTime = formatTime(trim($atheleteDetails->find("td",->innertext)); $atheleteTableDetails = $html->find("div[class=athlete-table-details]",0); $swimRank = trim(explode(":",$atheleteTableDetails->find("p",0)->innertext)[1]); $bikeRank = trim(explode(":",$atheleteTableDetails->find("p",1)->innertext)[1]); $runRank = trim(explode(":",$atheleteTableDetails->find("p",2)->innertext)[1]); $t1Time = formatTime(trim($atheleteTableDetails->find("table",3)->find("td",1)->innertext)); $t2Time = formatTime(trim($atheleteTableDetails->find("table",3)->find("td",3)->innertext)); $results[] = array( 'name' => $name ,'bib' => $bib ,'division' => $division ,'swimTime' => $swimTime ,'t1Time' => $t1Time ,'bikeTime' => $bikeTime ,'t2Time' => $t2Time ,'runTime' => $runTime ,'totalTime' => $totalTime ,'overallRank' => $overallRank ,'divisionRank' => $divisionRank ,'swimRank' => $swimRank ,'bikeRank' => $bikeRank ,'runRank' => $runRank ); if ( !in_array($swimTime,$swimTimes) ) { $swimTimes[] = $swimTime; } if ( !in_array($t1Time,$t1Times) ) { $t1Times[] = $t1Time; } if ( !in_array($bikeTime,$bikeTimes) ) { $bikeTimes[] = $bikeTime; } if ( !in_array($t2Time,$t2Times) ) { $t2Times[] = $t2Time; } if ( !in_array($runTime,$runTimes) ) { $runTimes[] = $runTime; } if ( !in_array($totalTime,$totalTimes) ) { $totalTimes[] = $totalTime; } } echo getAlert('success',1,'Results data gathered.').PHP_EOL; if ( !empty($results) ) { sort($swimTimes); sort($t1Times); sort($bikeTimes); sort($t2Times); sort($runTimes); sort($totalTimes); echo "<table class=\"table table-hover table-condensed\">".PHP_EOL; echo getTableHeadFoot(array('Name','Division','OA Rank','Div Rank','SBR Ranks','Swim','T1','Bike','T2','Run','Total')).PHP_EOL; echo "<tbody>".PHP_EOL; foreach ( $results as $result ) { switch ( $result['swimTime'] ) { case $swimTimes[0]: $swimClass = ' gold'; break; case $swimTimes[1]: $swimClass = ' silver'; break; case $swimTimes[2]: $swimClass = ' bronze'; break; default: $swimClass = ''; } switch ( $result['t1Time'] ) { case $t1Times[0]: $t1Class = ' gold'; break; case $t1Times[1]: $t1Class = ' silver'; break; case $t1Times[2]: $t1Class = ' bronze'; break; default: $t1Class = ''; } switch ( $result['bikeTime'] ) { case $bikeTimes[0]: $bikeClass = ' gold'; break; case $bikeTimes[1]: $bikeClass = ' silver'; break; case $bikeTimes[2]: $bikeClass = ' bronze'; break; default: $bikeClass = ''; } switch ( $result['t2Time'] ) { case $t2Times[0]: $t2Class = ' gold'; break; case $t2Times[1]: $t2Class = ' silver'; break; case $t2Times[2]: $t2Class = ' bronze'; break; default: $t2Class = ''; } switch ( $result['runTime'] ) { case $runTimes[0]: $runClass = ' gold'; break; case $runTimes[1]: $runClass = ' silver'; break; case $runTimes[2]: $runClass = ' bronze'; break; default: $runClass = ''; } switch ( $result['totalTime'] ) { case $totalTimes[0]: $totalClass = ' gold'; break; case $totalTimes[1]: $totalClass = ' silver'; break; case $totalTimes[2]: $totalClass = ' bronze'; break; default: $totalClass = ''; } $trophyIcon = ($result['divisionRank'] <= 5) ? " <span class=\"fa fa-trophy\"></span></td>" : ''; echo "<tr>".PHP_EOL; echo "<td class=\"col-xs-2\">{$result['name']}</td>".PHP_EOL; echo "<td class=\"col-xs-1\">{$result['division']}</td>".PHP_EOL; echo "<td class=\"col-xs-1\">{$result['overallRank']}</td>".PHP_EOL; echo "<td class=\"col-xs-1\">{$result['divisionRank']}{$trophyIcon}</td>".PHP_EOL; echo "<td class=\"col-xs-1\">{$result['swimRank']}->{$result['bikeRank']}->{$result['runRank']}</td>".PHP_EOL; echo "<td class=\"col-xs-1{$swimClass}\">{$result['swimTime']}</td>".PHP_EOL; echo "<td class=\"col-xs-1{$t1Class}\">{$result['t1Time']}</td>".PHP_EOL; echo "<td class=\"col-xs-1{$bikeClass}\">{$result['bikeTime']}</td>".PHP_EOL; echo "<td class=\"col-xs-1{$t2Class}\">{$result['t2Time']}</td>".PHP_EOL; echo "<td class=\"col-xs-1{$runClass}\">{$result['runTime']}</td>".PHP_EOL; echo "<td class=\"col-xs-1{$totalClass}\">{$result['totalTime']}</td>".PHP_EOL; echo "</tr>".PHP_EOL; } echo "</tbody>".PHP_EOL; echo "</table>".PHP_EOL; } else { echo getAlert('danger',0,'Array is empty.').PHP_EOL; } } else { echo getAlert('danger',0,'No bibs.').PHP_EOL; } } else { echo getAlert('warning',0,'Data gather paused.').PHP_EOL; } ?> </div> <!-- /#results --> </div> <!-- /row --> </div> <!-- /container --> </body> </html> HTML output at the errors: <div class="row"> <div id="results" class="col-xs-12"> <br /> <b>Notice</b>: Undefined variable: html in <b>/path/to/functions.php</b> on line <b>40</b><br /> <div class="alert alert-info alert-dismissible" role="alert"><button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button>Trying to gather the data.</div> <!-- For loop. --><br /> <b>Fatal error</b>: Call to a member function find() on null in <b>/path/to/simple_html_dom.php</b> on line <b>1129</b><br /> Thanks.
  9. charlieholder


    Looking at the JavaScript version of the calculation: function calc() { var de = document.getElementById("l").value ; var nu = document.getElementById("n").value ; var pay = document.getElementById("p").value ; var n = nu * 12; var q1 = Math.log(1 + parseFloat(1/n)); var q2 = Math.log(2); var q = parseFloat(q1/q2); var amt; var amt1 = Math.pow((1 + parseFloat(pay/de)),1/q).toFixed(4); var amt2 = parseFloat( Math.pow(amt1-1,q)).toFixed(4); amt = parseFloat(1200 * (amt2 - 1)).toFixed(2); document.getElementById("op").value = amt; } Try something like this to get started: function calc($total_loan_amount, $total_number_of_payments, $payment_amount) { $p = $payment_amount; $a = $total_loan_amount; $n = $total_number_of_payments; $q = log(1 + (1/$n)) / log(2); $i = pow(pow(1 + ($p/$a), 1/$q) - 1, $q) - 1; return $i; } Absolutely no attention paid to data types, decimals, etc for the numbers.
  10. charlieholder

    .= causing errors

    Does anyone have any information about why initial variable creation/assignment with the concatenating assignment operator causes errors? The reference to find() is a reference to PHP Simple HTML DOM Parser. Throws error after: function getAlert($type,$message) { $html .= "<div class=\"alert alert-{$type}\" role=\"alert\">"; $html .= $message; $html .= "</div>"; return $html; } Does not throw error after: function getAlert($type,$message) { $html = "<div class=\"alert alert-{$type}\" role=\"alert\">"; $html .= $message; $html .= "</div>"; return $html; } I've narrowed the problem down to when I initialize $html using the concatenating assignment operator as opposed to traditional variable assignment. Certainly I could return the string on a single line or move forward with traditional variable assignment. I think mostly my curiosity as to why I would be getting a null reference from a block of code that was working perfectly a few moments earlier is why I am posting this. My truncated code, which I feel is probably irrelevant, in case there's more to it than I imagine: <?php include_once('simple_html_dom.php'); include_once('functions.php'); ?> <!DOCTYPE html> <html lang="en"> <body> <?php if ( !$pause ) { echo getAlert('info','Trying to gather the data.'); if ( !empty($array) ) { foreach ( $array as $value ) { $html = new simple_html_dom(); $html->load_file("http://www.example.com?id={$value}"); $header = $html->find("header",0); $name = trim($header->find("h1",0)->innertext); // More code } } else { // Empty array. } } else { // Paused. } ?> </body> </html> Please excuse my code. I took a programming sabbatical and I'm trying to get back in.
  11. charlieholder

    Build URL with form data

    That color-coding is clutch. I've never thought about highlighting the needed addition in that way. Thanks!
  12. charlieholder

    Build URL with form data

    Grrrrrr... And what's the best method for consolidating something like selectDivision=18-24&selectDivision=25-29&selectDivision=30-34 into something like selectDivision=18-24,25-29,30-34 ?
  13. charlieholder

    Build URL with form data

    I started out trying to do that, but when I click submit the URL comes back like this: index.php?Apply=Apply. "Apply" is the name and value of my submit button. Maybe that means my form is malformed. I took out all the options so it wasn't as long, but here's my form if you think it might help: <form class="form-horizontal" action="index.php" method="get"> <div class="container-fluid"> <div class="row"> <div class="col-xs-12 col-md-3"> <div class="form-group"> <label for="selectDivision" class="control-label sr-only">Division</label> <select id="selectDivision" class="form-control" multiple> <option value="25-29">25-29</option> <option value="30-34">30-34</option> <option value="35-39">35-39</option> </select> </div> </div> <div class="col-xs-12 col-md-3"> <div class="form-group"> <label for="selectGender" class="control-label sr-only">Gender</label> <select id="selectGender" class="form-control" multiple> <option value="M">M</option> <option value="F">F</option> </select> </div> </div> <div class="col-xs-12 col-md-3"> <div class="form-group"> <label for="selectCountry" class="control-label sr-only">Country</label> <select id="selectCountry" class="form-control" multiple> <option value="CAN">CAN</option> <option value="USA">USA</option> </select> </div> </div> <div class="col-xs-12 col-md-3"> <div class="form-group"> <input type="submit" class="btn btn-default btn-block" name="Apply" value="Apply"/> </div> </div> </div> </div> </form>
  14. charlieholder

    Build URL with form data

    Well old friends. We meet again. It's been over 2 years since my last post. Things look a little different around here... in a good way. Life has really crazy with work, school, home, etc. and I've finally gotten some time to work on a silly project in my free time. And of course I can't remember for the life of me how to write PHP code. Ha! I have an HTML table of (tabular) data displaying very well on a page. I would like to add some filters so that you can filter out data based on whatever criteria I decide is worth filtering on. I would like to apply the filters via URL parameters so I can hot-link to pre-filtered tables instead of forcing them to load the entire table and then filter every time. I'm having a bit of trouble making the leap from building the form with all the options (three <select multiple> elements each with a various number of options) to getting the choices into the URL. The only thing I've figured so far is to POST the data to a form handler page and then redirect back to the table page with some URL parameters. I would build the URL on the form handler page and run the query that generates the table based on what I can GET from the URL. I wasn't sure if this was the best way to go about it or not. Thanks for any tips/advice.
  15. charlieholder

    PHPFreaks Tutorials Wishlist

    What do you think about doing a tutorial for doing .htaccess on a folder? And maybe linking it with a user database table?

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.