A refreshing day to begin with... :: Computer Programming

Social Networking Site for Davao City

September 28, 2009

Feel free to join the community.

Just log in at:

http://artgallery.site50.net

Connection Strings

October 6, 2008

MySQL Connector/ODBC 2.50 (MyODBC 2.50)

Local database

Driver={mySQL};Server=localhost;Option=16834;Database=myDataBase;

Remote database

Driver={mySQL};Server=myServerAddress;Option=131072;Stmt=;Database=myDataBase; User=myUsername;Password=myPassword;

Specifying TCP/IP port

Driver={mySQL};Server=myServerAddress;Port=3306;Option=131072;Stmt=;Database=myDataBase; User=myUsername;Password=myPassword;

MySQL Connector/ODBC 3.51 (MyODBC 3.51)

Local database

Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=myDataBase; User=myUsername;Password=myPassword;Option=3;

Remote database

Driver={MySQL ODBC 3.51 Driver};Server=data.domain.com;Database=myDataBase;User=myUsername; Password=myPassword;Option=3;

Specifying TCP/IP port

Driver={MySQL ODBC 3.51 Driver};Server=data.domain.com;Port=3306;Database=myDataBase;User=myUsername; Password=myPassword;Option=3;

Specifying character set

Driver={MySQL ODBC 3.51 Driver};Server=data.domain.com;charset=UTF8;Database=myDataBase;User=myUsername; Password=myPassword;Option=3;

OLE DB, OleDbConnection (.NET)

Standard

Provider=MySQLProv;Data Source=mydb;User Id=myUsername;Password=myPassword;

mySQL based counter script for multiple pages

September 21, 2008

//MYSQL database is needed

$db = "DATABASE NAME";
$admin = "MYSQL USER NAME";
$adpass = "MYSQL PASSWORD";
$mysqllink = mysqlconnect("localhost", $admin, $adpass);
mysqlselectdb($db, $mysqllink);

$result = mysqlquery("SELECT impressions from tdscounter where COUNTID=’$cid’", $mysqllink);
if(mysqlnumrows($result)) {
   mysqlquery("UPDATE tdscounter set impressions=impressions+1 where COUNTID=’$cid’", $mysqllink);
   $row = mysqlfetch_row($result);
   if($inv != 1) {
       print("$row[0]");
   }
}
?>

creating a mySQL table using a PHP script

$mysqldb = "DATABASE NAME";
$mysqluser = "YOUR MYSQL USERNAME";
$mysqlpass = "YOUR MYSQL PASSWORD";
$mysqllink = mysqlconnect("localhost", $mysqluser, $mysqlpass);
mysqlselectdb($mysqldb, $mysqllink);
$createquery = "CREATE TABLE tdscounter (
    COUNTID INT NOT NULL AUTOINCREMENT,
    pagepath VARCHAR,
    impressions INT,
    resetcounter DATETIME,
    PRIMARY KEY (COUNTID)
    )";

mysqlquery($createquery, $mysqllink);
print("Table Creation for tdscounter successful!

");

$insert = "INSERT into tdscounter VALUES (
0, ‘/phpdiary/021901.php3’, 0, SYSDATE
)";

mysqlquery($insert, $mysqllink);
print("Inserted new counter successfully for this page: http://www.php-scripts.com/phpdiary/021901.php3

");

?>

admin interface for adding and deleting users using mySQL

//needs a database MYSQL, thanks
$db = "DATABASE NAME";
$admin = "MYSQL USER NAME";
$adpass = "MYSQL PASSWORD";
$mysqllink = mysqlconnect("localhost", $admin, $adpass);
mysqlselectdb($db, $mysqllink);

?>

Delete Users
user">

ADD A New User

User:

Pass:

Comments (0)

shuffling and "cutting" a deck of playing cards

$cards = array("ah", "ac", "ad", "as",
 "2h", "2c", "2d", "2s",
 "3h", "3c", "3d", "3s",
 "4h", "4c", "4d", "4s",
 "5h", "5c", "5d", "5s",
 "6h", "6c", "6d", "6s",
 "7h", "7c", "7d", "7s",
 "8h", "8c", "8d", "8s",
 "9h", "9c", "9d", "9s",
 "th", "tc", "td", "ts",
 "jh", "jc", "jd", "js",
 "qh", "qc", "qd", "qs",
 "kh", "kc", "kd", "ks");
srand(time());
 for($i = 0; $i < 52; $i++)
{
 $count = count($cards);
 $random = (rand()%$count);
 if($cards[$random] "")       {          $i–;       }       else       {          $deck[] = $cards[$random];          $cards[$random] = "";       } } srand(time()); $startingpoint = (rand()%51); print("Starting point for cut cards is: $startingpoint"); // display shuffled cards (EXAMPLE ONLY)   for ($index = 0; $index < 52; $index++) {    if ($startingpoint 52) { $startingpoint = 0; }
 print("Uncut Point: $deck[$index] ");
 print("Starting Point: $deck[$startingpoint]
");
 $startingpoint++;
 }
?>

searching through a directory and picking out files using a regular expression

$diarydirectory = opendir(".");
 while($filename = readdir($diarydirectory))
{
 $filesplit = explode(".", $filename);
 $checkfilename = $filesplit[0];
 if(ereg("[0-9]{6}", $checkfilename))
 {
 $checkfilename .= ".$filesplit[1]";
 $validfilename[] = $checkfilename;
 }
 }
closedir($diarydirectory);
for($index = 0; $index < count($validfilename); $index++)
{
 print("$validfilename[$index]
");
}
?>

forcing the text in a string to be all upper or lowercase

// force all uppercase
print(strtoupper("i bet this will show up as all letters capitalized
"));
// force all lowercase
print(strtolower("I BET THIS WILL SHOW UP AS ALL LETTERS IN LOWERCASE
"));
// force the first letter of a string to be capitalized
print(ucfirst("i bet this will show the first letter of the string capitalized
"));
// force the first letter of each WORD in a string to be capitalized
print(ucwords("i bet this will show the first letter of every word capitalized
"));
?>

random text link advertising using predefined arrays

$randomurl = array("http://www.tdscripts.com/linkorg.html",
                    "http://www.tdscripts.com/keno.html",
                    "http://www.tdscripts.com/ezibill.shtml",
                    "http://www.tdscripts.com/tdforum.shtml",
                    "http://www.tdscripts.com/picofday.html",
                    "http://www.tdscripts.com/gutsorglory.html");

$urltitle = array("Link Organizer",
                   "TD Keno",
                   "eziBill *Free Promotion!",
                   "TD Forum",
                   "TD Pic of Day PHP",
                   "Guts or Glory Poker PHP");
$urldesc = array("- A comprehensive link list organizer",
"- Offer your site visitors an engaging Keno game without the monetary risk",
"- Sell access to and protect your membership area using iBill and our eziBill script",
"- An unthreaded messageboard script to exchange ideas with your site visitors",
"- Run your own picture of the day script from any site anywhere with this handy script",
"- A casino-style card game written entirely in PHP");
srand(time());
$sizeof = count($randomurl);
$random = (rand()%$sizeof);
print("

url[$random]">$urltitle[$random] $url_desc[$random]");
?>

php simple slot machine - multiple rand number generation

function slotnumber()
{
srand(time());
for ($i=0; $i < 3; $i++)
{
$random = (rand()%3);
$slot[] = $random;
}
print("

$slot[0] ");
print("
$slot[1] ");
print("
$slot[2] ");
if($slot[0] $slot[1] && $slot[0] $slot[2])
{
print(" Winner!—Hit refresh on your browser to play again");
exit;
}
}
?>

slotnumber();
?>

M	T	W	T	F	S	S
« Sep
	1	2	3	4	5	6
7	8	9	10	11	12	13
14	15	16	17	18	19	20
21	22	23	24	25	26	27
28	29	30	31