|
|
|
|
|
All resources published on this blog are free to use and redistribute. All we ask is that you keep any copyright notices and links to WebMe in your code. If you find something really useful we would appreciate you placing a link on your site to ours.
|
|
|
|
DSN-Less Connection to MySQL in ASP
To access a MySQL database in ASP you can use the following script:
Function getDBConn()
Set conDB=Server.CreateObject("ADODB.Connection")
conDB.Open "Driver={MySQL ODBC 3.51 Driver};" & _
"Server=mysql.myserver.net;" & _
"Port=3306;" & _
"Option=131072;" & _
"Stmt=;" & _
"Database=mydatabase;" & _
"Uid=myname;" & _
"Pwd=mypassword"
End Function
Remember to change the Server address to the address of your MySQL database; also you will need to change the Database, Uid and Pwd parameters as appropriate. Labels: asp, mysql, source code
|
 |
PHP Connection to MySQL
To access a MySQL database in PHP you can use the following script:
<?php
$dbhost = 'mysql.myserver.net';
$dbuser = 'myname';
$dbpass = 'mypassword';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die
('Error connecting to mysql');
$dbname = 'mydatabase';
mysql_select_db($dbname);
?>
Remember to change the Host address to the address of your MySQL database; also you will need to change the dbname, dbuser and dbpass parameters as appropriate. Labels: mysql, php, source code
|
|
ASP Server Variables
We have decided to remove our Resources section in order to keep all useful code snippets and tips in our blog so we will post some of the content of those pages here.
The first one is the ASP Server Variables table:
The table below shows the Server Variables available in ASP and example values.
To access Server Variables in ASP we use:
Request.ServerVariables (server_variable) Labels: asp, source code
|
|
Getting path and location details in Javascript
A couple of quick tips for you to get path information for your page in JavaScript, assuming that the URL we are manipulating is http://example.com/test/test.php?i=1&b=2#3
To get the complete URL use:
location.href returns http://example.com/test/test.php?i=1&b=2#3
To get the hostname use:
location.hostname returns example.com
To get the path of the current URL including the script use:
location.pathname returns /test/test.php
To get the current URL excluding the script use:
location.hostname+location.pathname.substr(0, location.pathname.lastIndexOf("/"))+"/"returns example.com/test/
Now to get passed parameters from the QueryString:
location.search returns ?i=1&b=2
To get just the anchor or hash part use:
location.hash returns #3
Finally to get the protocol use:
location.protocol returns http:Labels: html, javascript, location, source code, url
|
|
Get Current Directory Function in PHP
Something that many people ask for is an extremely simple piece of code and that is "How do I get the current directory in PHP?"
Well, we use a function to do this and the code is as follows:
function getDirectory() {
$f = getcwd();
return substr($f, strrpos($f, "/") + 1);
}
The PHP function getcwd() returns the current working directory and path. The following line simply strips the path and returns the name of the current directory.
Instead of using getcwd() you can also use dirname(__FILE__) so the code could be rewritten as:
function getDirectory() {
$f = dirname(__FILE__);
return substr($f, strrpos($f, "/") + 1);
}
Labels: php, source code
|
|
Careful with your Comments in IE
Small tip today.
Be careful where you place your HTML comments in Internet Explorer.
Placing comments before you begin your HTML content can cause strange layout rendering.
For example:
<!-- My Comment -->
<html>
<head>
....
This is wrong and can cause all sorts of layout issues. Always make sure your comment is in your HTML content. Labels: html, pitfalls, source code
|
|
XML Sitemap Generator Script in PHP for Google and others
We develop a lot of websites and quite rightly the owners want their site to appear in Google as quickly as possible. One way to speed up this process is to use Google's sitemap tool.
Google accept sitemaps in various formats, one of them being XML.
Now if you have a site, or develop websites, that quite often have new content and pages being added to them it can be a pain to create a new sitemap each time. For this reason we have taken a nice little script developed in ASP by Francesco Passantino and rewritten it in PHP.
To use this script, simply place it in the root of your website and tell Google where it is in the Add Sitemap section of Google sitemaps.
The script will generate a valid XML sitemap that will dynamically update whenever new pages are added or pages are deleted.
Version 1.0 can be found here. This is for PHP5 only, we also have a PHP4 version which can be found here. To use the PHP4 version you will need the strripos PHP4 script from here. Labels: google, php, sitemaps, source code, xml
|
|
Random Password Generator in PHP
Today we thought we'd share our random PHP password generator code with you.
This function returns a variable length password comprised of upper and lower case characters with numbers. Simply pass the desired password length to the function.
function RandomPW($myLength) {
$strPW = '';
//These constant are the minimum and maximum length for random
//length passwords. Adjust these values to your needs.
$minLength = 6;
$maxLength = 20;
if ($myLength == 0) {
$myLength = rand($minLength, $maxLength);
}
for ($X=1;$X<=$myLength;$X++) {
//Randomize the type of this character
$Y = rand(1,3); //(1) Numeric, (2) Uppercase, (3) Lowercase
switch ($Y) {
case 1:
//Numeric character
$strPW = $strPW.chr(rand(48, 57));
break;
case 2:
//Uppercase character
$strPW = $strPW.chr(rand(65, 90));
break;
case 3:
//Lowercase character
$strPW = $strPW.chr(rand(97, 122));
break;
}
}
return($strPW);
}
Labels: password, php, source code
|
|
|
