PHP Developers Network

my site gets a lot of international traffic and right now I have US and UK ads available

so I was wondering, PHP switch seems like the obvious choice, then I can load the ad manager that is suitable for the visitor's local needs etc

I was considering new ideas but I am not sure about the best approach for a globalized site

_________________
Hardcore Games Legendary is the Only Way to Play!
Vegan Advocate 16 lbs grain to make only 1 lb meat, water for 6 months of showers and 34.1 lbs carbon dioxide
My sites are made with WordPress, which is a content management system which now accounts for more than 60% of all websites

If you have something as structured as country codes, I would recommend using convention over code (like a switch statements). You can load the ad manager by either having database keys or file/folder names that use the country codes. That makes the system extensible by simply adding records or files/folders, rather than updating the code each time.

_________________
(#10850)

Basically the code goes like

Using more PHP code gives you flexibility, or you use straight ad HTML or whatever for simplicity. Point is, you pick a filename, and if that thing doesn't exist then you use a default instead. Want to add stuff for a new country? Drop the files right in.

That looks like an easier way to get it done, another issue, how to deal with cultural issues, try to offer products that appeal to the local market

My vegan site is one that I am considering some new ideas, I noticed PHP has fairly good support for DBF files, which can be leveraged possible more easily than other contains I can think of

_________________
Hardcore Games Legendary is the Only Way to Play!
Vegan Advocate 16 lbs grain to make only 1 lb meat, water for 6 months of showers and 34.1 lbs carbon dioxide
My sites are made with WordPress, which is a content management system which now accounts for more than 60% of all websites

This kind of using convention to select based on a data point can load the appropriate code, but can also select the correct data. So you can access alternate data files as well.

Hopefully you are only using DBF files for read-only data, unless your site is has low traffic. I would recommend using a regular database server like MySQL. If you are most comfortable using Excel or Access, you might want to create a work flow to export your data to CSV, upload it to the server, and import using LOAD DATA INFILE for database updates. That would allow you to work in the programs you are comfortable with, but have the site use a real database server with record locking.

_________________
(#10850)

very little to no writes to the DBF file, 99.9% would be all read access

any writes would be a simple add to the table, however I see PHP does support PACK so at least I do not have to open FoxPro or other classic development tools

I was considering using a simple DBF to store recipes in, seems like an easy way to store them

Databases in the cloud are expensive, so I am looking to see what PHP can be leveraged to do

some databases I have are in Access format, so I have to figured out how to best leverage what I have

_________________
Hardcore Games Legendary is the Only Way to Play!
Vegan Advocate 16 lbs grain to make only 1 lb meat, water for 6 months of showers and 34.1 lbs carbon dioxide
My sites are made with WordPress, which is a content management system which now accounts for more than 60% of all websites

You have hosting that does not include a database? Can't you get hosting these days for under $5 a month?

Also, SQLite might be a good option to look into.

_________________
(#10850)

I am considering mostly what I can do directly with PHP and JavaScript so that the site can be moved around easily. So any resource needs to be in the document root or a subfolder.

_________________
Hardcore Games Legendary is the Only Way to Play!
Vegan Advocate 16 lbs grain to make only 1 lb meat, water for 6 months of showers and 34.1 lbs carbon dioxide
My sites are made with WordPress, which is a content management system which now accounts for more than 60% of all websites

MySQL is fairly ubiquitous so shouldn't pose a problem. An SQLite database would be stored as a file right in your project's directory structure, so should also be very portable. Just something to consider.

_________________
Supported PHP versions No longer supported versions

dBase tables are OK for my needs, a lot of the functionality needed is already intrinsic with PHP and I suspect it will remain useful as the old database is still a solid workhorse

Once I figure out some nutritional databases I have I was thinking of how best to leverage them which gets back to the recipes database, so clearly I need to consider a lot of options

_________________
Hardcore Games Legendary is the Only Way to Play!
Vegan Advocate 16 lbs grain to make only 1 lb meat, water for 6 months of showers and 34.1 lbs carbon dioxide
My sites are made with WordPress, which is a content management system which now accounts for more than 60% of all websites