Archive for May, 2010

How do I program in php to interact with my sql database to export the data to a new excel spreadsheet?

I have a MySql Database and I am looking for a good easy to understand script in php that will interact with my Database and pull the information to a new Microsoft Excel file.

Please attach any good links you know of. Thanks!

Excel can read CSV files; these are very easy to write in PHP:

$file_handle = fopen("filename.csv", "w");

$result = mysql_query("SELECT a,b,c FROM table");
while( $row = mysql_fetch_assoc($result) )
{
fwrite($file_handle, $row['a'] . ";" . $row['b'] . ";" . $row['c'] . ";\n");
}
mysql_free_result($result);

fclose($file_handle);

PHP programming I need help and i know little about programming.?

I am new to programming all together. i know minimal HTML but i have an uncle who works for the Obama web site and he recommended I take up php instead of c and c++. Where should I start? Is there another language i should start with or should i get better at html?
I should mention that I was leaning towards C languages for the possibility of working with tmore stand alone programs. But my uncle pointed me towards web design which would probably be a whole lot more enjoyable (at least to me) And now I am curious about the aforementioned PHP as far as what to know before takng classes for PHP itself. Any prerequisite type stuff? all great answers so ar… very helpful thanks and please if anyone can lend a minute share your insight.
- jordanlaf

Depends on where you want to go with web design…

If you want to have a flexible career and be on the more entertaining side of life, then stick with PHP / MySQL. If you want more "stability"–insurance, benefits, etc.–then you will want to learn those other languages like C#, JAVA, etc., because the bigger shops use these technologies more so than PHP and the like.

…You can learn the (X)HTML 1.0 Strict and CSS 2.0 stuff any day of the week as this is not nearly as complicated as the aforementioned.

In the end, however, it truly matters not for the hammer is only as good as the carpenter who wields it.

Why when I enter the name of a .php file does it want to save it on my hard drive instead of running it ?

I just installed a .php script onto my web server and when I go to run the program, instead of the program running I get a pop up window wanting to save the file on my hard drive. I re-uploaded the files to make sure everything was done correctly, but I still get the error message.

Can someone please help me out – I really need to run this program.

Thanks in advance.

make sure your host supports php. if it is a free host, alot of them DO NOT support php, however there are a few such as 000webhost.com that supports PHP and will work for you.if it doesnt it will only allow downloading of the file
one more thing to check is make sure the php script is configured correctly.

Why Do I Need Help From Internet Marketing Agencies?

This is a very common question that internet marketing agencies get. With all the website design software available and inexpensive hosting many small business owners don’t really see the need for help when marketing their small business online.

Yes you can build a webpage with many of the free software programs available or purchase a more sophisticated web design software. There is also hosting available.

All you have to do is ftp the web pages you build to the server. The home page is always the index file.

Remember to build a good deep linking structure by linking each page together and all of them back to the home page. It is also a good idea to put links in the content to link to similar pages. Setting this type of a linking structure can keep people on your website much longer.

Install the script for your auto responder into the contact page so you can catch all the valuable contact info of your visitors. Depending upon the amount of traffic you intend to drive to your site you can use a 3rd party auto responder for a monthly fee. The most efficient is to buy your own software and ftp it to your server.

With this in place you can set up an email marketing campaign which can prove to be your most valuable revenue source if marketed effectively.

Now you must drive traffic to this beautiful site you built. There are multiple internet marketing strategies you need to implement. They target different traffic sources so each needs to be considered. Also some internet marketing strategies are effective immediately like PPC, PPI, PPA etc. Beware that these types of campaigns can add up a large bill very quickly so keep a close eye on these daily.

Some take a little more time like some deep linking campaigns and search engine marketing but these can prove to be the best internet advertising in the long run.

Don’t forget the social media networks which are becoming very popular with you tube ranking in as the second largest search engine for information now on the internet.

Now comes time for the tweaking, to maximize ROI. Install the script of a good statistics program that you prefer so you can begin to analyze data and see which internet marketing strategies campaigns are working best for you. Remember if your tracking script is in php code and your index extension is htm or html you must rename it to php or your tracking code will not read properly.

If all of these things are something you understand and excel at then I do not see why you need any help from internet marketing agencies in marketing your small business online.

Sherrie Chastain
http://www.articlesbase.com/internet-articles/why-do-i-need-help-from-internet-marketing-agencies-687696.html

Apply Bad Card Credit Credit Online

Within this article on Apply bad card credit credit online, we will look at a couple of different cards that you can look at applying for. We will look at the benefits of each card and let you come up with the decision on what you think the best card for you is.

The first card we will look at within this article on apply bad card credit credit online can be found at: https://www.firstpremierbankgold.com/fees50/. This website lists all of the information regarding what you will want to look for. This card offers an attractive fixed rate of only 9.9%. That is a great rate but when you keep reading, there is a one-time fee of $29 as well as a program fee of $145 and a participation fee of $72, billed at six dollars a month. If you are starting to rebuild your credit, you should look into making small purchases and then paying off that balance every month. That will start you slowly moving in the right direction.

The second card that we will look at is in the Orchard Lake Platinum MasterCard. Being a percentage rate on this is higher, running around 14%. There is an annual fee for this between 39 and $59 but it did not list any sort of program fee or participation fee as with the card mentioned above. They do have periodic credit limit increases so as you make on-time payments and continue to build your bad credit towards good credit, you will be rewarded with a higher limit on your credit card. This is another example of how to apply for bad card credit credit online.

I have used a couple of different examples from one page, where you can great deals of information and credit cards that you can apply for online:

http://www.creditcards.com/bad-credit.php.

Use the information above is the guy we should look for when choosing a bad credit credit card for yourself. There are many different options that you have out there and you should not limit yourself to the first one on the list. Good luck in finding card that meets your needs and helps you rebuild your credit. Remember that this is a car that you will use probably for a least a year before acquiring a better card that can reward you so choose wisely. That is the best advice that we can possibly give you.

Mario Churchill
http://www.articlesbase.com/finance-articles/apply-bad-card-credit-credit-online-106884.html

I want the output of my PHP to be opened in EXCEL or OpenOfficeSpreadsheet. How can I do it?

I have one PHP program which use mysql database. I want t the output to be opened in EXCEL/OpenOfficeSpreadsheet(in a separate window) when I click on a link provided. Any option to do it other than to save it as a CSV?The problem with CSV is that it opens as a single column and I have to use text to columns option to convert into columns. Thanks in advance.

CSV is Comma Separated Values

Means if you use values with comma as separator, Excel will open in in multiple columns

like this
"Value 1" , "Value2 " , "The long value of 3rd column"

VBAXLMan

Workers’ Compensation Safety Issues: the 5/4 Method of Communicating Safety to a Diverse Workforce

Protecting your Trademarks in Paid Search

Business Alive on the Web by Keeping Management Membership Site Software

In the vast competition on the internet money-making industry, keeping your website with a membership site running is the most popular way to keep you alive in the business. A membership site will somehow increase your chances on the web to make it big, and if by luck, will continue being so for the coming, long years.

However, a membership site will not stay long in the industry if you don’t have the membership site software to run the organization properly. The membership site software is a way to keep your members glued on their commitments with your organization, so it is essential that you largely consider it as your primary tool in keeping your website.

If you are just staring with your membership site and you are hoping to make it really big in the industry, make sure you choose the most appropriate membership software that can manage well your organization in tracking your members. The following should be considered in selecting your own membership website software:

1. Reliability this tackles about how the software is going to be effective with your website. For more details:www.start-ownbiz.com.It should not only focus on the reliability of the software alone but on the company that supplied the membership website software as well. You have to look for a company which will offer the best services such as being available 24 hours a day and will always provide you solutions.

2. Actual features you have to learn of these things before picking the software. There are many software programs you can choose on the web but they are not the same. A membership software website may have features that are unnecessary with your website while the other may lack some that you need. Check them all and get one with features that will largely compensate on your needs.

3. Compatibility some membership software runs on PHP on the server, while others run on ASP. In this aspect, check one that would be compatible with the web host account that you have.

4. Price of course, this is the most indispensable factor that you must take into consideration. Membership site software programs can be quite expensive. If you do not want to waste even a cent, do not spend on an overly expensive software which features a lot of things but you have no need for in the end. On the other hand, you do not have to spend on cheap software if it lacks the necessary features you need for your organization.

If you have analyzed these factors, you will find a membership software program that will surprisingly meet your needs but without spending exaggeratingly. For a starter, you will find a program which costs at a very reasonable rate. If you have stepped further in the business, then you can upgrade the software so you will be able to manage the membership you have collected.

Membership management software is the most ideal program which most organizations and associations employ contact us:www.starting-membership-site.com. It allows you to keep track of your members even without you supervising it on hand. Most membership management software applications are available with features that will keep track of the details and information of your members by sending them regular emails to the account they have provided.

Membership management software is very accurate in the sense that it can keep the status of your members updated. It will help you keep your members; thus a steady flow of the traffic.

Satyan dua
http://www.articlesbase.com/small-business-articles/business-alive-on-the-web-by-keeping-management-membership-site-software-672898.html

Online-marketing-in-india