Jump to content

FreakingOUT

Members
 View Profile  See their activity

  • Posts

    56

  • Joined

  • Last visited

 Content Type 

Everything posted by FreakingOUT

  1. FreakingOUT
    Thanks - will try tha, but not sure what you mean "Check t he output of the return statement of the function as well", as that seems to be working. -FreakingOUT
  2. FreakingOUT
  3. FreakingOUT
    Logically (to me), this should work, but I still get the UNWANTED "No records found" displaying on initial page loading. <?php require '/myserverpath/kqr_mysqli.php'; // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } // define variables and set to empty values $call = ""; if ($_SERVER["REQUEST_METHOD"] == "POST") { $call = test_input($_POST["call"]); } function test_input($data) { $data = trim($data); $data = stripslashes($data); $data = htmlspecialchars($data); return $data; } ?> <html> <head><title></title> </head> <body> <form method="post" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?>"> CALL: <input type="text" name="call"> <input type="submit"> </form> </body> </html> <?php $call = mysqli_real_escape_string($con,$call); $sql = "SELECT * FROM qsolog WHERE `call` = '$call' "; $result = mysqli_query($con,$sql); if (!$result) echo mysqli_error($con); if (mysqli_num_rows($result) == 0 ): echo "No records found<br>"; else: if (mysqli_num_rows($result) >= 1 ): echo "<div style ='font:11px Arial,tahoma,sans-serif;color:#ff0000'>"; echo "<table border='1' cellpadding='3' cellspacing='3'> <tr> <th>EXPD</th> <th>IOTA</th> <th>ISLAND NAME</th> <th>CALL</th> <th>DATE</th> <th>UTC</th> <th>BAND</th> <th>MODE</th> </tr>"; while($row = mysqli_fetch_array($result)) { echo "<tr>"; echo "<td>" . $row['mycall'] . "</td>"; echo "<td>" . $row['iota'] . "</td>"; echo "<td>" . $row['islandname'] ."</td>"; echo "<td>" . $row['call'] . "</td>"; echo "<td>" . $row['qsodate'] . "</td>"; echo "<td>" . $row['timeon'] . "</td>"; echo "<td>" . $row['band'] . "</td>"; echo "<td>" . $row['mode'] . "</td>"; } endif; echo "</table>"; echo "</div>"; endif; mysqli_close($con); ?> -FreakingOUT
  4. FreakingOUT
  5. FreakingOUT
    (mac_gyver): Umh, never made it on the lonnnnnng drive (a short one, but much later) as other 'stuff' came up ;-( I've re-read all our helpful comments, and figured out how to NOT have the <th></th> part display until a bona fide 'CALL' search is done. Whew. Emailed my ISP with a query about the php.ini file, and have been looking for a good PHP Editor. Any suggestions welcomed. 10 years ago I did have a local machine Apache/PHP/MySQL installation and that is on the "To Do" list as am just coming back 'into the fold' (albeit was still a 'NOOB' back then). From what I can determine at this point, the easiest thing would be to have any 'results' (valid search or not) display on a 2nd page, but want to try and avoid that. Tried the 'No records found' code in several different positions, but just can not seem to crack this nut. Apparently my 'logic' is flawed, but using this for the bona fide dB search part still seems to make sense: if (mysqli_num_rows($result) >= 1 ) At this point, at least 2 of the 3 objectives are now being met on a single page. Ultimately, there will be 8 to 10 columns of data, and fortunately I know how to add these now . Hopefully I'm posting the exisitng code properly this time! Thanks again for your input. -FreakingOUT RE: === <?php require '/myserverpath/kqr_mysqli.php'; // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } // define variables and set to empty values $call = ""; if ($_SERVER["REQUEST_METHOD"] == "POST") { $call = test_input($_POST["call"]); } function test_input($data) { $data = trim($data); $data = stripslashes($data); $data = htmlspecialchars($data); return $data; } ?> <html> <head><title></title> </head> <body> <form method="post" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?>"> CALL: <input type="text" name="call"> <input type="submit"> </form> </body> </html> <?php $call = mysqli_real_escape_string($con,$call); $sql = "SELECT * FROM qsolog WHERE `call` = '$call' "; $result = mysqli_query($con,$sql); if (!$result) echo mysqli_error($con); if (mysqli_num_rows($result) >= 1 ) { echo "<table border='1'> <tr> <th>CALL</th> <th>DATE</th> </tr>"; while($row = mysqli_fetch_array($result)) { echo "<tr>"; echo "<td>" . $row['call'] . "</td>"; echo "<td>" . $row['qsodate'] . "</td>"; echo "</tr>"; } echo "</table>"; } //if (mysqli_num_rows($result) == 0 ) { // echo "No records found<br>"; //} mysqli_close($con); ?>
  6. FreakingOUT
    P.S. I know what I want the page to do: 1. When it first comes up, to have ONLY the text input box and 'SUBMIT QUERY' button. 2. If a 'CALL' is entered into the text field and the button pushed: A. For a valid 'CALL' with a record (or more for that 'CALL') in the dB Table, to display the data in an HTML Table. B. If the 'CALL' query is for one with NO records in the dB Table, the to display the "No records found' text 3. To never have the page load with the "No records found" text since no query has yet been submitted :^) -FreakingOUT .. .and heading OUT into the sunshine and blue skies for a while !!!
  7. FreakingOUT
    Thanks for the advice, mac_gyver. I will come back laterand RE-READ your admonitions, and try to chill out a bit here. Just tried something else (attempting to think somewhat 'logically', but that did not pan out - includinng >== 1 this time). -FreakingOUT
  8. FreakingOUT
    The PHP is on my ISP's server - I don't think I have access to the php.ini file? Now is just discovered that: if (mysqli_num_rows($result) >= 0 ) { ...should have been >= 1 but that yields a new error. I think I need to go on a lonnnnnnnng drive. Everyone's efforts here have been greatly appreciated, but I need to go clear the head ;-( Thanks, -FreakingOUT
  9. FreakingOUT
    I just tried this to see if "No records found" would ONLY display IF no records were actually found based upon a Valide Search entry. The results display fine with the Valid 'CALL' entered, but if some other 'CALL' (not actually in the dB Table), then "No records found" does not show. $call = mysqli_real_escape_string($con,$call); $sql = "SELECT * FROM qsolog WHERE `call` = '$call' "; $result = mysqli_query($con,$sql); if (!$result) echo mysqli_error($con); if (mysqli_num_rows($result) >= 0 ) { while($row = mysqli_fetch_array($result)) { echo "<tr>"; echo "<td>" . $row['call'] . "</td>"; echo "<td>" . $row['timeon'] . "</td>"; echo "</tr>"; } echo "</table>";} else { if (mysqli_num_rows($result) == 0 ) { echo "No records found<br>"; } } At least I got rid of the "No records found" displaying as soon as the page loaded. -FreakingOUT
  10. FreakingOUT
    FOUND THE PROBLEM... echo "<td>" . $rows['call'] . "</td>"; echo "<td>" . $rows['qsodate'] . "</td>"; Should be: echo "<td>" . $row['call'] . "</td>"; echo "<td>" . $row['qsodate'] . "</td>"; I had copied it from a previous version of the script ;-( Please excuse the bandwidth. Only the premature "No records found" issue remains. -FreakingOUT
  11. FreakingOUT
    This is strange... I added one more column header: <th>CALL</th> <th>DATE</th> And one more column to display: echo "<td>" . $rows['call'] . "</td>"; echo "<td>" . $rows['qsodate'] . "</td>"; ... but now get absolutely no output displaying after the search query. Any thoughts? Thanks. -FreakingOUT
  12. FreakingOUT
    Miracle of Miracles - the search query now works, but when the page initially loads, the "No records found" still displays prematurely. Here is the Brower source display: === <html> <head><title></title> </head> <body> <form method="post" action="/oqrs/kqrnewtest1c.php"> CALL: <input type="text" name="call"> <input type="submit"> </form> </body> </html> <table border='1'> <tr> <th>CALL</th> </tr><tr><td>4F9HXB</td></tr></table> === Here is the revised php code (Thanks to you and Barand) that "almost works" except for the "No records found" issue: <?php require '/home/eric/domains/k6vva.com/kqr_mysqli.php'; // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } // define variables and set to empty values $call = ""; if ($_SERVER["REQUEST_METHOD"] == "POST") { $call = test_input($_POST["call"]); } function test_input($data) { $data = trim($data); $data = stripslashes($data); $data = htmlspecialchars($data); return $data; } ?> <html> <head><title></title> </head> <body> <form method="post" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?>"> CALL: <input type="text" name="call"> <input type="submit"> </form> </body> </html> <?php //mysqli_real_escape_string($con,$call); //$sql = "SELECT * FROM qsolog WHERE `call` = '$call' "; //$result = mysqli_query($con,$sql); echo "<table border='1'> <tr> <th>CALL</th> </tr>"; $call = mysqli_real_escape_string($con,$call); $sql = "SELECT * FROM qsolog WHERE `call` = '$call' "; $result = mysqli_query($con,$sql); if (!$result) echo mysqli_error($con); if (mysqli_num_rows($result) == 0 ) { echo "No records found<br>"; } else { while($row = mysqli_fetch_array($result)) { echo "<tr>"; echo "<td>" . $row['call'] . "</td>"; echo "</tr>"; } echo "</table>"; } //mysqli_close($con); ?> Thanks, -FreakingOUT
  13. FreakingOUT
    Ooops: //while($row = mysqli_fetch_array($result) changed back to... while($row = mysqli_fetch_array($result) ... but still no results when submitting a text input query. Baffling. -FreakingOUT
  14. FreakingOUT
    (Barand) I did this: echo "<table border='1'> <tr> <th>CALL</th> </tr>"; $call = mysqli_real_escape_string($con,$call); $sql = "SELECT * FROM qsolog WHERE `call` = '$call' "; $result = mysqli_query($con,$sql); if (!$result) echo mysqli_error($con); if (mysqli_num_rows($result) == 0 ) { echo "No records found<br>"; } else { //while($row = mysqli_fetch_array($result)) // { echo "<tr>"; echo "<td>" . $row['call'] . "</td>"; echo "</tr>"; } echo "</table>"; Here's what happens: 1. When the page loaded, "the No records found" displayed BEFORE I entered text in the Query field. 2. When I did enter the text ("CALL"), the record did not display - only the <th>CALL</th> header. (mac-gyver) OMG... I had never seen the `backtick` underneath the ~ key before (DUH!). Talk about an eye opener - Thanks!!! -FreakingOUT
  15. FreakingOUT
    Sorry, not enough sleep here. This is the sequence, but still not yielding output from the text input field query: === mysqli_real_escape_string($con,$call); $sql = "SELECT * FROM qsolog WHERE 'call' = '$call' "; $result = mysqli_query($con,$sql); echo "<table border='1'> <tr> <th>CALL</th> </tr>"; while($row = mysqli_fetch_array($result)) { echo "<tr>"; echo "<td>" . $row['call'] . "</td>"; echo "</tr>"; } echo "</table>"; === -FreakingOUT
  16. FreakingOUT
    Oooops: mysqli_real_escape_string($con,$call); That comes before the $sql = "SELECT ....... line: === $sql = "SELECT * FROM qsolog WHERE 'call' = '$call' "; mysqli_real_escape_string($con,$call); $result = mysqli_query($con,$sql); echo "<table border='1'> <tr> <th>CALL</th> </tr>"; while($row = mysqli_fetch_array($result)) { echo "<tr>"; echo "<td>" . $row['call'] . "</td>"; echo "</tr>"; } echo "</table>"; ===
  17. FreakingOUT
    Thank you, Barand. I had tried backticks with 'call' before, but apparently NOT with the '$call' combination. That works. I inserted this into the PHP: $sql = "SELECT * FROM qsolog WHERE 'call' = '$call' "; mysqli_real_escape_string($con,$call); ...but entering the valid CALL (guess I need to change that column name even though I was surprised it worked in the Table), yielded no output. What am I doing wrong? For multiple column queries like WHERE 'call' = 'something' AND anothercolumn = 'something', do I need to use mysqli_real_escape_string($con,$call) for each one, or can I somehow combine all of them? Thanks! -FreakingOUT
  18. FreakingOUT
    PHP 5.2.17 MySQL 5.5.14 I get the simple test one column data to display OK with the following script when it first loads, except that that the table displays before I can even enter a 'CALL' in the text input field. <?php require '/myserverpathhere/kqr_mysqli.php'; // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } // define variables and set to empty values $call = ""; if ($_SERVER["REQUEST_METHOD"] == "POST") { $call = test_input($_POST["call"]); } function test_input($data) { $data = trim($data); $data = stripslashes($data); $data = htmlspecialchars($data); return $data; } ?> <html> <head><title></title> </head> <body> <form method="post" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?>"> CALL: <input type="text" name="call"> <input type="submit"> </form> </body> </html> <?php $sql = "SELECT * FROM qsolog"; $result = mysqli_query($con,$sql); echo "<table border='1'> <tr> <th>CALL</th> </tr>"; while($row = mysqli_fetch_array($result)) { echo "<tr>"; echo "<td>" . $row['call'] . "</td>"; echo "</tr>"; } echo "</table>"; mysqli_close($con); ?> In addition to this issue, with previous versions of the script I was unable to query with an actual 'CALL' without getting an error. I tried substituting this in the $sql Query: $sql = "SELECT * FROM qsolog WHERE call = '4F9HXB' "; That is an actual 'CALL' the displays when the page loads as mentioned previously (only one 'CALL' in the test dB Table). I get this error: Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given <snip> on line 54 I've also tried this: $sql = "SELECT * FROM qsolog WHERE call = '$call' "; ... but get the same error. Even tried this: $sql = "SELECT * FROM qsolog WHERE call = '$_POST[call]' "; ...yielding the same error. And this: $sql = "SELECT * FROM qsolog WHERE call = '$_POST['call']' "; ...with this error: Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING <snip> on line 44 My brain is FRIED trying to figure out what is wrong...even just using ONE table column and ONE record to K.I.S.S. ;-( Any help is appreciated (and how to prevent the Table cells from displaying BEFORE I actually submit any 'CALL' Query). Thanks very much. -FreakingOUT
  19. FreakingOUT
    This is just too weird. I turned everything off and went to bed disillusioned. Woke up at 3AM and decided to try again, this time copy & pasting the same exact code from my posting and FINALLY the test TABLE was created. Perhaps there is a glitch in my ISP's installation. Sorry for the bandwidth. -FreakingOUT
  20. FreakingOUT
    (On ISP's Server) MySQL Version 5.5.14 PHP Version 5.2.17 I spent over an hour trying to figure out why this very simple sample code from an article keeps yielding an Error 1064 message. Now my eyeballs are rolling and I am Freaking OUT ;-( CREATE TABLE employee ( id smallint(5) unsigned NOT NULL, firstname varchar(30), lastname varchar(30), birthdate date, PRIMARY KEY (id), KEY idx_lastname (lastname) ) ENGINE=InnoDB; I even deleted the KEY idx_lastname (lastname) line but that didn't work ;-( My repeated attempts were using both PHPMyAdmin and MyQSL Workbench. What am I missing??? Thanks very much for any insight(s). - FreakingOUT
×
×
  • Create New...

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.