[RESOLVED] Retreiving information from database

muramura

Please help I need to finish this project
I have designed a data base for my site and I would like it to be accessed as follows.
A link on the page gets titles of articles from the the table in the database
each of these titles are links to their corresponding articles and clicking one will give you the whole article with title date created and/or modified or as it was inserted in the database. just like a news article.
thanks
muramura

toxic_brain

what help do u need ? JOIN SELECT queries..?

muramura

I would like a code(s) to query the data base as I have described above

dougal85

This should help you

Omenizer

dougal85 wrote:
This should help you

Why dont you try and help him instead of being a twat about it!

dougal85

haha, i was just having a joke. but seriously there is plenty of PHP and mySQL (or other database) tutorials, guides, examples, etc, etc, out there.

Its not hard to find... let me just try me solution - wich would really help if it was carried out

http://www.google.com/search?q=PHP+and+mySQL
coutless step by step tutorials

Oh and your contribution was less useful than mine Omenizer, but thanks for your feek back too! 🙂

muramura

Thanks very much Dougal85 for your help.
Trouble is I do not know the use of this forum could you also please Highlight to me what kind of questions I should post so that I do not have to waste everybodies time asking trivial silly questions.
I know I am a light weight please give me direction
thanks
paddy

dougal85

Ok, No problem - thats all you needed to say 😉

From my understanding of your original post you want to do a whole lot at once and i'm assumin nil PHP knowledge. So... follow and read through this tutorial.

http://www.freewebmasterhelp.com/tutorials/phpmysql

It is very usefull (i used one like it, if not that one a few years ago when i started) and explains the basics of using a PHP and mySQL database.

I'll assume you have the database already on a server with PHP and it is a mySQL database.

Once you have read through that (or even tried the examples) you should have a decent understanding to complete your project. I cant hope to teach you all you need in this thread, without spending hours. So if you come accross problems on that site ask us about that section and show us what you have tried doing.

🙂

muramura

Thanks Dougal85 I have been reading thru the tutorial the last 45 min and it is very helpfull
this is certainly not the last time you are hearing from me.

muramura

I am running php 5. mysql 5 and apache 2 on windows 2000 pro

since I posted I have made some progress. I have managed to connect to the data base and display items i have used the code so far excluding obvious html

<?php

//address error handling.

ini_set('display_errors',1);
error_reporting(E_ALL & ~E_NOTICE);

//connect and select.
if( $dbc = mysqli_connect ('localhost', 'traineework', 'password', 'traineework'))
//define the query

$query = 'SELECT * FROM cvs order by created desc';
IF ($r = mysqli_query ($dbc, $query))
{
while ($row = mysqli_fetch_array ($r))
{
echo "<p><h3>{$row['profession']}</h3> <a href=\"cv_text.php \">{$row['headline']}</a> </p>\n";
}

}
else{

die ('<p>could not select the database because:<b>' .mysqli_error($dbc). '</b></p>');
}

mysqli_close($dbc);

My problem now is to provide a link to a page that will display the corresponding full text. For examlpe from the above code I would like the headline link to take one to the cv_text.php page that will have the rest of the text/article, the text/article is under column cv-text in my database.

I hope this explains my problem.

Kardall

Now you have to make a link load a page with variables in the URL ($_GET) so that when the page is loaded, it does something like... well here. If you have this link:

<a href=\"cv_text.php \">{$row['headline']}</a>

your cv_text.php is your page that will handle all input. When you generate this line of code, you need to put in the data that gave you "that headline". Like, the date. or however it is in there. If I assume the "created" is a date/time stamp, then you could do something like this

<?php

$query = 'SELECT * FROM cvs order by created desc';
IF ($r = mysqli_query ($dbc, $query))
{
while ($row = mysqli_fetch_array ($r))
{
echo "<p><h3>{$row['profession']}</h3> <a href=\"cv_text.php?{$row['created']}\">{$row['headline']}</a> </p>\n";
}

Something like that, hope you get the idea 🙂

muramura

and all i get in the browser is $cv_text

I have used ....."cv_text.php?{$row['cv_text']}........

and my cv_text.php code is this

..........

<?php

ini_set('display_errors',1);
error_reporting(E_ALL & ~E_NOTICE);


$cv_text = $_GET['cv_text'];

print '<p>$cv_text</p>';

Kardall

In order to output variables in a print statement you have to use double quotes "

print '<p>$cv_text</p>';

becomes

print "<p>$cv_text</p>";

Give that a shot 🙂

muramura

With the double quotes now I get a blank page.
however i can see the text in the address bar as a url.

Kardall

OH! I r teh dumb... I totally missed something.


mysql_fetch_array(

// Change this to

mysql_fetch_assoc(

// Now try it :) It should get the profession header name, make sure that when you grab it, that the actual column name is all lower case however you have it in your code, getting mysql_fetch_assoc() is case sensitive it seems.

muramura

Still doesnt work
Blank Page