[insert_php]
mysql_connect(“localhost”, “ku4bycom_search”, “^VWGaTPd=o00”) or die(“Error connecting to database: “.mysql_error());
/*
localhost – it’s location of the mysql server, usually localhost
root – your username
third is your password

if connection fails it will stop loading the page and display an error
*/

mysql_select_db(“ku4bycom_qsos”) or die(mysql_error());
/* tutorial_search is the name of database we’ve created */

[/insert_php]

You can use this search to see if I have received and replied to your QSL Card! Just search for your call and the log entries will appear. You can check out the legend below to interpret the current status. My log is current as of 4-30-2014.

[insert_php]
$query = $_GET[‘query’];
// gets value sent over search form

$min_length = 3;
// you can set minimum length of the query if you want

if(strlen($query) >= $min_length){ // if query length is more or equal minimum length then

$query = htmlspecialchars($query);
// changes characters used in html to their equivalents, for example: < to > $query = mysql_real_escape_string($query); // makes sure nobody uses SQL injection $raw_results = mysql_query("SELECT `Call`, `Band` ,`QSL_Rcvd`, `QSL_Sent` , `QSO_Begin` FROM qsos WHERE `Call` = '$query'") or die(mysql_error()); // * means that it selects all fields, you can also write: `id`, `title`, `text` // articles is the name of our table // '%$query%' is what we're looking for, % means anything, for example if $query is Hello // it will match "hello", "Hello man", "gogohello", if you want exact match use `title`='$query' // or if you want to match just full word so "gogohello" is out use '% $query %' ...OR ... '$query %' ... OR ... '% $query' if(mysql_num_rows($raw_results) > 0){ // if one or more rows are returned do following

while($results = mysql_fetch_array($raw_results)){
// $results = mysql_fetch_array($raw_results) puts data from database into array, while it’s valid it does the loop

//echo “

” . $results[‘Call’] .”

“.$results[‘QSL_Rcvd’] .”

“.$results[‘QSL_Sent’].”

“;
// posts results gotten from database(title and text) you can also show id ($results[‘id’])
echo “

“;
echo “Your Search: “.”“.$results[‘Call’].”“;
echo “

QSO Date: “.”“.$results[‘QSO_Begin’].”“;
echo “

Band: “.”“.$results[‘Band’].”“;
echo “

QSL Card Received Status: “.”“.$results[‘QSL_Rcvd’].”“;
echo “

QSL Card Sent Status: “.”“.$results[‘QSL_Sent’].”“;
echo “
“;
echo “_________________________

“;

}

}
else{ // if there is no matching rows do following
echo “No results“;
}

}
else{ // if query length is less than minimum
echo “Minimum length is “.$min_length;
}
[/insert_php]

Legend

QSL Card Received Status	Y = Your QSL Card has been received. Thanks!
	V = I received your QSL Card and the ARRL has Verified it for Credit! Thanks!
	R = I have the Card marked as Requested so I probably sent you one so please send me one back! 🙂
	Blank = Your Card has not been received. If you feel this is incorrect, please contact me.
QSL Card Sent Status	Y = I have sent you a QSL Card either direct or via the ARRL Bureau.
	R = I have the QSO marked to send you a card but sometimes the software marked this automaticaly.
	N = You did not send me a QSL or request one.
	Blank = A card has not been sent for this QSO.
No Results	No Results = You are not in my log at this time.

 

I am a QSL Card collector(hoarder) so a qsl card in the mail is always appreciated. I return 100%! I especially like receiving DX cards. I also upload 100% to Logbook of the World and EQSL although I do prefer LOTW. If you don’t have an LOTW account, please sign up for one! In the mean time, just send me a QSL Card in the mail.

I don’t require an SASE or IRCs or even Green Stamps to send one back!

This page was last updated on 4/30/2014. Log current as of 4/30/14.