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

            How to preserve electronics (computers, tablets and phones) for hundreds of years Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) The network's official Twitter account is up and running again. What content…How might modern humans leave a message for 50,000 years?How would an aquatic race develop computers?How do we make computers care for human life?Keeping supplies for 1000 yearsWhat will cell phones become in 100 years?What body armor protects against a laser?Could a society attain 1800s technology if limited to using copper and bronze?Electricity power (magic) and electronicsScavenging metal resources in post-apocalypse after 100 yearsWhy would precursors create devices that can survive and still work after hundreds of years?

            155 수학 과학 기타 둘러보기 메뉴eh추가해eh문서를 완성해

            Convert JSON to MapSimplest way to convert a string representing JSON array into Java array List of key value pairsHow to take String JSON values into HashMapConvert a JSON String to a HashMapCreating BSON object from JSON stringJSONObject - How to get a value ?Better Map ConstructorReading JSON from Url javaUpdate columns if input values are not null otherwise ignore and keep the existing values of column in databaseHow to store object represented as Json string into Couchbase Lite?Go JSON into MapHow do I efficiently iterate over each entry in a Java Map?Sort a Map<Key, Value> by valuesHow to round a number to n decimal places in JavaCan comments be used in JSON?How do I read / convert an InputStream into a String in Java?How can I pretty-print JSON in a shell script?What is the correct JSON content type?How can I deserialize JSON to a simple Dictionary<string,string> in ASP.NET?Why does Google prepend while(1); to their JSON responses?Parse JSON in JavaScript?