Saturday, May 9, 2009

Extract data from myob through php

# connect to a DSN "mydb" with a user and password
#DSN is a system wide in this case. user or document wide systems could be possible
$connect = odbc_connect("TEST2", "Administrator", "");

# query the users table for name and surname
$query = "SELECT * FROM Employees";

# perform the query
$result = odbc_exec($connect, $query) or die ("cannot find table");


# fetch the data from the database
while($row = odbc_fetch_array($result)){
$name = $row['LastName'];
$surename = $row['FirstName'];
print("$name $surename
\n");
}
?>

Tuesday, May 5, 2009

Personalized webpage

Some application allow internet users to make notes on any kind of webpages. Eg http://www.emilstefanov.net/Projects/NeuralNetworks.aspx is a good website, I added to my bookmarks. But I want to make notes on this website and would be able to edit the information.

Michael

Sunday, May 3, 2009

Link MYOB with Access

Create empty Access DB
file->get external data->link tables
Choose File of type: ODBC Database

Tuesday, April 21, 2009

how unlock secured PDF

Open the target file in PDF exchange(Note), then print the file, select Adobe PDF as the printer.

Note: you can download PDF exchange from this official website, or download a portable application from portableapps.com. Administrative rights is not required to install portable applications.