PHP - Implementing Search On A Displayed Table

Somewhat new with PHP but I think I'm on the right track. I'm trying to search for a serial number on a sql table. I want a response of the serial # and what column its in. There is 4 columns if that helps (id, 30, 32, 31). (serials 002062008002220 002062008002222 002062008002233 are in the table) When I enter in a serial # 002062008002220 (all serials are 16 digits long). I get a blank page to show up...  my form

<form action="search.php" method="get">
<input id="serials" type="text" name="serials" />
<input type="submit" />
</form>

my php

<?php

$con=mysqli_connect("localhost", "xxx", "xxx", "nsmserials");

if (mysqli_connect_errno ()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

$search = mysql_real_escape_string($_REQUEST['serials']);
$query = "SELECT 30, 32, 31 FROM nsmtable WHERE 30 LIKE '%$search%' OR 32 LIKE '%$search%' OR 31 LIKE '%$search%'";

$result = mysql_query($query);

while ($row = mysql_fetch_array($result)){
    echo "<li><span class='name'><b>{$row['serials']}</b></span></li>";
}

mysqli_close($con);

?>

Looking for help with a small task for my weather station website.
Has already created a MySQL database where values are entered every hour.

Want to see on my website a table with current temperature or other types of measurements for each hour.
The idea is that users select a "Year", "Month" and Which info they want displayed, which is then displayed in an HTML table.
Info that can be chosen from is e.g. temperature, mm rain, air pressure, mm.

A small fee is usually given.

the website:
Se the page

Examples of desired solutions:
http:Sample 1
Sample 2

 

Hi,

I am trying to write the code the read a search form however it is not reading my table 'productdbase' to return any results.

I can echo from this table so I know it works but so far it just returns "Your search for 'Keyword' returned no results" as per below.

Can anyone advise please.


Code: [Select]
$results = "SELECT 'description', 'fulldescription'  FROM 'productdbase' WHERE $where";
Code: [Select]
<?php
if (isset($_POST['keywords'])){
 $keywords = mysql_real_escape_string (htmlentities(trim($_POST['keywords'])));
}

$errors = array();

if (empty($keywords)) {
$errors[] = 'Please enter a search term';
} else if (strlen($keywords)<3) {
$errors[] = 'Your search must be three or more characters';
} else if (search_results($keywords) === false) {
$errors[] = 'Your search for '.$keywords.' returned no results';
}

if (empty($errors)) {

search_results ($keywords);

} else{
foreach($errors as $error) {
echo $error, '</br>';
}
}


    ?>


<?php
function search_results ($keywords) {
$returned_results = array();
$where = "";

$keywords = preg_split('/[\s]+/', $keywords);
$total_keywords = count($keywords);

foreach($keywords as $key=>$keyword) {
$where .= "'keywords' LIKE '%$keyword%'";
if ($key != ($total_keywords - 1)) {
$where .= " AND ";

}
}


$results = "SELECT 'description', 'fulldescription'  FROM 'productdbase' WHERE $where";
$results_num = ($results = mysql_query($results)) ? mysql_num_rows($results) : 0;

if ($results_num === 0) {
return false;
}else{
echo 'something found.';
}




}
?>

<?php

if(isset($_POST['ActivityId']))

{

require_once('database.php');

$Search=$_POST['Search'];

$query="select * from registration where Flag='A' AND Activity like '%,$Search,%'";

$result=mysqli_query($dbc,$query) or die('Not Connected');

while($row=mysqli_fetch_array($result))

{

echo "<table border='2'><tr><td> Name--".$row['Name']."</td>

<td>Contact Number--".$row['ContactNumber']."</td>

<td>Email--".$row['Email']."</td>

<td>Address--".$row['Address']."</td></tr></table>";

}

}

elseif(isset($_POST['EventId'])){

require_once('database.php');

$Search=$_POST['Search'];

$query="select * from participation where EventId ='$Search'";

$result=mysqli_query($dbc,$query) or die('Not Connected');

while($row=mysqli_fetch_array($result)){

$LoginId= $row['LoginId'];

echo $LoginId;}

$query="select * from registration where LoginId='$LoginId'";

$result=mysqli_query($dbc,$query) or die('Not Connected to Reg');

while($row=mysqli_fetch_array($result)){

echo "<table border='2'><tr><td> Name--".$row['Name']."</td>

<td>Contact Number--".$row['ContactNumber']."</td>

<td>Email--".$row['Email']."</td>

<td>Address--".$row['Address']."</td></tr></table>";

}}



elseif(isset($_POST['Location']))

{

require_once('database.php');

$Search=$_POST['Search'];

$query="select * from registration where Flag='A' AND Address like '%$Search%'";

$result=mysqli_query($dbc,$query) or die('Not Connected');

while($row=mysqli_fetch_array($result))

{

echo "<table border='2'><tr><td> Name--".$row['Name']."</td>

<td>Contact Number--".$row['ContactNumber']."</td>

<td>Email--".$row['Email']."</td>

<td>Address--".$row['Address']."</td></tr></table>";

}

}



elseif(isset($_POST['BloodGroup']))

{

require_once('database.php');

$Search=$_POST['Search'];

$query="select * from registration where Flag='A' AND BloodGroup ='$Search'";

$result=mysqli_query($dbc,$query) or die('Not Connected');

while($row=mysqli_fetch_array($result))

{

echo "<table border='2'><tr><td> Name--".$row['Name']."</td>

<td>Contact Number--".$row['ContactNumber']."</td>

<td>Email--".$row['Email']."</td>

<td>Address--".$row['Address']."</td></tr></table>";

}

}

?>

<html><body><form action='<?php echo $_SERVER['PHP_SELF']?>' method="post">

<input type="text" name="Search"><br>

<input type="submit" name="ActivityId" value="Submit Activity Id"><br>

<input type="submit" name="EventId" value="Submit Event Id"><br>

<input type="submit" name="Location" value="Submit Location"><br>

<input type="submit" name="BloodGroup" value="Submit Blood Group"><br>



</form>

</body></html>




Hi frds.............
I have two tables named "registration" and "participation". Registration table have some columns like "LoginId", "email","contact no.", "Name" etc.and participation table have 2 column named "LoginId" and "EventId".
Now if user enters EventId, I want to display the details like email,contact no. etc.
I have a code but it not works properly.......
If result have more than one row it only displays the email and contact no. of last one instead of all.
Plzzzzzzzzz help anyone...................
????????/

I have made a data table out of my mySQL table and I should have a search option.
Lik where you have 3 boxes on one line :
Naam - Date1 - Date2
Naam is just searching results with that value
You can insert Date1 and Date 2 and then it must search between those dates.
But what will it do if i only put 1 date ? Like 2011-12-23 and date2 open
will it then only show the dates from 2011-12-23 ?   <html><body><?php$username="";$password="";$database="";mysql_connect(localhost,$username,$password);@mysql_select_db($database) or die( "Unable to select database");$query = "SELECT middenoosten2.*, users.naam ". "FROM middenoosten2, users ". "WHERE middenoosten2.speler = users.inlog order by id asc";$result=mysql_query($query);$num=mysql_numrows($result);mysql_close();?><p><b>Scores middenoosten : Zee en rivieren</b></p><table border="1" cellspacing="2" cellpadding="2"><tr><th><font face="Arial, Helvetica, sans-serif">Id</font></th><th><font face="Arial, Helvetica, sans-serif">Naam</font></th><th><font face="Arial, Helvetica, sans-serif">Score 11/...</font></th><th><font face="Arial, Helvetica, sans-serif">datum</font></th><th><font face="Arial, Helvetica, sans-serif">uur</font></th><th><font face="Arial, Helvetica, sans-serif">percent</font></th><th><font face="Arial, Helvetica, sans-serif">duur</font></th></tr><?php$i=0;while ($i < $num) {$f1=mysql_result($result,$i,"id");$f2=mysql_result($result,$i,"naam");$f3=mysql_result($result,$i,"score");$f4=mysql_result($result,$i,"datum");$f5=mysql_result($result,$i,"tijd");$f6=mysql_result($result,$i,"percent");$f7=mysql_result($result,$i,"crono");?><tr><td><font face="Arial, Helvetica, sans-serif"><?php echo $f1; ?></font></td><td><font face="Arial, Helvetica, sans-serif"><?php echo $f2; ?></font></td><td><font face="Arial, Helvetica, sans-serif"><?php echo $f3; ?></font></td><td><font face="Arial, Helvetica, sans-serif"><?php echo $f4; ?></font></td><td><font face="Arial, Helvetica, sans-serif"><?php echo $f5; ?></font></td><td><font face="Arial, Helvetica, sans-serif"><?php echo $f6; ?></font></td><td><font face="Arial, Helvetica, sans-serif"><?php echo $f7; ?></font></td></tr><?php$i++;}?></body></html>()

Thank you

Hello All,

Iam completely new (3days old) to sql, php, html, so could do with a little help.
Ok so I just found out about this wonderfull world and thought i would give it a try and I like it.

But as I have no real idea of what Iam doing Iam finding it abit tricky to change some of the code I found at.
http://www.phpfreaks.com/tutorial/simple-sql-search
By the way thanks for this.
So far I have setup a wamp server and got it all working fine and tweeked the above details in the url.
This works great (well chuffed).
But I could do with changing two things for now.

1). I could do with beeing able to search multiple things in the one text box for example.
If I inputed "hello world" or "hel wor" it would search through the 19,000 lines in my database and find all instances of "hello" and "world" or "hel" "wor" in the same line's, it dosent matter what column they are in and output those lines. The code has the option to search all feilds "matchall" but not multiple words or parts of words.(hope that made sense I dont know all the terminology)
It could be like using wild cards I suppose??.
Is this possible or would I need multiple search boxes and if so how would I do that?

2). I would like the results to be returned in a table with headings for each column.

If any one can help this would be great and thanks in advance for checking the long post out.

Nick.

Sorry if this is out there already but not to sure what I need to search for!??!?!?


Ill include what Iam using so far.



<?php
$dbHost = 'localhost'; // localhost will be used in most cases
// set these to your mysql database username and password.
$dbUser = 'root';
$dbPass = '';
$dbDatabase = 'Stk_search'; // the database you put the table into.
$con = mysql_connect($dbHost, $dbUser, $dbPass) or trigger_error("Failed to connect to MySQL Server. Error: " . mysql_error());

mysql_select_db($dbDatabase) or trigger_error("Failed to connect to database {$dbDatabase}. Error: " . mysql_error());

// Set up our error check and result check array
$error = array();
$results = array();

// First check if a form was submitted.
// Since this is a search we will use $_GET
if (isset($_GET['search'])) {
   $searchTerms = trim($_GET['search']);
   $searchTerms = strip_tags($searchTerms); // remove any html/javascript.

    if (strlen($searchTerms) < 3) {
        $error[] = "Search terms must be longer than 3 characters.";
    }else {
          $searchTermDB = mysql_real_escape_string($searchTerms); // prevent sql injection.
    }
             
     // If there are no errors, lets get the search going.
     if (count($error) < 1) {
     $searchSQL = "SELECT id, Stock_Code, SV_Part_Number, SV_Description, SV_Search_Key FROM stkdb1 WHERE ";
     
     // grab the search types.
     $types = array();
     $types[] = isset($_GET['Stock_Code'])?"`Stock_Code` LIKE '%{$searchTermDB}%'":'';
     $types[] = isset($_GET['SV_Part_Number'])?"`SV_Part_Number` LIKE '%{$searchTermDB}%'":'';
     $types[] = isset($_GET['SV_Description'])?"`SV_Description` LIKE '%{$searchTermDB}%'":'';
     $types[] = isset($_GET['SV_Search_Key'])?"`SV_Search_Key` LIKE '%{$searchTermDB}%'":'';
     
     $types = array_filter($types, "removeEmpty"); // removes any item that was empty (not checked)
     
     if (count($types) < 1)
      $types[] = "`Stock_Code` LIKE '%{$searchTermDB}%'"; // use the body as a default search if none are checked
     
      $andOr = isset($_GET['matchall'])?'AND':'OR';
      $searchSQL .= implode(" {$andOr} ", $types) . " ORDER BY `Stock_Code`"; // order by title.
     
      $searchResult = mysql_query($searchSQL) or trigger_error("There was an error.<br/>" . mysql_error() . "<br />SQL Was: {$searchSQL}");
     
       if (mysql_num_rows($searchResult) < 1) {
            $error[] = "The search term provided {$searchTerms} yielded no results.";
        }else {
        $results = array(); // the result array                                                 
        $i = 1;
        while ($row = mysql_fetch_assoc($searchResult)) {
          $results[] = "{$i}: {$row['Stock_Code']}<br />{$row['SV_Part_Number']}<br />{$row['SV_Description']}<br />{$row['SV_Search_Key']}<br /><br />";
          $i++;
          }
          }
          }
          }

 
function removeEmpty($var) {
  return (!empty($var));
  }
           
?>
<html>
   <title>My Simple Search Form</title>
    <style type="text/css">
    #error {
    color: red;
   }
   </style>
    <body>
      <?php echo (count($error) > 0)?"The following had errors:<br /><span id=\"error\">" . implode("<br />", $error) . "</span><br /><br />":""; ?>
      <form method="GET" action="<?php echo $_SERVER['PHP_SELF'];?>" name="searchForm">
            Search For: <input type="text" name="search" value="<?php echo isset($searchTerms)?htmlspecialchars($searchTerms):''; ?>" /><br />
            Search In:<br />
            Stock_Code: <input type="checkbox" name="Stock_Code" value="on" <?php echo isset($_GET['Stock_Code'])?"checked":''; ?> /> |
            SV_Part_Number: <input type="checkbox" name="SV_Part_Number" value="on" <?php echo isset($_GET['SV_Part_Number'])?"checked":''; ?> /> |
            SV_Description: <input type="checkbox" name="SV_Description" value="on" <?php echo isset($_GET['SV_Description'])?"checked":''; ?> /> |
            SV_Search_Key: <input type="checkbox" name="SV_Search_Key" value="on" <?php echo isset($_GET['SV_Search_Key'])?"checked":''; ?> /><br />
              Match All Selected Fields? <input type="checkbox" name="matchall" value="on" <?php echo isset($_GET['matchall'])?"checked":''; ?><br /><br />
            <input type="submit" name="submit" value="Search!" />
          </form>
          <?php echo (count($results) > 0)?"Your search term: {$searchTerms} returned:<br /><br />" . implode("", $results):""; ?>

         </body>
        </html> 

im a complete novice.

im using one of the tutorials on here to make a simple search form. the bit of script that i think outputs the results is

        $results = array(); // the result array
         $i = 1;
         while ($row = mysql_fetch_assoc($searchResult)) {
            $results[] = "{$i}: {$row['placing']}, &nbsp  {$row['racedate']}, &nbsp  {$row['horseid']}<br /><br />";
            $i++;

how do i make these results appear in a table, and how would i make it so there was a link on the date that clicked would show all the races on that day?

sorry i advance as this is probably the most dumb of questions!

Hello!

I have this code

Code: [Select]
<?php

include_once('../database_connection.php');


$thiskeyword = addslashes($_REQUEST['keyword']);

$sqlquery = "Select * from nba_info where player_id like '%$thiskeyword' OR fname like '%$thiskeyword' OR lname like '%$thiskeyword' OR team like '%$thiskeyword' OR email like '%$thiskeyword'";


$result = MYSQL_QUERY($sqlquery);
$numberOfRows = MYSQL_NUM_ROWS($result);


?>





<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Search Result</title>
</head>

<body><center><br /><br />
<?php



if($numberOfRows==0)
{

die('You keywords haven\'t much any data from the database');
        
}
else if($numberOfRows>0)
{
echo $numberOfRows. " Results have been found!";
$i = 0;


?>

<table>
<tr>
    <td>player_id</td>
   
    <td>fname</td>
 
    <td>lname</td>

    <td>team</td>

    <td>email</td>
       
    </tr>
 
 
<?php

while($i<$numberOfRows)
{

$player_id = MYSQL_RESULT($result,$i,"player_id");
$fname = MYSQL_RESULT($result,$i,"fname");
$lname = MYSQL_RESULT($result,$i,"lname");
$team = MYSQL_RESULT($result,$i,"team");
$email = MYSQL_RESULT($result,$i,"email");


?>



<tr>
   
    <td><? echo $player_id; ?></td>
<td><? echo $fname; ?></td>
<td><? echo $lname; ?></td>
<td><? echo $team; ?></td>
<td><? echo $email; ?></td>

    </tr>

<?php

$i++;

}

?>


</table>

<?php } ?>



<ul>
<li><a href="/php/database/ManipulatingDatabase/add_database.php">Add New Player</a></li>
    <li><a href="/php/database/ManipulatingDatabase/edit_form.php">Edit Player</li>
    <li><a href="/php/database/ManipulatingDatabase/delete_form.php">Delete Player</li>
    <li><a href="/php/database/ManipulatingDatabase/search_form.php">Search Player</li>
    <li><a href="/php/database/ManipulatingDatabase/manipulate_database.php">BACK TO MAIN</a></li>
</ul>




</center>
</body>
</html>

I have no problem with the sql statement as  code

Code: [Select]
echo $numberOfRows. " Results have been found!";
is giving me a numbers of rows. The problem is the rows that have been found is not showing up in the html row.


I wonder what the problem is.. anyone?

I want to have a search product feature, but I would like members to be able to search multiple fields in one go i.e.  product_code, Product_name in one MySQL query.

The thing is, members have to be logged on, so the query must also only show results relating to that specific member, via the session[member_ID], my current query for listing products for that specific member is :

Code: [Select]
$sql = "SELECT productId, productCode, image, name, price, stock_level FROM product_inventory WHERE memberr_ID = '" . $_SESSION['SESS_mem_ID'] . ";
How would I change the above into a search query to search for productcode, productname and still only show results beloging to this member using the session data ? 

all help appreciated

So I want to implement the concept of "entitlements" on my website for articles, but am unsure of the most efficient way to code things.

@Barand looked at and was okay with my table structure, but my question deal with PHP...

Here is a basic ERD of the relevant tables...

	MEMBER >|-------||- MEMBERSHIP_PLAN -||-------|< MEMBESHIP_PLAN_VERSION -||-------|< ENTTLEMENT >0-------||- ARTICLE
	

 

Up until now, the user would click on an Article link, and my "article.php" script would grab the Category, Sub-Category and Article slug from the URL, and go look for the particular instance of the Article in MySQL.

But now I want to control who can see what - that is only Members at a certain paid level can see "premium" content.

 

Here are my tables...

 

MEMBERSHIP_PLAN

- id

- name

 

MEMBERSHIP_PLAN_VERSION

- id

- plan_id

- version_no

- start_date

- end_date

 

ENTITLEMENT

- id

- plan_id

- version_id

-article_id

 

ARTICLE

- id

- slug

- title

- body

 

And here is how I am thinking of approaching things, but would appreciate your thoughts...

	- Member clicks on a link to the article: "How to use Indexes to Tune MySQL"
	- article.php loads and grabs the category/Sub-Category/Slug from the URL
	 
	**new**
	- call getMembershipPlan( ) which grabs memberID from $_SESSION, queries MySQL , and returns "Membership Plan"
	- call getMembershipPlanVersion( ) which takes the Member's "Membership Plan", queries MySQL, and returns current/latest version
	- call getArticleEntitlement( ) which takes "Membership Plan", "Membership Plan Version" and "Article Slug", queries MySQL, and returns TRUE if this member is "entitled" to view the chosen Article
	**end of new**
	 
	- Take "Category", "Sub-Category' and "Article Slug", query MySQL, and return Article and related metadata
	- Populate Article on page, OR display error: "This article is only available to Premium Members..."
	

 

What do you think about this approach?

 

Is it a sin to have 3 PHP functions and make 3 calls to MySQL?  (This relates to my last thread asking about how much to store in my SESSION variable.

 

 

Edited February 18, 2020 by SaranacLake

Can someone help me please?....

I'm using this
Code: [Select]
<form name="form1" method="post" action="create-b.php" enctype="application/x-www-form-urlencoded" style="margin:0px">
<input name="name" value="Anonymous" type="text" MAXLENGTH="15" style="position:absolute;width:650px;left:67px;top:142px;z-index:4">
<input name="subject" value="(No subject)" MAXLENGTH="15" type="text" style="position:absolute;width:650px;left:67px;top:166px;z-index:5">
<textarea name="body" MAXLENGTH="255" type="text" style="position:absolute;left:67px;top:191px;width:650px;height:98px;z-index:6"></textarea>
<div id="captcha" style="position:absolute; overflow:hidden; left:10px; top:296px; z-index:8">
<input name="submit" type="submit" value="Create thread" style="position:absolute;left:614px;top:291px;z-index:7">
<?php
  require_once('captc/recaptchalib.php');
  $publickey = "**************************************";
  echo recaptcha_get_html($publickey);
?>
</form>On the HTML side and this

  require_once('captc/recaptchalib.php');
  $privatekey = "************************";
  $resp = recaptcha_check_answer ($privatekey,
                                $_SERVER["REMOTE_ADDR"],
                                $_POST["recaptcha_challenge_field"],
                                $_POST["recaptcha_response_field"]);

  if (!$resp->is_valid) {
    // What happens when the CAPTCHA was entered incorrectly
    die ("<font color='red'><font size='12'><strong><center>The verification code you entered appears to be incorrect!");
  } else {
CONTENT CONTENT CONTENT CONTENT CONTENT ETC

But it always returns "The verification code you entered appears to be incorrect!" Any idea what I'm doing wrong?...

I am trying to write a PHP script that implements the MD5 algorithm just so that I can better understand MD5's inner-workings. For those of you already familiar with how MD5 works, could you help me figure out why my script is not producing the correct output?

<?php
$string = "";

$a = "01100111010001010010001100000001"; // 0x67452301
$b = "11101111110011011010101110001001"; // 0xEFCDAB89
$c = "10011000101110101101110011111110"; // 0x98BADCFE
$d = "00010000001100100101010001110110"; // 0x10325476

$aa = $a;
$bb = $b;
$cc = $c;
$dd = $d;

// PADDED BINARY FOR NULL STRING, I.E.: ""
$binary_md5 = "10000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000";
$binary_md5_words = strlen($binary_md5) / 32;

// SPLIT BINARY INTO 16 32-BIT WORDS
for($i = 1; $i <= $binary_md5_words; $i++) {
    $m[] = substr($binary_md5, ($i - 1) * 32, 32);
}

// GENERATE T-VALUES
for($i = 0; $i < 64; $i++) {
    $T[] = Pad(decbin(floor(4294967296 * abs(sin($i+1)))), 32);
}

/*
// PRINT THE M[K] ARRAY
echo "<h1>m[k] Array</h1><br>";
print_r($m);
echo "<br><br>";

// PRINT THE T[t] ARRAY
echo "<h1>T[t] Array</h1><br>";
print_r($T);
echo "<br><br>";

// TEST ANDxy
echo "<h1>Test ANDxy</h1><br>";
echo "$m[0]<br>$T[0]<br>";
echo ANDxy($m[0], $T[0]);
echo "<br><br>";

// TEST ORxy
echo "<h1>Test ORxy</h1><br>";
echo "$m[0]<br>$T[0]<br>";
echo ORxy($m[0], $T[0]);
echo "<br><br>";

// TEST ADDxy
echo "<h1>Test ADDxy</h1><br>";
echo "$m[0]<br>$T[0]<br>";
echo ADDxy($m[0], $T[0]);
echo "<br><br>";

// TEST XORxy
echo "<h1>Test XORxy</h1><br>";
echo "$m[0]<br>$T[0]<br>";
echo XORxy($m[0], $T[0]);
echo "<br><br>";

// TEST NOTx
echo "<h1>Test NOTx</h1><br>";
echo "$m[0]<br>";
echo NOTx($m[0]);
echo "<br><br>";

// TEST SHIFTleft
echo "<h1>Test SHIFTleft</h1><br>";
echo "$m[0]<br>";
echo SHIFTleft($m[0], 1);
echo "<br><br>";

// TEST F
echo "<h1>Test F</h1><br>";
echo "X = $m[0]<br>Y = $m[1]<br>Z = $m[2]<br>F = ";
echo F($m[0], $m[1], $m[2]);
$step1 = ANDxy($m[0], $m[1]);
$step2 = ANDxy(NOTx($m[0]), $m[2]);
$step3 = ORxy($step1, $step2);
echo "<br>F = $step3";
echo "<br><br>";

// TEST H
echo "<h1>Test H</h1><br>";
echo "X = $m[0]<br>Y = $m[1]<br>Z = $m[2]<br>F = ";
echo H($m[0], $m[1], $m[2]);
echo "<br><br>";
*/

// ROUND 1
$a = ff($a, $b, $c, $d, $m, 0, 7, $T[0]);
$d = ff($d, $a, $b, $c, $m, 1, 12, $T[1]);
$c = ff($c, $d, $a, $b, $m, 2, 17, $T[2]);
$b = ff($b, $c, $d, $a, $m, 3, 22, $T[3]);

$a = ff($a, $b, $c, $d, $m, 4, 7, $T[4]);
$d = ff($d, $a, $b, $c, $m, 5, 12, $T[5]);
$c = ff($c, $d, $a, $b, $m, 6, 17, $T[6]);
$b = ff($b, $c, $d, $a, $m, 7, 22, $T[7]);

$a = ff($a, $b, $c, $d, $m, 8, 7, $T[8]);
$d = ff($d, $a, $b, $c, $m, 9, 12, $T[9]);
$c = ff($c, $d, $a, $b, $m, 10, 17, $T[10]);
$b = ff($b, $c, $d, $a, $m, 11, 22, $T[11]);

$a = ff($a, $b, $c, $d, $m, 12, 17, $T[12]);
$d = ff($d, $a, $b, $c, $m, 13, 12, $T[13]);
$c = ff($c, $d, $a, $b, $m, 14, 17, $T[14]);
$b = ff($b, $c, $d, $a, $m, 15, 22, $T[15]);

// ROUND 2
$a = gg($a, $b, $c, $d, $m, 1, 5, $T[16]);
$d = gg($d, $a, $b, $c, $m, 6, 9, $T[17]);
$c = gg($c, $d, $a, $b, $m, 11, 14, $T[18]);
$b = gg($b, $c, $d, $a, $m, 0, 20, $T[19]);

$a = gg($a, $b, $c, $d, $m, 5, 5, $T[20]);
$d = gg($d, $a, $b, $c, $m, 10, 9, $T[21]);
$c = gg($c, $d, $a, $b, $m, 15, 14, $T[22]);
$b = gg($b, $c, $d, $a, $m, 4, 20, $T[23]);

$a = gg($a, $b, $c, $d, $m, 9, 5, $T[24]);
$d = gg($d, $a, $b, $c, $m, 14, 9, $T[25]);
$c = gg($c, $d, $a, $b, $m, 3, 14, $T[26]);
$b = gg($b, $c, $d, $a, $m, 8, 20, $T[27]);

$a = gg($a, $b, $c, $d, $m, 13, 5, $T[28]);
$d = gg($d, $a, $b, $c, $m, 2, 9, $T[29]);
$c = gg($c, $d, $a, $b, $m, 7, 14, $T[30]);
$b = gg($b, $c, $d, $a, $m, 12, 20, $T[31]);

// ROUND 3
$a = hh($a, $b, $c, $d, $m, 5, 4, $T[32]);
$d = hh($d, $a, $b, $c, $m, 8, 11, $T[33]);
$c = hh($c, $d, $a, $b, $m, 11, 16, $T[34]);
$b = hh($b, $c, $d, $a, $m, 14, 23, $T[35]);

$a = hh($a, $b, $c, $d, $m, 1, 4, $T[36]);
$d = hh($d, $a, $b, $c, $m, 4, 11, $T[37]);
$c = hh($c, $d, $a, $b, $m, 7, 16, $T[38]);
$b = hh($b, $c, $d, $a, $m, 10, 23, $T[39]);

$a = hh($a, $b, $c, $d, $m, 13, 4, $T[40]);
$d = hh($d, $a, $b, $c, $m, 0, 11, $T[41]);
$c = hh($c, $d, $a, $b, $m, 3, 16, $T[42]);
$b = hh($b, $c, $d, $a, $m, 6, 23, $T[43]);

$a = hh($a, $b, $c, $d, $m, 9, 4, $T[44]);
$d = hh($d, $a, $b, $c, $m, 12, 11, $T[45]);
$c = hh($c, $d, $a, $b, $m, 15, 16, $T[46]);
$b = hh($b, $c, $d, $a, $m, 2, 23, $T[47]);

// ROUND 4
$a = ii($a, $b, $c, $d, $m, 0, 6, $T[48]);
$d = ii($d, $a, $b, $c, $m, 7, 10, $T[49]);
$c = ii($c, $d, $a, $b, $m, 14, 15, $T[50]);
$b = ii($b, $c, $d, $a, $m, 5, 21, $T[51]);

$a = ii($a, $b, $c, $d, $m, 12, 6, $T[52]);
$d = ii($d, $a, $b, $c, $m, 3, 10, $T[53]);
$c = ii($c, $d, $a, $b, $m, 10, 15, $T[54]);
$b = ii($b, $c, $d, $a, $m, 1, 21, $T[55]);

$a = ii($a, $b, $c, $d, $m, 8, 6, $T[56]);
$d = ii($d, $a, $b, $c, $m, 15, 10, $T[57]);
$c = ii($c, $d, $a, $b, $m, 6, 15, $T[58]);
$b = ii($b, $c, $d, $a, $m, 13, 21, $T[59]);

$a = ii($a, $b, $c, $d, $m, 4, 6, $T[60]);
$d = ii($d, $a, $b, $c, $m, 11, 10, $T[61]);
$c = ii($c, $d, $a, $b, $m, 2, 15, $T[62]);
$b = ii($b, $c, $d, $a, $m, 9, 21, $T[63]);

$a = ADDxy($a, $aa);
$b = ADDxy($b, $bb);
$c = ADDxy($c, $cc);
$d = ADDxy($d, $dd);

// ECHO RESULTS
echo "<h1>String</h1><br>";
echo "String: '$string'<br>";
$md5 = md5($string);
echo "MD5: $md5<br><br>";
$md5_1 = substr($md5, 0, 8);
$md5_2 = substr($md5, 8, 8);
$md5_3 = substr($md5, 16, 8);
$md5_4 = substr($md5, 24, 8);
echo "A = $md5_1<br>B = $md5_2<br>C = $md5_3<br>D = $md5_4<br><br>";
$md5_bin_a = Pad(decbin(hexdec($md5_1)), 32); 
$md5_bin_b = Pad(decbin(hexdec($md5_2)), 32); 
$md5_bin_c = Pad(decbin(hexdec($md5_3)), 32); 
$md5_bin_d = Pad(decbin(hexdec($md5_4)), 32); 
echo "A = $md5_bin_a<br>B = $md5_bin_b<br>C = $md5_bin_c<br>D = $md5_bin_d<br><br>";
echo "<h1>Results</h1><br>";
echo "A = $a<br>B = $b<br>C = $c<br>D = $d<br><br>";
$a_dec = bindec($a);
$b_dec = bindec($b);
$c_dec = bindec($c);
$d_dec = bindec($d);
$a_hex = dechex($a_dec);
$b_hex = dechex($b_dec);
$c_hex = dechex($c_dec);
$d_hex = dechex($d_dec);
echo "A = $a_hex<br>B = $b_hex<br>C = $c_hex<br>D = $d_hex<br><br>";

// FUNCTIONS
function ff($a, $b, $c, $d, $m, $k, $s, $t) {
    //a = b + ((a + F(b,c,d) + X[k] + T[i]) <<< s)
    return ADDxy($b, SHIFTleft(ADDxy(ADDxy(ADDxy($a, F($b, $c, $d)), $m[$k]), $t), $s));
}

function gg($a, $b, $c, $d, $m, $k, $s, $t) {
    //a = b + ((a + G(b,c,d) + X[k] + T[i]) <<< s)
    return ADDxy($b, SHIFTleft(ADDxy(ADDxy(ADDxy($a, G($b, $c, $d)), $m[$k]), $t), $s));
}

function hh($a, $b, $c, $d, $m, $k, $s, $t) {
    //a = b + ((a + H(b,c,d) + X[k] + T[i]) <<< s)
    return ADDxy($b, SHIFTleft(ADDxy(ADDxy(ADDxy($a, H($b, $c, $d)), $m[$k]), $t), $s));
}

function ii($a, $b, $c, $d, $m, $k, $s, $t) {
    //a = b + ((a + I(b,c,d) + X[k] + T[i]) <<< s)
    return ADDxy($b, SHIFTleft(ADDxy(ADDxy(ADDxy($a, I($b, $c, $d)), $m[$k]), $t), $s));
}

function F($X, $Y, $Z) {
    //return ($X & $Y) | ((~$X) & $Z);
    return ORxy(ANDxy($X, $Y), ANDxy(NOTx($X), $Z));
}

function G($X, $Y, $Z) {
    //return ($X & $Z) | ($Y & (~$Z));
    return ORxy(ANDxy($X, $Z), ANDxy($Y, NOTx($Z)));
}

function H($X, $Y, $Z) {
    //return $X ^ $Y ^ $Z;
    return XORxy(XORxy($X, $Y), $Z);
}

function I($X, $Y, $Z) {
    //return $Y ^ ($X | (~$Z));
    return XORxy($Y, ORxy($X, NOTx($Z)));
}

function Pad($binary, $pad_length) {
    $pad_length = $pad_length - strlen($binary);
    for($i = 0; $i < $pad_length; $i++) {
        $padding .= '0';
    }
    return $padding . $binary;
}

function mod($val, $div) {
    $r = $val - (floor($val/$div)*$div);
    return $r;
}
function ANDxy($x, $y) {
    $x_dec = bindec($x);
    $y_dec = bindec($y);
    
    $result = $x_dec & $y_dec;
    $result = Pad(decbin($result), strlen($x));
    
    return $result;   
}

function ORxy($x, $y) {
    $x_dec = bindec($x);
    $y_dec = bindec($y);
    
    $result = $x_dec | $y_dec;
    $result = Pad(decbin($result), strlen($x));
    
    return $result;   
}

function ADDxy($x, $y) {
    $x_dec = bindec($x);
    $y_dec = bindec($y);
    
    $result = mod($x_dec + $y_dec, pow(2, 32));
    $result = Pad(decbin($result), strlen($x));
    
    return $result;   
}

function XORxy($x, $y) {
    $x_dec = bindec($x);
    $y_dec = bindec($y);
    
    $result = $x_dec ^ $y_dec;
    $result = Pad(decbin($result), strlen($x));
    
    return $result;   
}

function NOTx($x) {
    $x_dec = bindec($x);
    
    $result = ~$x_dec;
    $result = Pad(decbin($result), strlen($x));
    
    return $result;
}

function SHIFTleft($x, $y) {
    $x_dec = bindec($x);
    
    $result = $x_dec << $y;
    $result = Pad(decbin($result), strlen($x));
    
    return $result;   
}

function SHIFTright($x, $y) {
    $x_dec = bindec($x);
    
    $result = $x_dec >> $y;
    $result = Pad(decbin($result), strlen($x));
    
    return $result;   
}
?>

I have a kind of search and react on my site. The user can search for a number in a column as below

$search = mysqli_real_escape_string($link, $_POST["query"]);

$query = "SELECT * FROM $table[$i] WHERE oemnr LIKE '".$search."%' ORDER BY model";

 

The code works fine but I want to expand the function to get match for other numbers also. The oemnr column today can be 12345 which shows up if the user type 12.... 

I want to expand the oemnr column as

12345/03124/34713, numbers separated with / or another character.

If the user type 03... or 34... I want to find and show 12345 because it is on the same row and corresponds to the numbers on the same row. Is it possible to do in mysql? In php that kind of operation can be done with the explode function but I don't know how to use with mysql.

Edited February 14 by jigga

Hi. Im trying to get my table so I can click on username and it will display ascending or click again and it descends.

I want to be able to do this will all of them..Username Password IP Country Type Status E-mail Date start Date end ..
If anyone can help me it would be great. I dont know PHP . I paid someone to make this for my and they binned it half way through the job taking my money...



Thank you

This is my code



<?php
if(session_is_registered('username')){
    include("header.php");
   
?>                 
            <div id="content_main" class="clearfix">
            <div id="main_panel_container" class="left">
   <div id="tabledata" class="section">
            <h2 class="ico_mug">Users table</h2>
            <?
            if($_GET['type']=='delete'){
                mysql_query("delete from users where id='".$_GET['id']."'");
                ?><div id="success" class="info_div"><span class="ico_success">User deleted successful!</span></div><?
            }
            if($_GET['type']=='edit'){
                if(isset($_POST['username'])){
                    mysql_query("UPDATE users SET username='".$_POST['username']."',
                                                  password='".$_POST['password']."',
                                                  ip='".$_POST['ip']."',
                                                  country='".$_POST['country']."'
                                 WHERE id='".$_GET['id']."'");
                }
                $row=mysql_fetch_array(mysql_query("SELECT * FROM users WHERE id='".$_GET['id']."'"));
                  ?>
                           <form action="" method="post" accept-charset="utf-8">
                           <fieldset>

                           <label>Username:<input type="text" name="username" value="<?echo $row['username'];?>" size=60/></label>
                           <label>Password:<input type="text" name="password" value="<?echo $row['password'];;?>" size=60/></label>
                           <label>IP:<input type="text" name="ip" value="<?echo $row['ip'];;?>" size=60/></label>
                           <label>Country:<input type="text" name="country" value="<?echo $row['country'];;?>" size=60/></label>
                             
                           <br />  <button>Submit</button>
             
                            </fieldset>
           
                            </form>
                            <button onclick="location.href='index.php?action=users';">Back</button>
                           <?
            }
            if($_GET['type']=='add'){
                if(isset($_POST)){
                    $j=0;
                    for($i=1; $i<=5; $i++){
                        if($_POST['username'.$i]!=''){
                        if(($_POST['username'.$i]!='') &&
                           ($_POST['password'.$i]!='') &&
                           ($_POST['ip'.$i]!='') &&
                           ($_POST['country'.$i]!=''))
                        {
                            if(($_POST['date_start'.$i]=='')||($_POST['date_end'.$i]=='')){
                                $date_start=0;
                                $date_end=0;
                            } else {
                            $date_start=strtotime($_POST['date_start'.$i]);
                            $date_end=strtotime($_POST['date_end'.$i]);
                            }
                            mysql_query("INSERT INTO users (username,password,ip,email,country,date_start,date_end) VALUES
                                        ('".$_POST['username'.$i]."','".$_POST['password'.$i]."','".$_POST['ip'.$i]."','".$_POST['email'.$i]."','".$_POST['country'.$i]."','".$date_start."','".$date_end."')
                                        ");
                            $j++;
                        } else {
                            ?><div id="fail" class="info_div"><span class="ico_cancel">Fields on the same row can't be blank</span></div><?
                        }
                        }
                    }
                    if($j>0){
                    ?><div id="success" class="info_div"><span class="ico_success"><? echo $j;?> users have been added!</span></div><?
                    }
                }
               
            ?>
            <fieldset>
            <i>
            Date format should be like 2000-05-25<br>
            Type: B for instant buy; S for subscription<br>
            Status: Y for active; N for inactive
            </i>
            </fieldset>
            <form action="" method="post" accept-charset="utf-8">
            <table id="table">
            <thead>
            <tr>
               
                <th>Username</th>
                <th>Password</th>
                <th>IP</th>
                <th>Email</th>
                <th>Country</th>
                <th>Type</th>
                <th>Status</th>
                <th>Date start</th>
                <th>Date end</th> 
            </tr>
            </thead>
            <tbody>
           
                           
           
                <?
                for ($i=1; $i<=5; $i++) {
?>
                <tr>
                <td>
                    <input type="text" name="username<?echo $i;?>" size="10">
                </td>
                <td>
                    <input type="text" name="password<?echo $i;?>" size="10">
                </td>
                <td>
                    <input type="text" name="ip<?echo $i;?>" size="10">
                </td>
                <td>
                    <input type="text" name="email<?echo $i;?>" size="10">
                </td>
                <td>
                    <select name="country<?echo $i;?>">
                        <option value="UK">UK</option>
                        <option value="US">US</option>
                    </select>
                </td>
                <td>
                    <select name="type<?echo $i;?>">
                        <option value="B" selected>B</option>
                        <option value="S">S</option>
                    </select>
                </td>
                <td>
                    <select name="status<?echo $i;?>">
                        <option value="Y" selected>Y</option>
                        <option value="N">N</option>
                    </select>
                </td>
                <td>
                    <input type="text" name="date_start<?echo $i;?>"  size="10">
                </td>
                <td>
                    <input type="text" name="date_end<?echo $i;?>" size="10">
                </td>
                </tr>
                <? } ?>
           
            <tr>
            <td><button>Submit</button> </td>
            </tr> 
                           
           
                           
            </tbody>
            </table>
            </form>
            <br>
            <?
           
            }
           
?>
       
       <?php
           
         if($_GET['type']=='import')
         {
            
            if($_POST['import'] && $_FILES['flimport']['name']!='')
            {
               //print_r($_FILES);
               $fieldseparator = ",";
               $lineseparator = "\n";
               $csvfile=$_FILES['flimport']['tmp_name'];
               $size = $_FILES['flimport']['size'];
               if(!$size) {
                  exit;
               }
               $file = fopen($csvfile,"r");
               $csvcontent = fread($file,$size);
               fclose($file);
               //////////////////////////////////////////////////////////////
               $lines = 0;
               $queries = 0;
               $linearray = array();
               foreach(split($lineseparator,$csvcontent) as $line) {
               
                  $lines++;
               
                  $line = trim($line," \t");
                  
                  $line = str_replace("\r","",$line);
                  $line = str_replace("'","\'",$line);
                  
                  $linearray = explode($fieldseparator,$line);
                  
                  $linemysql = implode("','",$linearray);
                  $exist=0;
                  if(is_numeric($linearray[0]))
                  {
                     $exist=mysql_num_rows(mysql_query("select id from users where username='".$linearray[2]."' or email='".$linearray[1]."'"));
                        $query = "insert into users values('$linemysql');";
                     
                  }
                  else
                  {
                     $exist=mysql_num_rows(mysql_query("select id from users where username='".$linearray[1]."' or email='".$linearray[0]."'"));
                        $query = "insert into users values('','$linemysql');";
                     
                  }
                  //echo $query."<br />";
                  if($exist==0)
                  {
                     @mysql_query($query);               
                     if(mysql_insert_id())
                        $queries++;
                  }
               }   
               
                  echo '<div id="success" class="info_div"><span class="ico_success">'.$queries.' users added successfully</span></div>';
               
            }
         ?>
            <form name="frmImport" action="" method="post" enctype="multipart/form-data">
            <input type="hidden" value="1" name="import" />
                <table id="table">
                <tbody>
                   <tr>
                         <td><span style="font-size:10px; color:#333">Note: Please entry ms excel <strong>.CSV (Comma delimited)</strong> file only</span></td>
                    </tr>
                    <tr>
                         <td><input type="file" accept="application/msexcel" name="flimport" />
                        </td>
                    </tr>
                    <tr>
                         <td><button>Import Now</button></td>
                    </tr>
                   </tbody>
                  </table>
            </form>
         <br />
         <?php } ?>
      
      <button onclick="location.href='index.php?action=users&type=add';">Add users</button>
      &nbsp;<button onclick="location.href='index.php?action=users&type=import';" name="btnimport">Import users</button>
         &nbsp;<button onclick="location.href='export.php?datafrom=users';" name="btnexport">Export users</button>
      
      
      
        <table id="table">
            <thead>
            <tr>
                <th>Actions</th>
                <th>Username</th>
                <th>Password</th>
                <th>IP</th>
                <th>Country</th>
                <th>Type</th>
                <th>Status</th>
                <th>E-mail</th>
                <th>Date start</th>
                <th>Date end</th>
               
            </tr>
            </thead>
            <tbody>
            <?
            if (isset($_GET["page"])) { $page  = $_GET["page"]; } else { $page=1; }
            $start_from = ($page-1) * 20;
            $query=mysql_query("SELECT * FROM users WHERE 1 LIMIT $start_from, 20");
            while($row=mysql_fetch_array($query)){
               
           
?>
            <tr>
                <td><a href="index.php?action=users&type=delete&id=<?echo $row['id'];?>"><img src="img/cancel.jpg" alt="cancel"/></a><a href="index.php?action=users&type=edit&id=<?echo $row['id'];?>"><img src="img/edit.jpg" alt="edit"/></a></td>
                <td><?echo $row['username'];?></td>
                <td><?echo $row['password'];?></td>
                <td><?echo $row['ip'];?></td>
                <td><?echo $row['country'];?></td>
                <td><?echo $row['type'];?></td>
                <td><?echo $row['status'];?></td>
                <td><?echo $row['email'];?></td> 
                <td class="table_date"><?echo date("Y-m-d",$row['date_start']);?></td>
                <td class="table_date"><?echo date("Y-m-d",$row['date_end']);?></td>
            </tr>
           
            <?
            }
?>
            </tbody>
        </table>
        <?
           
            $rs_result = mysql_query("SELECT COUNT(id) FROM users");
            $row = mysql_fetch_row($rs_result);
            $total_records = $row[0];
            $total_pages = ceil($total_records / 20);
             
?>
           
            <div class="pagination">
                <span class="pages">Page 1 of <?echo $total_pages;?></span>
               
                <?php
                for ($i=1; $i<=$total_pages; $i++) {
                if($page==$i){
                    ?><span class="current"><b><?echo $page;?></span></b><?
                } else {
                    echo "<a href='index.php?action=users&type=view&page=".$i."'>".$i."</a> ";
                }
                }
                if($total_pages>1){
                $next=$page+1;
               
                ?>
                <a href="index.php?action=users&type=view&page=<? echo $next;?>" >&raquo;</a>
                <?
                }
?>
            </div>
        </div> <!-- end #tabledata -->

              <?
        include("shortcuts.php");
        ?>
            </div>
        <?
       
        ?>
        </div><!-- end #content_main -->


       
        </div><!-- end #content -->
 <?
    include("footer.php");
?>

<?
    } else {
    header( "Location: index.php?action=login" );
}
?>

I registered a few days ago for help on this thread but didn't post again on it now because it has been marked answered and I thought I'd better not bump it.  I received help in a way that has been the most encouraging since I began my calendar project.  I'm wondering, though, if you would help me understand why I'm not successful at implementing the advice to the point that events are inserting into my calendar.    My testing database has only one table:  events and in events, only two columns (other than id):  "startdt" and "description".  This is a screenshot of how the table's columns are set upL    screenshot.jpg   37.21KB   0 downloads   This is a screenshot of the table content:    screenshot2.jpg   9.35KB   0 downloads   This is my code with the edits added from the support thread:

<?PHP

$var = mysql_real_escape_string($_GET['startdt, description']);

$con=mysql_connect("localhost","user","password");
// Check connection
if (mysql_connect_error()) {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
    //select a database to work with
    $selected = mysql_select_db("mydatabase_",$con) 
      or die("Could not select mydatabase_");

    //execute the SQL query and return records
    $result = mysql_query("SELECT information FROM events WHERE value='$startdt', 'description'");
    //fetch tha data from the database
    while ($row = mysql_fetch_array($result)) {
       echo $row{'startdt, description'};
    }

    //close the connection
    mysql_close($con);

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<link rel="stylesheet" href="css/master.css" type="text/css" media="all">
<meta http-equiv="Content-Type" content="text/html" />
<title>Yet Another Test</title>
</head>
<body>
<?php
    $currMonth = isset($_GET['month']) ? $_GET['month']  : date('n');
    $currYear  = isset($_GET['year'])  ? $_GET['year']   : date('Y');
    $today = (($currYear == date('Y')) && ($currMonth == date('n'))) ? date('j') : 0;

    $prevMonth = $currMonth==1 ? 12 : $currMonth-1;
    $nextMonth = $currMonth==12?  1 : $currMonth+1;
    $prevYear = $currMonth==1 ? $currYear-1 : $currYear;
    $nextYear = $currMonth==12? $currYear+1 : $currYear;

    $day1 = mktime(0,0,0,$currMonth,1,$currYear);
    $dim = date('t', $day1);
    $dayN = mktime(0,0,0,$currMonth,$dim,$currYear);
    $dow1 = (date('w',$day1)+0) % 7;
    $dowN = (date('w',$dayN)+0) % 7;
    $calHead = date('F Y',$day1);
    	echo <<<EOT
    	<div class="calwrapper">
    	<div class="caltitle"><h1>Calendar</h1></div>
    	<div class="container">
    	<div class="fnl first"></div>
    	<div class="adjust"></div>
    	<div class="fnl last"></div>
    	</div>
    	<div class="caldisplay">
        <table cellspacing="0">
        <tr>
        <td class="hd"><a class="cal_button" href="$_SERVER[PHP_SELF]?year=$prevYear&month=$prevMonth"> Prev </a></td>
        <td colspan="5" class="adjust">$calHead</td>
        <td class="hd"><a class="cal_button" href="$_SERVER[PHP_SELF]?year=$nextYear&month=$nextMonth"> Next </a></td>
        </tr>
        <tr>
          <th class="we">Sun</th>
          <th class="wd">Mon</th>
          <th class="wd">Tue</th>
          <th class="wd">Wed</th>
          <th class="wd">Thu</th>
          <th class="wd">Fri</th>
          <th class="we">Sat</th>
         </tr>
        <tr>
EOT;
    for ($d=0;$d<$dow1;$d++) echo "<td class=\"hd\"> </td>";
    $c = $dow1;
    for ($d=1; $d<=$dim; $d++, $c++) {
        if ($c%7==0) echo "</tr><tr>";
        $cl = ($c%7==5) || ($c%7==6) ? 'we' : 'wd';
        $st = ($d == $today) ? "style='padding: 0px;'" : '';
        echo "<td class=\"$cl\" $st>\n";
        echo "$d" ;
        echo "</td>\n";
    }
    while ($c++ % 7 != 0) echo '<td class=\"hd\"> </td>';
    echo "</tr></table>\n";
    echo '</div></div>';
    
// calander entries. Use the date as the key (in YYYY/MM/DD format)
$entries = array(
	'2014/8/16' => array(
        				'Event',
					),
	
);
    for ($d=1; $d<=$dim; $d++, $c++) {

        if ($c%7==0) echo "</tr><tr>";

        $cl = ($c%7==5) || ($c%7==6) ? 'we' : 'wd';

        $st = ($d == $today) ? "style='padding: 0px;'" : '';

        echo "<td class=\"$cl\" $st>\n";

        echo "$d" ;

        echo "</td>\n";

    }

// construct the date, this will be used to check to if the key exists in the $entries array
        $dateKey = "$currYear/$currMonth/$d";
        // check if the key exists in the $entries array
        if(array_key_exists($dateKey, $entries)) {
            // for each event, list it in a seperate tool tip
            foreach($entries[$dateKey] as $entry) {
                echo '<div class="has-tooltip">
           Event
            <span class="tooltip">'.$entry.'</span>
        </div>';
            }
        }    
    
?>
</body>
</html>

I am not getting any errors in the PHP Code Checker (although I am receiving the notice that these functions are now deprecated): mysql_close() mysql_connect() mysql_fetch_array() mysql_query() mysql_real_escape_string() mysql_select_db() When I upload my page to the server, everything seems fine, except that no information is added to the table.  When I check the page source, I see this:

 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
 <meta http-equiv="content-type" content="text/html; charset=utf-8" />
<link rel="stylesheet" href="css/master.css" type="text/css" media="all">
<meta http-equiv="Content-Type" content="text/html" />
<title>Yet Another Test</title>
</head>
<body>
    	<div class="calwrapper">
    	<div class="caltitle"><h1>Calendar</h1></div>
    	<div class="container">
    	<div class="fnl first"></div>
    	<div class="adjust"></div>
    	 <div class="fnl last"></div>
    	 </div>
    	 <div class="caldisplay">
        <table cellspacing="0">
        <tr>
          <td class="hd"><a class="cal_button" href="/1cal/calendar.php?year=2014&month=7"> Prev </a></td>
          <td colspan="5" class="adjust">August 2014</td>
          <td class="hd"><a class="cal_button" href="/1cal/calendar.php?year=2014&month=9"> Next </a></td>
        </tr>
        <tr>
          <th class="we">Sun</th>
          <th class="wd">Mon</th>
          <th class="wd">Tue</th>
          <th class="wd">Wed</th>
          <th class="wd">Thu</th>
          <th class="wd">Fri</th>
          <th class="we">Sat</th>
         </tr>
        <tr><!--DEBUG: year=$currYear and month=$currMonth<hr/--><td class="hd">&nbsp;</td><td class="hd">&nbsp;</td><td class="hd">&nbsp;</td><td class="hd">&nbsp;</td><td class="hd">&nbsp;</td><td class="we" >
1</td>
<td class="we" >
2</td>
</tr><tr><td class="wd" >
3</td>
<td class="wd" >
4</td>
<td class="wd" >
5</td>
<td class="wd" >
6</td>
<td class="wd" >
7</td>
<td class="we" >
8</td>
<td class="we" >
9</td>
</tr><tr><td class="wd" >
10</td>
<td class="wd" >
11</td>
<td class="wd" >
12</td>
<td class="wd" >
13</td>
<td class="wd" >
14</td>
<td class="we" style='padding: 0px;'>
15</td>
<td class="we" >
16</td>
</tr><tr><td class="wd" >
17</td>
<td class="wd" >
18</td>
<td class="wd" >
19</td>
<td class="wd" >
20</td>
<td class="wd" >
21</td>
<td class="we" >
22</td>
<td class="we" >
23</td>
</tr><tr><td class="wd" >
24</td>
<td class="wd" >
25</td>
<td class="wd" >
26</td>
<td class="wd" >
27</td>
<td class="wd" >
28</td>
<td class="we" >
29</td>
<td class="we" >
30</td>
</tr><tr><td class="wd" >
31</td>
<td class=\"hd\"> </td><td class=\"hd\"> </td><td class=\"hd\"> </td><td class=\"hd\"> </td><td class=\"hd\"> </td><td class=\"hd\"> </td></tr></table>
</div></div></body>
</html>

I don't have an understanding of what the Debug is telling me although I note the number "1" within the tag and find that interesting because on those occasions, earlier today, when the file upload would result in a white page, viewing the page source would reveal nothing but the numeral "1" in the upper left top.   Are the deprecated functions enough to cause the event not to insert into the calendar?  I'd appreciate any help in sorting why I'm not succeeding.  As you see so often around here, I'm not a coder.  I'm just forced into a position to have to fend for myself, as of late, and so I'm trying to learn what I can.  Thank you for any help. 
Edited by Izzy-B, 15 August 2014 - 07:24 PM.