Tag Info

New answers tagged

3

A sitemap does not usually help get pages indexed. See The Sitemap Paradox. To get pages indexed: You need to link to each page from some other page or preferably multiple other pages. Include enough unique content on each profile that Google doesn't view the pages as duplicate. Provide a good landing page experience for anybody coming to the page ...


9

Sitemaps can be dynamic just like web pages. Just have a PHP script grab those names from the database and make a loop to echo out the XML for each one. Also, make sure you output the proper content type for your XML. That's it. The code below is a basic script for generating a dynamic XML sitemap. Please not this is only an example intended to point you, ...


1

welcome to the site. This is exactly what SQL is for, and if you're already using php you are half way there. You should be able to look up how to access values from a MySQL database from php, and how to change them from the command line, and have the system up and running in under an hour. The best way to do this would be to make one row for each page ...


1

If your database is truely 'corrupted' as you stated, you are unlikely to be able to retrieve your post/page content. In either case, it is located inside your MySQL database inside the wp_posts table and more specifically the post_content column.


3

Doesn't matter what directory you run the command in, however it will save the sql dump file into the folder your currently in if using SSH to run the command. If you would like to save the file in an alternative path or should you be running it using a cron job then simply edit the last string with the full path you'd like to save the file too, i.e DBNAME ...


1

Keeping two databases in sync is known as "replication". MySQL supports database replication. In fact one of their use cases seems to match yours pretty well: Long-distance data distribution - if a branch office would like to work with a copy of your main data, you can use replication to create a local copy of the data for their use without requiring ...


1

There are hundreds of variations to development workflow and what you use should be tailored to what you need and how you work. XAMPP offers the ability to develop locally. It doesn't provide an ability to push those changes to a live server or sync between the two. Many text editors will provide you with the ability to push changes live (such as Sublime ...


5

LOOPING There are two methods to loop in PHP: for, and; foreach The PHP for Loop The for loop is used when you know in advance how many times the script should run. Syntax for (init counter; test counter; increment counter) { code to be executed; } Parameters: init counter: Initialize the loop counter value test counter: Evaluated for each loop ...



Top 50 recent answers are included