I created this form on my graveyard site so users can share their own graveyard. It allows the user create a small profile of the grave yard and upload 5 images to the server. After filling out the form the data will be inserted into a MySQL table to be displayed later on the page they created. The page is created automatically, but I will show how that is done in a separate post. The images are uploaded to a server to be placed in unique folder to be easily displayed. From my past experience it is very important to prevent spam when creating HTML forms. I used Google’s Captcha to prevent the spam. It was very easy to setup and is very effective.
I have the files below that I created. They have examples of:
- Inserting HTML form data into a MySQL Table
- Inserting multiple images into a server using a form
- Using Google Captcha to prevent spam.
I was just mainly messing around, but it was the first couple version of the site I had up.
I will continue to add to the php and mysql examples. These are just some simple examples. Remember just put them in between php tags and place the code in a php file. All of them you will have to add your username, password, database and table name(except for view tables).
On a recent school project, we was making a website that had a social network element. After the user created his account and loged in, he could see his profile. This was useless because no one else could see it. I needed a way so that ever member had a unique URL. So I created a template that only information from the database to create the webpage. It is very simple to query a MySQL database using the URL.
My ID: 100000278497888
Here is an example of using PHP with html form data to make a contact form for a web site. This is also a good example of grabbing HTML form data with PHP and using it. Here is the demo:
I am working on a page to send text messages from the web. I know there is a lot out there, but I hope to do a better job. Let me know if you have any request or comments.
Send a Text
It has now been 1 year since I came up with the not so great idea of creating a photo blog. The theme of the site was to mock people being dochebags. I would plug it here but I am not so proud of it. But I do want to share some statistics of the site after being online. It might give an idea of what to expect if your thinking about a similar idea. Keep in mind that I did not try to promote the site. I just to put it up and updated it fairly regular. I was not able to track the visits from mobile phone that brought up the mobile version of the site. I just know that i received over 1,300 page views from phones.
I sorta debated if this was worth posting about, but I think it is worthy of a mention. I found this app in the Android market the other day after the default camera on my G2 was messing up. After seeing the photos I took with it I got really excited about it. It is due to my odd curiosity on old style photos.
The app is called Retro Camera from Urbian and is found in the Android market. I would not be surprise if it is in the iPhone market also. As of right now (not sure if they plan to update it) they have 5 camera you can use. Here is also examples of the pictures it takes. Just to note, I am not a great photographer .
The biggest pain is to discover that you need to change something in your site that covers 20 pages. When I created the Graveyard Database I kept running into the problem that i wanted to change something in the graveyard page. I would have to go to each page and make the changes. So I slowly learned to make a website very flexible from the start. Here is ways I found to make a site very flexible. Continue reading