PHP - Moved: Base Table Or View Not Found Help!

Here is a link to the website I am designing. http://173.167.65.189/singleton/
the username and password is ksingleton
at the bottom where the calendar is the query is searching for scheduled events, i am only posting the company_id right now,  the problem I am having is I want a scheduled event that continues through the week to stay in line with the one before.  But if the schedule before ended and a new one continues it moves the next date company_id up.  How can i align the table rows or create an empty table row on all other days if there was a schedule before.  here is the code for the calendar.

Quote

<?php
$db = new mysqli();
$setdate=strtotime($_GET['date']);
$session=$_GET['session'];
$calview=$_GET['calview'];
if ($setdate <> "") {
   $date=$setdate;
} else {
$date=time();
}
$day=date('d',$date);
$month=date('m',$date);
$year=date('Y',$date);
$first_day=mktime(0,0,0,$month,1,$year);
$title=date('F',$first_day);

$day_of_week = date('D', $first_day);

switch($day_of_week) {
case "Sun": $blank = 0;break;
case "Mon": $blank = 1;break;
case "Tue": $blank = 2;break;
case "Wed": $blank = 3;break;
case "Thu": $blank = 4;break;
case "Fri": $blank = 5;break;
case "Sat": $blank = 6;break;
}

$days_in_month = cal_days_in_month(0, $month, $year);

echo "<table cellpadding=0 cellspacing=0 border=0>";
echo "<tbody>";
echo "<tr>";
echo "<td><a href=?session=$session&calview=day>Day</a></td>";
echo "<td><a href=?session=$session&calview=week>Week</a></td>";
echo "<td><a href=?session=$session&calview=month>Month</a></td>";
echo "</tr>";
echo   "<tr>";
echo      "<td colspan=3>";
if ($calview=="month") {
echo         "<table border=1 width=800>";
echo            "<tbody>";
echo               "<tr height=25><th colspan=7> $title $year </th></tr>";
echo               "<tr height=25><td width=58 align=center>Sunday</td><td width=58 align=center>Monday</td><td width=58 align=center>Tuesday</td><td width=58 align=center>Wednesday</td><td width=58 align=center>Thursday</td><td width=58 align=center>Friday</td><td width=58 align=center>Saturday</td></tr>";

$day_count = 1;

echo               "<tr height=50>";

while ( $blank > 0 ) {
echo               "<td></td>";
$blank = $blank-1;
$day_count++;
}

$day_num = 1;

while ($day_num <= $days_in_month ) {
$newdate = $month ."/". $day_num ."/". $year;
$msqlnewdate = date('m/d/Y',strtotime($newdate));
echo "<td valign=top><table cellpadding=0 cellspacing=0 border=0><tr><td><a href=?session=$session&calview=day&date=$newdate> $day_num </a></td></tr>";
$db = new mysqli('localhost','username','password', 'rsdata');

if (!$db) {
   echo 'ERROR: Could not connect to database.';
} else {
$query = $db->query("SELECT * FROM rentals WHERE date_format(str_to_date(pdate_out,'%Y-%m-%d'), '%m/%d/%Y') <= '$msqlnewdate' AND date_format(str_to_date(pdate_in, '%Y-%m-%d'), '%m/%d/%Y') >= '$msqlnewdate'");
if ($query) {
   while ($result = $query->fetch_object()) {
      echo "<tr><td>".$result->company_id."</td></tr>";
   }
}
echo "</table>";
}


$day_num++;
$day_count++;

if ($day_count > 7) {
echo "</tr><tr>";
$day_count=1;
}
}

while ($day_count >1 && $day_count <=7 ) {
echo "<td></td>";
$day_count++;
}
echo "</tr></table>";
} else if ($calview=="week") {

} else {

}
         
echo      "</td>";
echo   "</tr>";
echo "</tbody>";
echo "</table>";
?>


MOD EDIT: DB credentials edited out.

This topic has been moved to PHPFreaks.com Questions, Comments, & Suggestions.

http://www.phpfreaks.com/forums/index.php?topic=353984.0

This topic has been moved to PHP Applications.

http://www.phpfreaks.com/forums/index.php?topic=329855.0

Hello there,   I would be really grateful if someone could advice please, how do I find this pesky entry in the 'db' table? This is what it says,   "Found an entry in the 'db' table with empty database name; Skipped." MySQL version is 5.5.40   I am pretty much stuck on it. Does it mean the table's name is db? Plus, I am not sure I understand the wording of it too. The empty database name cannot exist by default as it won't allow you to create a database without a name in the first place. I do not even know how and where to begin to look for it because honestly speaking I do not quite understand the phrase itself, because it does not make much sense to me. I would really highly appreciate it if someone could explain and suggest how do I find the... "whatever it says" :-) and to fix it. Many thanks in advance!   P.S. I know this warning may easily and safely be ignored as it is of minor inconvenience and not that important the more so as MySQL is working fine but my curiosity is just running wild for two reasons: 1. I do not really understand what this warning message is trying to tell me and 2. How do I find and adjust it to turn off the warning.   Simple regular things as running myisamchk -r *.MYI on where MySQL is did not help as this warning is actually out of scope of what myisamchk can fix.   And yes, I've Googled it long enough but couldn't seem to come up with anything reasonable solutions.   Thankful for any suggestions / pointers / assistance / comments at all.
Edited by Klaipedaville, 29 October 2014 - 06:17 AM.

This topic has been moved to Application Frameworks.

http://www.phpfreaks.com/forums/index.php?topic=353397.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=314265.0

This topic has been moved to Apache HTTP Server.

http://www.phpfreaks.com/forums/index.php?topic=343321.0

This topic has been moved to Other Libraries and Frameworks.

http://www.phpfreaks.com/forums/index.php?topic=311225.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=317025.0

I've got a monumental problem on my hands...  😂

The website that I've been working on - for years - for my startup business is just about done, but because I have taken so long to code things, my HTML is very outdated, and is *not* mobile friendly.

I was hoping to go live with my website in the next month or two, but considering that over half of Internet users are on mobile, it makes me wonder if I should release my rigid, un-responsive website as-is, or take months trying to re-tool things.

That, in itself, will be a monumental task, BUT it also makes me wonder if I will break all of my tens of thousands of lines of PHP and MySQL?

A very loaded question, for sure, but if you were me, what would you do?

What I am really fearful of is FUBAR'ing my PHP code which I have spent thousands of hours testing and am hesitant to even blink at?!

Edited January 3 by SaranacLake

Hello,

I am attempting to get the base URL of the directory that the CMS was installed, not the main directory. Here's what I mean:

For example, let's say my domain is http://www.example.com but I install my CMS under http://www.example.com/test/cms and on another occasion I install it under http://www.example.com/cms, and on another occasion http://www.example.com/my/new/cms/

I would like my base url for the http://www.example.com/cms installation, to be "http://www.example.com/cms" and my base url for the http://www.example.com/test/cms installation to be "http://www.example.com/test/cms" and so on, without me having to manually change anything.

How do I go about obtaining the directory that corresponds to that particular installation? I know it is possible because Joomla does it automatically.

I have already tried numerous combinations using $_SERVER['HTTP_HOST'], $_SERVER['REQUEST_URI'], $_SERVER['SCRIPT_NAME'], and so on, no luck.

Hi,   Can you please tell me in witch conditions should be used base tag.   If have a website that base tag it's define in header like:  <base href="http://www.website.com/"> What's the meaning of this ?   Thank you

Hi

Hopefully someone can help me. My knowledge of PHP doesnt go any further than looking at identifying areas of code and copy and paste - as basic as you get!

Basically i have a php script installed that produces an RSS feed for me to use with google base. There is a little problem were it does not pull the sale price(known as special)  into googlebase and it will instead show the original price. I have identified what needs to be changed but i dont know the correct syntax.


I somehow need to get something similar to the following IF ELSE into the code below (this is taken from the same php script that shows the special price on the actual rss feed)

foreach ($product_data as $result) {
   $special = $model_catalog_product->getProductSpecial($result['product_id']);
   if ($special) {
      $price = $special;
   } else {
      $price = $result['price'];
   }
   if ($useTax) {
      $price = $currency->format($tax->calculate($price, $result['tax_class_id'], $config->get('config_tax')), $currency->getCode());
   } else {
      $price = $currency->format($price, $currency->getCode());
   }


The code below is were i need the If Else inserted.


<?php foreach ($products as $product) { ?>
   <item>
        <title><?php echo htmlspecialchars($product['name'], ENT_QUOTES, 'utf-8'); ?></title>
        <g:brand><?php echo htmlspecialchars($product['brand'], ENT_QUOTES, 'utf-8'); ?></g:brand>
      <g:condition>new</g:condition>
      <g:product_type><?php echo $taxonomy; ?></g:product_type>
        <description><?php echo htmlspecialchars($product['desc'], ENT_QUOTES, 'utf-8'); ?></description>
        <link><?php echo str_replace('&', '&amp;', $product['href']); ?></link>
        <pubDate><?php echo $product['add_date']; ?></pubDate>
        <!--guid isPermaLink="true"><?php echo $product['href']; ?></guid-->
        <g:id><?php echo (int)$product['id']; ?></g:id>
      <!--g:upc><?php echo sprintf("%012s", $product['id']); ?></g:upc-->
        <g:image_link><?php echo $product['thumb']; ?></g:image_link>
      <!--g:expiration_date>2010-01-01</g:expiration_date-->
      <g:price><?php echo $product['price']; ?></g:price>
      <g:mpn><?php echo htmlspecialchars($product['model'], ENT_QUOTES, 'utf-8'); ?></g:mpn>
      <g:weight><?php echo $product['weight']; ?></g:weight>
      <g:currency><?php echo $config->get('config_currency'); ?></g:currency>
   </item>
<?php } ?>


The <g:price> is what googlebase reads to get the price of the product. The problem seems to be that there is no if else statement here to output the special price if there is one.


Any help would be greatly appreciated, i tired emailing the developer but i have been ignored and as you can see i'm pretty clueless 

I'm trying to figure out how to add "\fs13" to the base64 encoding. For example, the "ad->text" field would look like this   <ad-content type="rtf">ZGZnIGRmZyBkZmcgZGZnIGRmZyBkZmcgZGZnIGRmZyBkZmcgZGZnIGRmZyBkZmcgZGZnIGQ=</ad-content>   The code to generate the above is -- <ad-content type=\"rtf\">".htmlentities(base64_encode($ad->text))."</ad-content>";   I need the encoding to include the "\fs13" in front of the encoded ad-content. The "\fs13" is simply a font size that will tell the system what font size to use.   <ad-content type="rtf">ZGZnIGRmZyBkZmcgZGZnIGRmZyBkZmcgZGZnIGRmZyBkZmcgZGZnIGRmZyBkZmcgZGZnIGQ=</ad-content>   I'm also trying to encode an additional field within the "ad-content type". The present code looks like this:   <ad-content type=\"rtf\">".htmlentities(base64_encode($ad->text))."</ad-content>";   I need to add "($ad->photo_file_name)" to the above, so that the "ad->text" and the "ad->photo_file_name" are within the ad-content type that is being decoded.

Hope that makes sense, appreciate ant help, Thanks!
 

My goal was to create a constant that could be included on the pages, that no matter where it was located in the structure, would be able to find the template files, css, images, etc.  using the following code:

Code: [Select]
if($_SERVER['HTTP_HOST'] == "localhost"){
    define('SITEURL', 'http://' . $_SERVER['HTTP_HOST']);
    define('SITEPATH', $_SERVER['DOCUMENT_ROOT']);
    define('CSS', $_SERVER['DOCUMENT_ROOT'] . '/css/');
    define('IMAGES', $_SERVER['DOCUMENT_ROOT'] . '/images/');
}
else{
    define('SITEURL', 'http://' . $_SERVER['HTTP_HOST']);
    define('SITEPATH', $_SERVER['DOCUMENT_ROOT']);
    define('TEMPLATE', $_SERVER['DOCUMENT_ROOT'] . '/incs/template/');
    define('CSS', $_SERVER['DOCUMENT_ROOT'] . '/css/');
    define('IMAGES', $_SERVER['DOCUMENT_ROOT'] . '/images/');
}

I put the above in a variables.php file that is in the includes folder (named incs) and I call it using the typical include statement.

The problem is that when I use the constant to grab the CSS file, its not working when using:

Code: [Select]
<link rel="stylesheet" href="<?php echo CSS . "template.css" ?>" type="text/css" media="screen" />

I can view the page source and it has the path right, but I cannot figure out how to get it to actually pull in the css file.  I know the echo command is not correct, at least I dont think it is, but have not been able to figure out any other way.

Also, is there a better way to define the constants to the file locations and have it automatically detect whether its on the test server or production and then be able to reference those locations no matter where it is in the structure?