Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Page 1 of 3 1 2 3 LastLast
Results 1 to 10 of 22
  1. #1
    Senior Member Seldimi's Avatar
    Join Date
    Dec 2002
    Location
    Kozani, Greece
    Posts
    488
    Member #
    409
    Hey guys, are you interested in making one Article Management script ???

    I make the beginning from SQL
    Code:
    === Table 1 ===
    CREATE TABLE wp_article (
      id int(11) NOT NULL auto_increment,
      author varchar(255) NOT NULL default '',
      date_added datetime NOT NULL default '0000-00-00,
      title varchar(255) NOT NULL default '',
      preview varchar(255) NOT NULL default '',
      main_article varchar(255) NOT NULL default '',
      PRIMARY KEY  (id)
    ) TYPE=MyISAM;
    
    === Table 2 ===
    CREATE TABLE wp_author (
      id int(11) NOT NULL auto_increment,
      fname varchar(255) NOT NULL default '',
      age int(11) NOT NULL default '',
      location varchar(255) NOT NULL default '',
      email varchar(255) NOT NULL default '',
      PRIMARY KEY  (id)
    ) TYPE=MyISAM;
    I will soon try to make PHP Code, now :
    1) Can somebody help me make date automatic
    2) Can somebody make a column that counts total articles of a author ????
    3) Can I make the " main_article " column to be more than 255 characters ???
    - Webmaster's Planet . Greek Vortal For Webmasters ...
    - MyPortFolio - View My Creations

  2.  

  3. #2
    Senior Member Seldimi's Avatar
    Join Date
    Dec 2002
    Location
    Kozani, Greece
    Posts
    488
    Member #
    409
    Well here is the preview page where u can preview the article :
    (Not tested yet )
    (Notice that each article is called by "?id=number", eg preview_article.php?id=1)
    (Please re-download if u did before because I updated it)
    - Webmaster's Planet . Greek Vortal For Webmasters ...
    - MyPortFolio - View My Creations

  4. #3
    Senior Member Seldimi's Avatar
    Join Date
    Dec 2002
    Location
    Kozani, Greece
    Posts
    488
    Member #
    409
    I made main_article.php
    - Webmaster's Planet . Greek Vortal For Webmasters ...
    - MyPortFolio - View My Creations

  5. #4
    Senior Member Seldimi's Avatar
    Join Date
    Dec 2002
    Location
    Kozani, Greece
    Posts
    488
    Member #
    409
    Also author_profile.php is ready
    Now add_article.php left to be done ...
    - Webmaster's Planet . Greek Vortal For Webmasters ...
    - MyPortFolio - View My Creations

  6. #5
    Senior Member Seldimi's Avatar
    Join Date
    Dec 2002
    Location
    Kozani, Greece
    Posts
    488
    Member #
    409
    add_article.php done
    Please post here for anything you add.
    Also help me about what I told you above.
    (Special waiting transio, wired and other WDF members to help)
    - Webmaster's Planet . Greek Vortal For Webmasters ...
    - MyPortFolio - View My Creations

  7. #6
    Senior Member Seldimi's Avatar
    Join Date
    Dec 2002
    Location
    Kozani, Greece
    Posts
    488
    Member #
    409
    Oops!!! I forgot to upload it
    I am sorry filburt1 for so many replies I made
    - Webmaster's Planet . Greek Vortal For Webmasters ...
    - MyPortFolio - View My Creations

  8. #7
    Senior Member Brak's Avatar
    Join Date
    Apr 2003
    Location
    San Francisco, CA
    Posts
    3,413
    Member #
    1217
    Liked
    2 times
    Okay... few things.


    -to make the article more than varchar(255) merely put type blob.
    -automatic date either use the mysql NOW() fuction or php's date('Y-m-d H:i:s'); (DATETIME type)
    -to count the rows: mysql_num_rows($result); or use sql SELECT COUNT

    If you put a voting/comments system to this it might be interesting... but, I dunno. Seems kinda redundant with all the CMS's out there.. but if you're doing it to learn/practice php thumbs up!
    Kyle Neath: Rockstar extraordinare
    The blog | The poetry site | The Spore site

  9. #8
    WDF Staff Wired's Avatar
    Join Date
    Apr 2003
    Posts
    7,657
    Member #
    1234
    Liked
    138 times
    Sounds like a job for Transio! LMAO j/k

    Personally, I'd look towards something like iBF Portal, although coding one from scratch would be fun.
    The Rules
    Was another WDF member's post helpful? Click the like button below the post.

    Admin at houseofhelp.com

  10. #9
    Senior Member Seldimi's Avatar
    Join Date
    Dec 2002
    Location
    Kozani, Greece
    Posts
    488
    Member #
    409
    Can you explain further Brak how to do these things ? I am a newbie in mySQL and PHP
    - Webmaster's Planet . Greek Vortal For Webmasters ...
    - MyPortFolio - View My Creations

  11. #10
    Senior Member Seldimi's Avatar
    Join Date
    Dec 2002
    Location
    Kozani, Greece
    Posts
    488
    Member #
    409
    Also, it there any way to make it automatically (or manually) split article into pages if it has much length ???)
    And can sb check the code form add_article.php to fix it ???
    - Webmaster's Planet . Greek Vortal For Webmasters ...
    - MyPortFolio - View My Creations


Page 1 of 3 1 2 3 LastLast

Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -6. The time now is 12:32 PM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com