Werner Saumweber Programming with php 4 (webdesign)

4. The script for comtrolling Income / Expenditure needs a MySQL table. This application may be downloaded freely (Zip archiv). The definition of the table is:

#
# Table structure for table `haushaltsbuch`
#

CREATE TABLE `haushaltsbuch` (
  `DATUM` date NOT NULL default '0000-00-00',
  `BETRAG` decimal(7,2) NOT NULL default '0.00',
  `WO` varchar(255) NOT NULL default '',
  `TYP` smallint(6) default '0',
  `KOMMENTAR` text,
  `ENDEDATUM` date default NULL,
  `MWSTSATZ` tinyint(4) NOT NULL default '0',
  `MWST` decimal(6,2) NOT NULL default '0.00',
  `SA` tinyint(4) NOT NULL default '0',
  `LFDNR` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`LFDNR`)
) TYPE=MyISAM;

If the scripts must execute online, the following lines have to be changed in the module includes/db.inc.php:

	$GLOBALS['db_server'] = "Name of server";
	$GLOBALS['db_name'] = "Name of datenbase";
	$GLOBALS['db_user'] = "Username";
	$GLOBALS['db_pass'] = "Password";

	Programming with php 4 (webdesign)
	1. Our Online Wine-Shop In Dicembre 2000 this Site was made of 863 documents, 570 pictures and 29 flash movies. 566 articles were presented, described and couln be ordered. In spring 2003 I wrote the php scripts to convert it to dynamic content management. It took some weeks to write in my private time. If You are interested in knowing the technic (and data source), because You too would like to have a shop but do not yet know how much it will cost and how much work it will be, maybe I could give You some information. Or Your site will have similar dimensions, with permanently changing data, as it happens with our pages. One of the most sold German Internet-Journals »Computerbild« has put our site among »The 100 best Internet Adresses« in issue 21/2000
	2. My Recipies. There are 19 textdocuments and some pictures. A php script takes care of all HTML, the texts are included, no database is needed. The menu is defined in a config file within three arrays. Equal names in array entries define the menu structur. $aMenu = array("aVorspeisen"=>"Antipasti (Vorspeisen)", ..... ) $aVorspeisen = array("InsalatadiCarciofo"=>"Insalata di Carciofo", ...."); $aTitel = array("InsalatadiCarciofo"=>"Insalata di Carciofo", ......") In a extern CSS file two layers are definid, no frames. Just a few words about the structur of the site.
	3. Rezepte.php was the basis for the following pages Sardische Rezepte, Science Fiction and Fantasy, Horror und Thriller Verkaufslisten, Pictures from Italy, The Music und Wein - Wine - Vino.
	4. The script for comtrolling Income / Expenditure needs a MySQL table. This application may be downloaded freely (Zip archiv). The definition of the table is: # # Table structure for table `haushaltsbuch` # CREATE TABLE `haushaltsbuch` ( `DATUM` date NOT NULL default '0000-00-00', `BETRAG` decimal(7,2) NOT NULL default '0.00', `WO` varchar(255) NOT NULL default '', `TYP` smallint(6) default '0', `KOMMENTAR` text, `ENDEDATUM` date default NULL, `MWSTSATZ` tinyint(4) NOT NULL default '0', `MWST` decimal(6,2) NOT NULL default '0.00', `SA` tinyint(4) NOT NULL default '0', `LFDNR` int(11) NOT NULL auto_increment, PRIMARY KEY (`LFDNR`) ) TYPE=MyISAM; If the scripts must execute online, the following lines have to be changed in the module includes/db.inc.php: $GLOBALS['db_server'] = "Name of server"; $GLOBALS['db_name'] = "Name of datenbase"; $GLOBALS['db_user'] = "Username"; $GLOBALS['db_pass'] = "Password";
	5. Home of Rock When we started a group of ten persons wrote the Home of Rock. It was a fun projekt, born because no existent domain offered, what "the rockfan" really is looking for. Design and structure are ideas off non-technicians, who as user know exactly what they want. Sadly very rarely one has the opportunity, to plan a projekt in all details and then create it. So it was very great fun. From fans to fans, offering very simple and fast navigation. The whole technic was until 2003 my responsability.
	6. Weingut Angulus Rheingau The German wineyard of my partner at weine-per-mausklick.de GmbH naturally has its own web site based on a littel php script.
	7. The AlzheimerForum - Alzheimer Angehörigen Initiative e.V. Berlin is the biggest german site for caregivers and all interested people and consists at the end of the year 2000 of more than 530 documents. Considering this number the design is not the important point. More important are clear structure and fast transmission, a minimum of code. It has been a lot of work to prepare all documents for XHTML. Using CSS font, sizes colours and so on are defined domainwide for all pages. And I can change it very easily. Do You remember, what kind of HTML code we have been writing 3 years ago? Every one as he/she liked, big and small, parameters with and without "s and so on. You will no more find this old code on the pages.
	If You have some questions or want to ask an offer, please send me an © (words and images) by 2000 & 2006 .
	Last update in June 2006