Jump to content

SQL Database, PHP 'pages' ?


Spunky
 Share

Recommended Posts

Ok actually I got two things.look at my websiteScroll all the way to the bottom. The first two posts have diamond shaped symbols with ?. Can anyone explain this? Each post is put on the page from a database. The code was copied and pasted directly. Like look at the current live version. All the way on the bottom is also those same two posts. I just copied and pasted the code into the database. Here is the code for one of the posts:

<div class="postEntry">	<img src="images/Michael.jpg" width="100" height="105" alt="Michael" id="profilePic" /><p><strong>February 21, 2011<br/>	Michael Schoell</strong></p>	<p><a href="darkForge.html">DarkForge</a> is one of my main projects that I continue to work on and expand. It is an engine I wrote utilizing DirectX9 and is used with: <a href="thePassage.html">The Passage</a>, <a href="mandelbrot.html">Mandelbrot</a>, and <a href="match.html">Match</a>. More information can be found on it's page. For me it is a recurring process: I expand code then I revise what I have done based on what was learned. In this fashion my code has become more robust and flexible while maintaining speed.</p>	<p>While flipping through the pages of <a href="http://www.gameenginegems.net/">Engine Gems 1</a>, I came across a gem by Colt McAnlis on a camera centric engine design. The first section touched on getting DirectX9 to be usable with multiple threads. I decided to try this method out and set to work. For me, the challenge was to seamlessly integrated this concept with <a href="darkForge.html">DarkForge</a> without putting the burden on the user.</p>	<p>The process is rather simple but requires some skill with synchronization between threads. No multithreaded flag is used with DirectX as it can have a serious performance hit. To do this, two command buffers are first created that will be used as memory pools. An update thread will fill one command buffer out with rendering and state calls. Once “render” is called, the command buffer is swapped with the render thread's and another frame can be updated while the DirectX API is working on the one the render thread owns. Only one frame ahead can be updated and each thread syncs when they are complete.</p>	<p>This project has been a major challenge as it is one of my first multithreaded applications outside of school. As it is still in the early stages, it is unknown as to what performance boost will be seen though such tests are currently in the works. When a working rendering example is established I hope to show it along with a detailed report on benchmarks between single and multithreaded performance.</p>	</div>

It's just regular HTML code pasted directly into the database. I don't understand why those symbols appear.Ok and my second thing is, I was wondering if someone could point me in the right direction on how to do something. Pertaining to the same posts coming from the database, I want to be able to have only a certain number of posts displayed at a time and if the number of posts exceed that, then a new 'page' is formed where users can click to view the next set of posts. I hope that I am explaining this correctly. This practice is done everywhere so it's nothing new and Im sure its nothing too complicated, I just need help getting started on how-to is all. I know it will take PHP and some if statements.Please and thank you. :)

Link to comment
Share on other sites

Those symbols appear if you display characters of one encoding but tell the browser that your page is using a different encoding. Your text is probably in ISO-8859-1 encoding, so you'll have to indicate that your page is using that encoding with a Content-type header or a <meta> tag.

Link to comment
Share on other sites

Those symbols appear if you display characters of one encoding but tell the browser that your page is using a different encoding. Your text is probably in ISO-8859-1 encoding, so you'll have to indicate that your page is using that encoding with a Content-type header or a <meta> tag.
Ok but I have stored data in a database before without touching whatever is the default there and I've also not touched the default that Dreamweaver puts on:
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

So whats different that it is freaking out? Since Im using tags in the content? And what would I change in the meta tag?

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...