Sedang Disiapkan

Upgrading PHP scripts and extraction of data in MySQL

On a site running PHP we have a simple form for publishing and editing articles.

We need to upgrade this form to make the process of publishing articles easier for our editorial staff.

An article is (in the database) saved in two tables; one for the article body and one for the title, ingres, author etc.

In the article body the images used in the article are referenced via HTML.

The project is divided into two parts because of this; MySQL and PHP

##### MySQL #####

All images (including the image caption) referenced in the article body needs to be extracted from the article body and placed in a seperate table with a reference to the article-ID.

The body for an article with ID 333 could look like this in the database:

"<p>A line in an article with ID 333.<p> A new line in the article. This is the article body. The image table will appear aligned to the right.<p>

<table width=150 class=\""""image\"""" align=\""""right\"""">

<tr>

<td><a href=\""""/img/mag/full/[url removed, login to view]\""""><img src=\""""/img/mag/mini/[url removed, login to view]\"""" class=\""""mini\""""></a></td>

</tr>

<tr>

<td class=\""""image_caption\"""">This is the image caption of image1.</td>

</tr>

<tr>

<td><a href=\""""/img/mag/full/[url removed, login to view]\""""><img src=\""""/img/mag/mini/[url removed, login to view]\"""" class=\""""mini\""""></a></td>

</tr>

<tr>

<td class=\""""image_caption\"""">This is the image caption of image 2.</td>

</tr>

</table>"

We have ~2800 articles in the database, with images in nearly everyone.

The article body should be reduced to:

<p>A line in an article with ID 333.<p> A new line in the article. This is the article body. The image table will appear aligned to the right.<p>

With the images extracted into a new database table (article_images) with the following fields:

image_id, article_id, image_full, image_mini, image_caption

1, 333, "/img/mag/full/[url removed, login to view]", "/img/mag/mini/[url removed, login to view]", "This is the image caption of image1."

2, 333, "/img/mag/full/[url removed, login to view]", "/img/mag/mini/[url removed, login to view]", "This is the image caption of image2."

(Because of the amount of data it would probably be wise to use regular expressions to accomplish this.)

##### PHP #####

This project could be the kickoff for other projects on the same site.

This is the first step in structuring, organizing and upgrading the code.

- Publishing in the backend -

An technical upgrade from todays publishing solution including:

A class to handle everything regarding publishing.

Form with typical input as title, section, ingres, author, photographer etc (detailed description on request)

Image-handling (GD imagehandling class already present, could be re-used)

In the article body it should be possible to mark text to make bold, headings, paragraphs etc.

- Reading in the frontend-

A class to handle the different article-views; full view, frontpage view, section view etc.

Make PHP scripts/classes to get an article from the database and echo to screen.

Scripts to accomplish this is already present, but they are outdated and in need of upgrading/renewing.

- Hopefully this is enough to get an image of what we need, more info is available on request.

Kemahiran: CSS, HTML, MySQL, PHP, Kejuruteraan Perisian

Lihat lebih lanjut: what to look for in a photographer, what is data input, use regular expressions, the right staff, simple scripts, simple html scripts, scripts in html, regular expressions info, regular expressions in c, regular expressions c, photographer editing, new line in php, mark fields, look php id, editorial section, editorial editing, data structuring, c regular expressions, author of this article, author of an article, article different author, align image with text css, echo parts, php full form, PHP SCRIPTS

Tentang Majikan:
( 4 ulasan ) Oslo, Norway

ID Projek: #1749276

Dianugerahkan kepada:

Sotirov

Hello, thanks for inviting me, I'm sending you some questions on private message. Regards

€350 EUR dalam 5 hari
(58 Ulasan)
6.8

20 pekerja bebas membida secara purata €389 untuk pekerjaan ini

neoconcepts

php/mysql team

€400 EUR dalam 4 hari
(109 Ulasan)
7.2
canlan318

Dear sir. I sent you a private message. Please check it. Regards.

€750 EUR dalam 21 hari
(76 Ulasan)
6.9
odmoriSe

Hi, more details in PM

€650 EUR dalam 5 hari
(35 Ulasan)
6.6
SRajpurohit

Hi! We are 100% sure that we can very easily complete your project with perfection. Please just check our Portfolio for your satisfaction. We Can provide the best work to you. So please give us a chance for your proj Lagi

€400 EUR dalam 10 hari
(45 Ulasan)
5.9
stdhtelkom

Hello, I am very interested. Please check pmb. Thanks, Steve

€300 EUR dalam 10 hari
(15 Ulasan)
5.6
phpplay

Please see inbox. Thanks

€275 EUR dalam 5 hari
(17 Ulasan)
5.5
virals2583

Hello, I am interested to work on your project. Please have a look to your PMB to see about my services. Regards, Nirav Shah

€250 EUR dalam 7 hari
(18 Ulasan)
5.4
pollux1er

Hi sir, I carefully read what you expect from posting this project. I am a PHP expert (Zend Certified PHP) and I have good skills in HTML/CSS. Ready to work on this project

€250 EUR dalam 14 hari
(27 Ulasan)
4.6
abupabuya

hi sir im an expert in scrape

€250 EUR dalam 5 hari
(16 Ulasan)
4.5
aoefmpes

pl check your INBOX

€250 EUR dalam 5 hari
(17 Ulasan)
4.3
sszelag

Hey, I have a few questions, please read PM.

€300 EUR dalam 3 hari
(7 Ulasan)
3.9
softaic

Hi I am very interested in your job. I have experienced with php,mysql and css. I am ready to start. I'll look forward for your reply. Thanks

€250 EUR dalam 6 hari
(4 Ulasan)
3.1
zhsoftstudio

Hello jonarvid, I am ready to start your PHP and MySQL project. Thanks.

€350 EUR dalam 5 hari
(7 Ulasan)
3.0
Nanda555

I am interested on your project

€300 EUR dalam 6 hari
(1 Ulasan)
2.8
virajrabara

I am expert PHP developer working with an IT company as project leader, started working as freelancer. I am interested to work with you. Looking for your reply Thanks

€300 EUR dalam 5 hari
(0 Ulasan)
0.0
balakumar6190

Hi, i'm a PHP Programmer, new to freelancing. I have developed various website. I have strong knowledge in PHP MySQL. Please check your private message for more details and i'm ready to start the project immediately. T Lagi

€250 EUR dalam 3 hari
(0 Ulasan)
0.0
phpeexpert

Hi, i have necessary Experience in web development for this proyect. I'm responsable and efficient

€350 EUR dalam 6 hari
(0 Ulasan)
0.0
E72RJBfk6

Custom software development - The Administrator removed this message due to advertising which breaches our Terms and Conditions.

€750 EUR dalam sehari
(0 Ulasan)
0.0
jaynickinfo

We checked your posting in detail and based on that we are ready to do work as per your budget and timing and we are ready to discuss the things with you

€600 EUR dalam 5 hari
(0 Ulasan)
0.0
Ashiii

Hello, I am sure you are keeping well. Will you please share complete details of your project with us? We have completed over 350 project for various industries. We are a company with 4 designers, 7 developers , Lagi

€450 EUR dalam 18 hari
(0 Ulasan)
0.0