html - Linking to full blog post sql -

-

I have been working on my husband's website for a while. I am currently redesigning the site, and I want to make it more future-proof. At present, their blog posts show only in a row on their page (some endorsement for breaking it), which means If someone wants to add a post to their favorites, then it will not work with joining more posts. Therefore, I want to make a slightly longer post which is then linked to the full post.

My question is, how does this happen? I have tried to find answers to many questions, but what I can find is how to set up my own database (which I already have) and how to create log-ins (which I do not need) ), And echo those posts that I already have.

Actually, I want a fraction from the post (first few rows or something else), and then a link to read the full article. I really do not know exactly how to exclude individual HTML pages for each post, rather than taking them out of our database. Ie, I do not know the URL needed to display the full post. And code) to be automatically created

I'm sorry, if I'm not saying it the best way, the answer is probably out there, I can not seem to find just the right thing to do: (

Edit The website has a database that is very easily installed with mySQL, ID, title, body and date.

To stop the notion that your blog posts are in a table named "codepost " in your database. That you are currently doing something like Select ID, Title, body, blog post order, ID from DESC , then looping through result,

In order to handle this, you need to keep the page load with the list of snippets you want, with each link when it is pressed, the page will be reloaded and Only the blog post will show.

Your snippets To get, you have to change your SQL slightly: 

  select ID, heading, cnet (substrings (body 1 to 300), "...") of the body In the form, the date from the blog post   
 This will give you 300 characters before each blog post, for example.  
 In your PHP where you loop through the result and your  & lt; P & gt; & Lt; / P & gt;  Everything around will need to add a new link tag ... something like  
  echo & lt; A href = "index.php? Blogpost =" & amp; & Lt; This blogposts id & gt; & Amp; '' & Gt; Read more & lt; / A & gt; '  
 This will return the blog post's ID as a variable on the index.php page, so the browser will refresh and you will be refreshed  blogPost = $ _ GET [' blogpost ' ]  Hold on the top of your php page and act on it and act on it. Obviously this makes your code a bit more complicated because now you have to determine whether a variable was sent and either all are displayed snippets (if the blog post variable is empty) or just display the blog post (only that Select and display ID from the table).  
 This also introduces a bigger security risk through SQL injection. Now URL like:  http://spidersinajar.com/index.php?id=1 or a = a; Drop table blog post;  And Josh add irregular SQL to your database by adding your table  
 There is obviously a lot of code that you can write, but it's a high level and you're coming in. Should give some direction for

Comments

Post a Comment

Popular posts from this blog

php - PDO bindParam() fatal error -

-
I am trying to learn PDO, now I have written this small code, but it gives me a serious error: < P> Fatal error: Call a member function at a non-object dot () ... $ con = new mysqli ("127.0.0.1", "root", "", "csvdangercheck"); $ Query = $ con- & gt; ("Id,` var1`, `var2`) values ​​(" id,: var1,: var2) ";); $ query- & gt; bypass pattern (': id', $ id); $ query- & gt; BindParam (': var1', $ VAL1); $ Query- & gt; bindParam (': var2', $ val2); $ Query-> Executed (); I Trying to use print_r ($ con-> errorInfo ()) but Fatal error: Undefined method mysqli :: errorInfo ( ) ... can someone tell me what am I missing? Flaffeh said, you have PDO Missing Mysqy, try it: $ con = new PDO ('mysql: host = 127.0.0.1; dbname = csvdangercheck', 'root', '');
Read more

logging - How can I log both the Request.InputStream and Response.OutputStream traffic in my ASP.NET MVC3 Application for specific Actions? -

-
For a specific set of tasks, I need to log in to the incoming request inputstream as well as outgoing response. is. I am using an ActionFilterAttribute for this and overriding the OnActionExecuted and OnResultExecuted methods. So I'm starting with this idea ... Public category ActionLoggerAttribute: ActionFilterArrbit {Public Override Zero On-Offed Execution (ActionActioned Contact Filter Filter) {base.OnActionAxecuted (FilterContext); HttpRequestBase request = filterContext.HttpContext.Request; // TODO: Log the request. InputStream} Public Override Zero OnResultExecuted (ResultExecutedContext FilterContext) {base.OnResultExecuted (filterContext); HTTPRPSPointBase Response = FilterContacts Hpptex response; // TODO: Log on Response.OutputStream}} Ideally I'll hook it up with enterprise library logging because I'm already using it for error logging. Am I reaching the input and output stream at the right time? Can I easily use the Enterprise Library to log i
Read more

java - Why my included JSP file won't get processed correctly? -

-
I am trying to create Java web framework (and learning), and on the basis of 'Code Generator In the process of making the material view of the database in the process of development, I stumbled into a difficulty, which I do not know how to solve it. First of all, I want the following index.jsp : & lt; Body & gt; Use all pages to be created. & Lt;% @ include file = "header.jsp"% & gt; & Lt; Hours / & gt; & Lt;% @ included file = "body.jsp"%> & Lt; Hours / & gt; & Lt;% @ include file = "footer.jsp"% & gt; & Lt; / Body & gt; And, in body.jsp , I should have it like this: & lt; Jsp: include page = "$ {Application_modul}"%> Where application_modul is an attribute defined in its controller: request.setAttribute ("application_modul", "USER_ACCOUNT \\ ' View_user_account.jsp "); This file can be found properly, but the processed JSP does
Read more