Article script
Article script is project number 219888 posted at GetAFreelancer.com. Click here to post your own project.
| Status: |
Closed
(Selected Service Provider)
|
| Selected Providers: |
selected service provider
Pektsekye
|
| Budget: |
$30-250
|
| Created: |
01/30/2008 at 12:37 EST |
| Bidding Ends: |
02/02/2008 at 12:37 EST
|
| Project Creator: |
venaas
Buyer Rating:           (6 reviews)
|
| Description: |
Hi.
We need a script that can add a article in a mySQL db. We don't need the showing or a design. Just the article add script.
The fields we need are
Header: The subjet of the article. Body: The article it self. Bodysmal: A small description of article.
The images should all be croped/resized from 1 image. The path for the images is /images/article/ Image1: Size of the crop function H 100 px x W 75 px Image2: Size of the crop function H 100 px x W 240 px Image3: Size of the crop function H 300 px x W 765 px Date: The date that the article was made. Dateshow: The date that the article is going public. UID: The user id that made the article.
The mySQL table taht it should be inserted into:
CREATE TABLE `news` ( `nid` int(6) unsigned NOT NULL auto_increment, `uid` int(6) unsigned default NULL, `header` varchar(255) default NULL, `date` datetime default NULL, `dateshow` datetime default NULL, `body` longtext, `bodysmal` text, `image1` varchar(255) default NULL, `image2` varchar(255) default NULL, `image3` varchar(255) default NULL, PRIMARY KEY (`nid`), UNIQUE KEY `nid` (`nid`), KEY `nid_2` (`nid`) ) ENGINE=MyISAM /*!40100 DEFAULT CHARSET=latin1*/;
|
| Job Type: |
|
| Database: |
MySQL
|
| Operating system: |
Linux
|
| Bid count: |
7
|
| Average bid: |
$ 65
|
|

|