1

I am just starting to learn how to create backends for sites, since I already have a working knowledge of front-ends, but since I don't really understand making Wordpress themes, and it seems like a lot to learn for what it is truly worth, I am now asking, how do you go about two things.

  1. How do you make a back-end page that will load the data from a table, and put it in an html table, then make each of those rows link to a page that...

  2. Automatically loads the data specified in question 1 into an HTML form, and has a button that will update it?

If you need clarification on any part of any of my questions, just ask, I know it is probably a lot to ask, so even if you could just tell me where/how you learned to do this kind of high level coding, that would be great.

I really want to learn, not just copy and paste forever, so like I said, if you know and don't feel like explaining it, I'd be very interested in knowing where you learned it!

Improve this question
7
  • 1
    amazon.com/PHP-MySQL-Web-Development-Edition/dp/0672329166 Commented Dec 27, 2013 at 20:44
  • Please show us what you have tried, and in response to your "for what it is" remark above, if you are interested in using it, then maybe it is worth more than that. Go to wordpress documentation, it is extremely easy using have_posts get_post, but you would need to actually try before asking for help. We are no here to do things for you, we are here to help if you get stuck! Commented Dec 27, 2013 at 20:45
  • I have tried CodeAcademy, but even though it is a very good and fun learning environment, it is so basic that you can barely scratch the surface with it, and I have tried reading W3, but it too is pretty basic. Is this the book that you used to learn it all? Commented Dec 27, 2013 at 20:46
  • Also, thanks for telling me about the wordpress documentation, what is the link for that? And as I said above, I am mostly just asking for a resource to help me with those above questions, not asking for a free ride. Commented Dec 27, 2013 at 20:48
  • @user3057550 codex.wordpress.org and you want theme development, however if you want information on how to make a form that updates when you submit it, I do not know if that is in there or not, but it is for admin pages, just not regular pages. Commented Dec 27, 2013 at 20:54

1 Answer 1

Reset to default
1

A "backend" table is called an SQL table, usually (and in the case of wordpress) it uses an SQL variant called MySQL.

To get data from an SQL table, you need to execute a query against it. For example:

SELECT `title`, `content` FROM `posts` WHERE `id` = 42;

This query will get (or SELECT) the title and content columns FROM the posts table, WHERE the id value of the row is equal to 42.

When a query is executed, PHP is returned with a resultset, usually in the form of an object or a resource, which can later be transferred into meaningful objects or arrays..

Each of the two steps you've asked about uses a different query. One to get all the entries, the other, based on the query parameter in the URL (http://example.com/index.php?query=parameter), queries a specific entry for more information to display it.

Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

@user3057550: If this answer helped you, consider upvoting it (by clicking on the up arrow above the answer's score). If you found it to solve your problem, consider accepting it by clicking on the large green tick mark under the question's score. Good luck, and enjoy the site :)
It says that I need 15 reputation to up vote it, but if nobody else answers better soon then I'll just check it.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.