Delete html files from pathWhat are valid values for the id attribute in HTML?Why not use tables for layout in HTML?Deleting an element from an array in PHPConvert HTML + CSS to PDF with PHP?HTML 5: Is it <br>, <br/>, or <br />?How to shrink/purge ibdata1 file in MySQLHow do you parse and process HTML/XML in PHP?Installing specific package versions with pipRedirect from an HTML pageWhy does HTML think “chucknorris” is a color?

Gaining Proficiency in Vehicles (water)

How do I separate enchants from items?

How to understand flavors and when to use combination of them?

My professor has told me he will be the corresponding author. Will it hurt my future career?

QR codes, do people use them?

Array or vector? Two dimensional array or matrix?

Is it okay to use open source code to do an interview task?

Why is a semiprime used as the modulus in RSA?

Is "wissen" the only verb in German to have an irregular present tense?

What are the effects of abstaining from eating a certain flavor?

With a data transfer of 50 GB estimated 5 hours, are USB-C claimed speeds inaccurate or to blame?

How can I use my cell phone's light as a reading light?

Moving millions of files to a different directory with specfic name patterns

Mtg creature spells, instants, priority?

As a supervisor, what feedback would you expect from a PhD who quits?

What was the significance of Spider-Man: Far From Home being an MCU Phase 3 film instead of a Phase 4 film?

What was the profession 芸者 (female entertainer) called in Britain?

Why does Trump want a citizenship question on the census?

Strong Password Detection in Python

What does "spinning upon the shoals" mean?

US citizen traveling with Peruvian passport

Chilling water in copper vessel

Where are the Wazirs?

Curly braces adjustment in tikz?



Delete html files from path


What are valid values for the id attribute in HTML?Why not use tables for layout in HTML?Deleting an element from an array in PHPConvert HTML + CSS to PDF with PHP?HTML 5: Is it <br>, <br/>, or <br />?How to shrink/purge ibdata1 file in MySQLHow do you parse and process HTML/XML in PHP?Installing specific package versions with pipRedirect from an HTML pageWhy does HTML think “chucknorris” is a color?






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








0















I'm trying to create a classified site from scratch. I was thinking for each ad that is published to create an html file. If I delete an ad from the database the html still remains. There is a way to bind the data from the mysql with the html to delete together (mysql info) + (html)?










share|improve this question

















  • 1





    You could obviously have a 'html_path' field, and include deleting the file in your deleteAdvert method. You could generate the html on the fly, removing the static html fields entirely. Any number of things. SO requires specific questions with repeatable code based problems, so this question is likely to be closed

    – Jason bamber
    Mar 25 at 22:32






  • 1





    If you end up with thousands of ads you don't want thousands of HTML files. A better way would be to use a template (or set of templates). They would be snippets of pre-built HTML and PHP, and you would use PHP to fetch the contents of a specific ad from the database, and then fill in the details in the relevant (pre-defined) places in the template. Just like this site does - notice how all the pages are basically the same layout, except the content of each part changes depending which question you're viewing? And how the URL contains the question ID? That's the kind of design you need.

    – ADyson
    Mar 25 at 22:33

















0















I'm trying to create a classified site from scratch. I was thinking for each ad that is published to create an html file. If I delete an ad from the database the html still remains. There is a way to bind the data from the mysql with the html to delete together (mysql info) + (html)?










share|improve this question

















  • 1





    You could obviously have a 'html_path' field, and include deleting the file in your deleteAdvert method. You could generate the html on the fly, removing the static html fields entirely. Any number of things. SO requires specific questions with repeatable code based problems, so this question is likely to be closed

    – Jason bamber
    Mar 25 at 22:32






  • 1





    If you end up with thousands of ads you don't want thousands of HTML files. A better way would be to use a template (or set of templates). They would be snippets of pre-built HTML and PHP, and you would use PHP to fetch the contents of a specific ad from the database, and then fill in the details in the relevant (pre-defined) places in the template. Just like this site does - notice how all the pages are basically the same layout, except the content of each part changes depending which question you're viewing? And how the URL contains the question ID? That's the kind of design you need.

    – ADyson
    Mar 25 at 22:33













0












0








0








I'm trying to create a classified site from scratch. I was thinking for each ad that is published to create an html file. If I delete an ad from the database the html still remains. There is a way to bind the data from the mysql with the html to delete together (mysql info) + (html)?










share|improve this question














I'm trying to create a classified site from scratch. I was thinking for each ad that is published to create an html file. If I delete an ad from the database the html still remains. There is a way to bind the data from the mysql with the html to delete together (mysql info) + (html)?







php html mysql






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Mar 25 at 22:27









Ene FlorianEne Florian

31 bronze badge




31 bronze badge







  • 1





    You could obviously have a 'html_path' field, and include deleting the file in your deleteAdvert method. You could generate the html on the fly, removing the static html fields entirely. Any number of things. SO requires specific questions with repeatable code based problems, so this question is likely to be closed

    – Jason bamber
    Mar 25 at 22:32






  • 1





    If you end up with thousands of ads you don't want thousands of HTML files. A better way would be to use a template (or set of templates). They would be snippets of pre-built HTML and PHP, and you would use PHP to fetch the contents of a specific ad from the database, and then fill in the details in the relevant (pre-defined) places in the template. Just like this site does - notice how all the pages are basically the same layout, except the content of each part changes depending which question you're viewing? And how the URL contains the question ID? That's the kind of design you need.

    – ADyson
    Mar 25 at 22:33












  • 1





    You could obviously have a 'html_path' field, and include deleting the file in your deleteAdvert method. You could generate the html on the fly, removing the static html fields entirely. Any number of things. SO requires specific questions with repeatable code based problems, so this question is likely to be closed

    – Jason bamber
    Mar 25 at 22:32






  • 1





    If you end up with thousands of ads you don't want thousands of HTML files. A better way would be to use a template (or set of templates). They would be snippets of pre-built HTML and PHP, and you would use PHP to fetch the contents of a specific ad from the database, and then fill in the details in the relevant (pre-defined) places in the template. Just like this site does - notice how all the pages are basically the same layout, except the content of each part changes depending which question you're viewing? And how the URL contains the question ID? That's the kind of design you need.

    – ADyson
    Mar 25 at 22:33







1




1





You could obviously have a 'html_path' field, and include deleting the file in your deleteAdvert method. You could generate the html on the fly, removing the static html fields entirely. Any number of things. SO requires specific questions with repeatable code based problems, so this question is likely to be closed

– Jason bamber
Mar 25 at 22:32





You could obviously have a 'html_path' field, and include deleting the file in your deleteAdvert method. You could generate the html on the fly, removing the static html fields entirely. Any number of things. SO requires specific questions with repeatable code based problems, so this question is likely to be closed

– Jason bamber
Mar 25 at 22:32




1




1





If you end up with thousands of ads you don't want thousands of HTML files. A better way would be to use a template (or set of templates). They would be snippets of pre-built HTML and PHP, and you would use PHP to fetch the contents of a specific ad from the database, and then fill in the details in the relevant (pre-defined) places in the template. Just like this site does - notice how all the pages are basically the same layout, except the content of each part changes depending which question you're viewing? And how the URL contains the question ID? That's the kind of design you need.

– ADyson
Mar 25 at 22:33





If you end up with thousands of ads you don't want thousands of HTML files. A better way would be to use a template (or set of templates). They would be snippets of pre-built HTML and PHP, and you would use PHP to fetch the contents of a specific ad from the database, and then fill in the details in the relevant (pre-defined) places in the template. Just like this site does - notice how all the pages are basically the same layout, except the content of each part changes depending which question you're viewing? And how the URL contains the question ID? That's the kind of design you need.

– ADyson
Mar 25 at 22:33












1 Answer
1






active

oldest

votes


















0














You need to have a path to your html file in the database table as well.
When you delete an entry with an ad, you also trigger the file deletion.



Do not forget: when you edit the ad you also need to update the corresponding html file.



Another approach would be to store the html directly in the table and use different caching solution to serve the content quickly.






share|improve this answer






















    Your Answer






    StackExchange.ifUsing("editor", function ()
    StackExchange.using("externalEditor", function ()
    StackExchange.using("snippets", function ()
    StackExchange.snippets.init();
    );
    );
    , "code-snippets");

    StackExchange.ready(function()
    var channelOptions =
    tags: "".split(" "),
    id: "1"
    ;
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function()
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled)
    StackExchange.using("snippets", function()
    createEditor();
    );

    else
    createEditor();

    );

    function createEditor()
    StackExchange.prepareEditor(
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: true,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: 10,
    bindNavPrevention: true,
    postfix: "",
    imageUploader:
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    ,
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    );



    );













    draft saved

    draft discarded


















    StackExchange.ready(
    function ()
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55347303%2fdelete-html-files-from-path%23new-answer', 'question_page');

    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    0














    You need to have a path to your html file in the database table as well.
    When you delete an entry with an ad, you also trigger the file deletion.



    Do not forget: when you edit the ad you also need to update the corresponding html file.



    Another approach would be to store the html directly in the table and use different caching solution to serve the content quickly.






    share|improve this answer



























      0














      You need to have a path to your html file in the database table as well.
      When you delete an entry with an ad, you also trigger the file deletion.



      Do not forget: when you edit the ad you also need to update the corresponding html file.



      Another approach would be to store the html directly in the table and use different caching solution to serve the content quickly.






      share|improve this answer

























        0












        0








        0







        You need to have a path to your html file in the database table as well.
        When you delete an entry with an ad, you also trigger the file deletion.



        Do not forget: when you edit the ad you also need to update the corresponding html file.



        Another approach would be to store the html directly in the table and use different caching solution to serve the content quickly.






        share|improve this answer













        You need to have a path to your html file in the database table as well.
        When you delete an entry with an ad, you also trigger the file deletion.



        Do not forget: when you edit the ad you also need to update the corresponding html file.



        Another approach would be to store the html directly in the table and use different caching solution to serve the content quickly.







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Mar 25 at 22:33









        NikNik

        1,1627 silver badges17 bronze badges




        1,1627 silver badges17 bronze badges


















            Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.







            Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.



















            draft saved

            draft discarded
















































            Thanks for contributing an answer to Stack Overflow!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid


            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.

            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55347303%2fdelete-html-files-from-path%23new-answer', 'question_page');

            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            Popular posts from this blog

            Kamusi Yaliyomo Aina za kamusi | Muundo wa kamusi | Faida za kamusi | Dhima ya picha katika kamusi | Marejeo | Tazama pia | Viungo vya nje | UrambazajiKuhusu kamusiGo-SwahiliWiki-KamusiKamusi ya Kiswahili na Kiingerezakuihariri na kuongeza habari

            Swift 4 - func physicsWorld not invoked on collision? The Next CEO of Stack OverflowHow to call Objective-C code from Swift#ifdef replacement in the Swift language@selector() in Swift?#pragma mark in Swift?Swift for loop: for index, element in array?dispatch_after - GCD in Swift?Swift Beta performance: sorting arraysSplit a String into an array in Swift?The use of Swift 3 @objc inference in Swift 4 mode is deprecated?How to optimize UITableViewCell, because my UITableView lags

            Access current req object everywhere in Node.js ExpressWhy are global variables considered bad practice? (node.js)Using req & res across functionsHow do I get the path to the current script with Node.js?What is Node.js' Connect, Express and “middleware”?Node.js w/ express error handling in callbackHow to access the GET parameters after “?” in Express?Modify Node.js req object parametersAccess “app” variable inside of ExpressJS/ConnectJS middleware?Node.js Express app - request objectAngular Http Module considered middleware?Session variables in ExpressJSAdd properties to the req object in expressjs with Typescript