/    Sign up×
Community /Pin to ProfileBookmark

First-timer: building a clan webpage php/MySQL

Copy linkTweet thisAlerts:
Feb 01.2006

I’ve just taken on a project for some friends to build them a website for their Counter-Strike clan. I’m good with html and CSS; I’ve already built 2 entire webpages out of only CSS.

An active website like this will need frequent updates, and these guys aren’t code-savvy enough to edit raw html/css. Therefore, I need to implement a database and PHP forms/scripts to streamline adding new content. I understand the general process, but I’ve never scripted PHP or built a MySQL database.

It seems simple – build a few PHP forms in an “admin” passworded area (I saw the links to make this kind of thing in the FAQ) with a database to store the inputs. If everything sounds like it jives, my only obstacle is actually learning these scripting languages. ?

So, for my first PHP/MySQL project, am I in over my head?

to post a comment
PHP

8 Comments(s) ↴

Copy linkTweet thisAlerts:
@LiLcRaZyFuZzYFeb 01.2006 — I've already built 2 entire webpages out of only CSS.[/QUOTE]
only CSS? no markup? :p hehe

And yes, such PHP/MySQL application isn't too complicated, you'll need to know a few things:
[list]
  • [*]use the proper form and method

  • [*]validate the data sent

  • [*]establish a connection to a MySQL database

  • [*]create or update fields

    • [/list]

    if it's too complicated, or if you desire more options, you might wanna use ready-made CMS(Content Management System).

    You'll find what you need at http://opensourcecms.com

    if you have specific questions, feel free to ask in the forums.

    good luck
    Copy linkTweet thisAlerts:
    @rWagzauthorFeb 01.2006 — 
    ...such PHP/MySQL application isn't too complicated, you'll need to know a few things:
    [list]
  • [*]use the proper form and method

  • [*]validate the data sent

  • [*]establish a connection to a MySQL database

  • [*]create or update fields

    • [/list]     [/QUOTE]

    Thanks for the optimism! I've already installed XAMPP and I'm in the process of finding a good PHP and mySQL reference to get me started.
    only CSS? no markup? :p hehe[/quote]
    ? I got excessive with my last "webpage." I used <html>, <head>, <body>, <style>, and <div> HTML tags only. Absolutely no markup formatting. It was actually an email I sent out to my friends/family sometime in June to show them pictures from my first convoy into Iraq (I was stationed in Camp Arifjan, Kuwait with the Army). Load the attached TXT file into your browser to check it out.

    [upl-file uuid=bc3739e0-e0ef-42c6-892e-5f422d0da449 size=19kB]letter.txt[/upl-file]
    Copy linkTweet thisAlerts:
    @bathurst_guyFeb 01.2006 — I used <html>, <head>, <body>, <style>, and <div> HTML tags only.[/QUOTE]He lies! I see <p> <a> <span> <img> ? [b]<center>[/b] :eek: I dont mind about the other tags, but <center>!!!!
    Copy linkTweet thisAlerts:
    @rWagzauthorFeb 01.2006 — bah they're in a div, I missed them ?

    Oh, and if you actually brought the page up, the divs activated on mouseover of the pictures were a pain in the butt to get working for IE. Firefox implemented them with half the code. If I hadn't been stuck in the middle of the desert hiding in my tent from 150 degree weather I'd have just given up on it!
    Copy linkTweet thisAlerts:
    @LiL_aaronFeb 01.2006 — There are lots more cms programs for you try like:

    PHP Nuke, that comes with phpBB on versions later then 6.8, but its like 7.6 or something now, but 7.4 with chatserve mod is the better and most secure. Plus there are loads of modules and blocks ect for you to have a look at... i wont go though all the sites, as its not allowed, but if you search for php nuke, then you will find it easy.

    Post Nuke, that can come with phpBB but you need to install it seperately called PNphpBB, there are a few issues with this tho, as registering on the site, doesnt always register ya on the forums. There are extra modules and blocks for this but it is hard to find.

    Plus there are lots more... like mambo, php fusion, e107, phpwcms, phpMywebsite.

    Out of the lot i like php nuke, reason being is that its easy to make new modules for ya self or others, plus there are loads or resources and communitys for it too.

    Hope any of this helps

    Aaron
    Copy linkTweet thisAlerts:
    @juicemousezeroFeb 01.2006 — I've always gone with PHP MyAdmin for MySQL stuff and have loved every minute of it.
    Copy linkTweet thisAlerts:
    @LiLcRaZyFuZzYFeb 01.2006 — 

    yep, but first of all get the [url=http://www.php.net/docs.php]php manual[/url]
    --



    also, about your pages, designing with CSS doesn't mean that your page should only contain HTML, HEAD, BODY, DIV, etc..tags, but more in the lines of: writing semantic markup and designing it with CSS.

    There is nothing bad in using lots of elements, as long as you use them for their purpose. In fact, that's the way it should be
    Copy linkTweet thisAlerts:
    @rWagzauthorFeb 01.2006 — Yeah, I understand using CSS in that fashion, even if I've not done much of it myself. I got wrapped up in being freed from tables, I suppose. I've witnessed what good CSS can do via the CSS Zen Garden. Impressive stuff.

    I have a small question about MySQL and I really don't want to choke up the SQL forum with it. I'll ask it here, and if it's not kosher to do so, then slap me on the wrist and I'll go post it in SQL...

    Can I use Access to create SQL databases? from random google searches I've read that Access creates a different type of SQL or something?

    Thanks for the tips on stuff to get - this all-in-one XAMPP thing doesn't seem to even include a MySQL editor.
    ×

    Success!

    Help @rWagz spread the word by sharing this article on Twitter...

    Tweet This
    Sign in
    Forgot password?
    Sign in with TwitchSign in with GithubCreate Account
    about: ({
    version: 0.1.9 — BETA 5.16,
    whats_new: community page,
    up_next: more Davinci•003 tasks,
    coming_soon: events calendar,
    social: @webDeveloperHQ
    });

    legal: ({
    terms: of use,
    privacy: policy
    });
    changelog: (
    version: 0.1.9,
    notes: added community page

    version: 0.1.8,
    notes: added Davinci•003

    version: 0.1.7,
    notes: upvote answers to bounties

    version: 0.1.6,
    notes: article editor refresh
    )...
    recent_tips: (
    tipper: @AriseFacilitySolutions09,
    tipped: article
    amount: 1000 SATS,

    tipper: @Yussuf4331,
    tipped: article
    amount: 1000 SATS,

    tipper: @darkwebsites540,
    tipped: article
    amount: 10 SATS,
    )...