wdvltalk Roundup May 2002 - Page 21

A load of sites now supply a custom icon which is displayed in the IE favourites menu. Any ideas on how to do it?

• See http://www.favicon.com/ for a complete manual...
• You might want to look at this article on our very own WDVL. http://www.wdvl.com/Authoring/Design/Images/Favicon/

Suppose I have a variable $sv_date that contains "3/6/2002". Using <?php echo ?>, how can I display this date as June, 03, 2002?

• With European-style dates, you can't use strtotime() but you can make your own function to parse your dates and use the date() function to reformat.

  function datetotime($mydate)
  {
      $tmp = split("/",$mydate);
      $day = $tmp[0];
      $mo = $tmp[1];
      $yr = $tmp[2];
      return mktime(0,0,0,$mo,$day,$yr);
  }
  
  function convertDate($mydate)
  {
      $mytime = datetotime($mydate);
      return date("F d, Y",$mytime);
  }
  

• See: http://www.php.net/manual/en/ref.datetime.php
• Grab your favourite irc client and hop on to irc.openprojects.net on port 6667. Then join #vanpug. Also they have a forum for the chat challenged at: http://vancouver.php.net/forum that is starting to pick up speed too.

Does anyone know where I could find a script which will place a div at the bottom of the browser window, even when scrolled or re-sized?

• There's a ton of JavaScript solutions out there for this also. A quick search on Google brought these up: http://javascript.internet.com/bgeffects/persistent-layer.html
  http://www.javascript-fx.com/navigation/floatmenu/demo.html
  http://www.roy.whittle.com/xLayer/instructions.html
  For an explanation as to how they work: http://www.dhtmlnirvana.com/alchemy/floater.htm with a sample: http://www.dhtmlnirvana.com/alchemy/floatlayer.html
• I used one once that was based on the DHTMLib library. It worked great for this particular project and kept the floating content in view at all times. Go to http://www.insidedhtml.com/dhtmllib/page1.asp for details.
• Found one that handles scroll and window re-sizing: http://www.echoecho.com/toolfloatinglayer.htm

How do I upload the database that I created with MySQL using the CREATE DATABASE command at the MySQL prompt?

• There are two ways to admin MySQL. 1. If you have telnet/SSH access to your server, you can upload the file you want to import, start the MySQL command prompt, and enter a query along the lines of

  mysql> LOAD DATA INFILE "myFile.txt" INTO TABLE myDatabase.myTable
  

  (I might be wrong on the syntax, check the MySQL docs for confirmation, there's a *lot* of options for LOAD DATA :-)
  
  2. Alternatively, you only have FTP access. In this case, you'll need web-based admin screens, phpMyAdmin, (http://sourceforge.net/projects/phpmyadmin/) Download it, play around with config.inc.php, and FTP it to your server. You now have web-based MySQL admin which thoroughly rocks. There is a textarea into which you can paste a SQL statement, and there are facilities for importing/exporting to/from a text file, CSV, MS Excel, etc etc.
  
  One note of warning: *password-protect your phpMyAdmin directory*.
• go here: http://anse.de/mysqlfront/ and get mySQL-Front. :) It's fantastic, lets you connect to local and remote mySQL servers (Proxy/Firewall/Permissions permitting, of course) and do wonderful things.

Does anyone have a CMYK to RGB conversion chart, etc.? I have done a search, but haven't come up with any type of Conversion Chart.

• A utility rather than a chart is at http://web-wise-wizard.com/javascript-scripts/hex-rgb-convertor.html

What's the PHP equivalent of <% response.redirect "URL" %> in ASP?

 
echo" <script> window.location=\"http://sitename/test.php\"
    </script>";

$strRedirectURL = "http://www.site.com/page.html
header("Location: $strRedirectURL");

header ("Location: http://mysite.com/test.php");

wdvltalk Roundup May 2002 - Page 20
wdvltalk Roundup
wdvltalk Roundup May 2002 - Page 22