Printable View
Not sure whether to ask this here or in Website Design...but its related to programming sao i decided to post here...
I'm currently working on a new Windrivers Photo ID page, with a database backend so people can add/modify their own entries, instead of emailing them to me.
I'm currently just starting to learn PHP using online tutorials and have started creating the page.
Anyone here know PHP and is willing to help me out?
Thanks very much in advance...
Burn.
I can give a hand what's the plan?
Did you want a mysql backend with php?
Yeah. MySQL backend + PHP.
Mostly im sticking to doing really simple stuff because it will work, and because the only knowledge i have is that from a couple of simple tutorials...
The only way i can show what i want to do is by letting you view my page, which can only happen when im online (im coding on my computer, and im on dialup).
Do you have ICQ or MSN etc so i can chat with you realtime?
Thanks,
Burn.
[quote]Originally posted by BurnFEST:
<strong>Yeah. MySQL backend + PHP.
Mostly im sticking to doing really simple stuff because it will work, and because the only knowledge i have is that from a couple of simple tutorials...
The only way i can show what i want to do is by letting you view my page, which can only happen when im online (im coding on my computer, and im on dialup).
Do you have ICQ or MSN etc so i can chat with you realtime?
Thanks,
Burn.</strong><hr></blockquote>
Well when Im ou home on im AIM as xDigitalExpl0itx
But the best thing is to email me. Message me if you want it.
There are alot of great php books out on the market you may want to look at or even buy.
Ok, ill add you :)
Ive also got a temporary dialup server up so you can see what im trying to do.
<a href="http://festy.ath.cx/windrivers/photomain.php" target="_blank">http://festy.ath.cx/windrivers/photomain.php</a>
Its just the news page, practise for the rest of the site...ive managed to make an add/edit/delete, but my problem is they are listed on the page from oldest to newest, and i want them listed with the newest at the top.
You can download my php/html <a href="http://members.dingoblue.net.au/~dburney/htmstore/php.zip" target="_blank">HERE</a>
And I've made a MySQL database dump with you can get <a href="http://members.dingoblue.net.au/~dburney/htmstore/photo.dump" target="_blank">HERE</a>
I am going to go to the library and look for books, but i doubt there'll be any useful ones. I'd really rather human help, because that way i can get explainations and stuff :)
The idea is to make it look like the <a href="http://windriversfriends.cjb.net" target="_blank">Windrivers Photo ID Database</a> page ive been running for about a year, except instead of people emailing me for additions/changes they can do it themselves. I know enough to do all of it, theres just a few things that are bugging me, like how to display the news in reverse order :(
Thanks :)
Sam.
Ok, Im looking at the source code.
You shuld run all this off mysql, this wouldnt be hard I can show you some examples but let me look through all the pages first.
OK Ive did a example page for you.
to veiw the page running go here
<a href="http://www.daemonprojects.com/windrivers/a.php" target="_blank">http://www.daemonprojects.com/windrivers/a.php</a>
to download the src code go here
<a href="http://www.daemonprojects.com/windrivers/windrivers.zip" target="_blank">http://www.daemonprojects.com/windrivers/windrivers.zip</a>
to see the mysql setup go here (this is with the code also)
<a href="http://www.daemonprojects.com/windrivers/mysqlsetup.JPG" target="_blank">http://www.daemonprojects.com/windrivers/mysqlsetup.JPG</a>
To configure the mysql connection script
open the databseconfig.php file and edit the file
just need the username/password and database name
heres a fix for a.php
where the $sql = statement is replace it with this
$sql = "select * from photo where Pusername like 'A%' order by Pusername";
this will sort it so any user with the username that starts with A will show up on the a.php page
to change it just change it here it says 'A%' to 'D%' or whatver for the rest of the pages
a little demo
<a href="http://www.daemonprojects.com/windrivers/noindex.html" target="_blank">http://www.daemonprojects.com/windrivers/noindex.html</a>
[quote]Originally posted by Daemon:
<strong>heres a fix for a.php
where the $sql = statement is replace it with this
$sql = "select * from photo where Pusername like 'A%' order by Pusername";
this will sort it so any user with the username that starts with A will show up on the a.php page
to change it just change it here it says 'A%' to 'D%' or whatver for the rest of the pages
a little demo
<a href="http://www.daemonprojects.com/windrivers/noindex.html" target="_blank">http://www.daemonprojects.com/windrivers/noindex.html</a></strong><hr></blockquote>
Fix:
<a href="http://www.daemonprojects.com/windrivers/noindex.php" target="_blank">http://www.daemonprojects.com/windrivers/noindex.php</a>
Thanks for your work :)
What youve done with the photo pages is pretty much exactly how i wanted to do it :)
i still dunno how to do the news in reverse order on photomain.php and also how do let people upload images straight into the database?
Waiting your reply,
Burn.
there is a way if you use blob. this will allow you to upload images into mysql. Ill see what I can do.
heres an update on the code for you. Look through it have any question feel free to ask.
<a href="http://www.daemonprojects.com/windrivers/windrivers.zip" target="_blank">http://www.daemonprojects.com/windrivers/windrivers.zip</a>
Ok Im using 2 database tables ones for the iamges other is for the news.
photo and main
heres how I configured my tables
<a href=http://daemonprojects.com/windrivers/photo.JPG>photo</a>
<a href=http://daemonprojects.com/windrivers/main.JPG>main</a>
im useing phpMyAdmin 2.2.4
if you are not already using this you should makes things alot eaiser.
as good as inserting images into the database, this can casue the images to corrupt it better off if you have the users either one give the url or two have them upload it to a directory.
I recomend you have the users put the url in.
here is the insert page if you want to play around with the data
<a href="http://daemonprojects.com/windrivers/insert.php" target="_blank">http://daemonprojects.com/windrivers/insert.php</a>
Ok, is there any easy way to let users upload the images to my server via PHP?
I was going to use the 'type url to image' method but a lot of people's webspace wont let other websites link to their images...so uploading to my server will be a LOT easier.
It's past midnite here, so im going to bed - ill look at that code tomorrow.
Thanks again heaps for your help!
Burn.
well you may want to check <a href="http://www.planet-source-code.com" target="_blank">www.planet-source-code.com</a>
<a href="http://www.hotscripts.com" target="_blank">www.hotscripts.com</a>
I have a little script I found dont know if it works but it may give an Idea.
<a href="http://www.daemonprojects.com/windrivers/upload.zip" target="_blank">http://www.daemonprojects.com/windrivers/upload.zip</a>
I've had a look at your website...i take it your news is all php...and in order from newest to oldest...my only real problem right now is that...how do you do it? :(
Burn.
[quote]Originally posted by BurnFEST:
<strong>I've had a look at your website...i take it your news is all php...and in order from newest to oldest...my only real problem right now is that...how do you do it? :(
Burn.</strong><hr></blockquote>
when you take the data from mysql you need to sort it in the query string
example1:
$sql = "select * from photo order by Pusername ASC";
example2:
$sql = "select * from photo order by Pusername DESC";
ASC = a-z
DESC - z-a
ASC and DESC well sort it for you thats all you need to do.
You are the man! Thankyou very much! I'm now going to continue work on this webpage :)
Thankyou very much for your help and i hope you dont mind me asking more questions every now and then :)
Sam.
I was playing around witht the page and I made a application where the users can modify there profiles.
<a href="http://daemonprojects.com/windrivers/login/" target="_blank">http://daemonprojects.com/windrivers/login/</a>
not all the way done
also made a little change in the gamming page
<a href="http://daemonprojects.com/windrivers/games.php" target="_blank">http://daemonprojects.com/windrivers/games.php</a>
if you want the code to look through feel free to ask.
I got your email, sorry I didnt email this to you but Im at work and not my home system so heres a link to the src of how to put all the photo pages into one page
<a href="http://www.daemonprojects.com/windrivers/test.zip" target="_blank">http://www.daemonprojects.com/windrivers/test.zip</a>
I did the first one for you (A)
it should be straight forward
here is the page when it is working
<a href="http://daemonprojects.com/windrivers/test.php" target="_blank">http://daemonprojects.com/windrivers/test.php</a>
test
The page is all up and running!
<a href="http://windriversfriends.cjb.net" target="_blank">http://windriversfriends.cjb.net</a>
[quote]Originally posted by BurnFEST:
<strong>The page is all up and running!
<a href="http://windriversfriends.cjb.net" target="_blank">http://windriversfriends.cjb.net</a></strong><hr></blockquote>
ahhh nice, how did you like coding it? Fun eh?
with the database in and working with php it makes the site alot eaiser to manage
I added my self to your database, but I got an error, may want to check up on it.
Warning: open_basedir restriction in effect. File is in wrong directory in /mnt/host-users/microgen/windrivers/add.php on line 22
Warning: fopen("/mnt/tmp/phpFOA5y1", "rb") - Operation not permitted in /mnt/host-users/microgen/windrivers/add.php on line 22
Warning: Supplied argument is not a valid File-Handle resource in /mnt/host-users/microgen/windrivers/add.php on line 22
User Added Successfully!!
Thought you like to know, Ive started a PHP web Based game. Dont know what to call it yet.
<a href="http://daemonprojects.com/game/" target="_blank">http://daemonprojects.com/game/</a>
you can see it, but its not operational yet.
Login = test
password = test