Converting from ASP to PHP

So you're getting one row of data, and you want to display it in different places around the code/page. I don't think there's really a built in OO way to do that, here's what I would do:

Hi. Thanks for your reply.

Yes that is what I would like to do. I have tried what you have suggested before, but I have HTML content as well and I can not place the html content inside the ?> because it makes the PHP code invalid. so I can't seem to make it work. (Only when it is installed like yours is when it will work). The full PHP script inside a table.

I would like something like this:

Then the html content

echo $recordset1['LastName'];

And anywhere inside the html content (in a table) will then show echo $recordset1['LastName'];

Does this make sense?

Thanks.

Ok, I think I understand what you want. To output PHP within HTML, you do something like this (I couldn't post it here because the formatting is screwing the code up)

In the HTML you can put PHP short tags (I think that's what they're called). The syntax is <?=$var_name?> It also supports some logic, but I don't think you care about that.

Perfect. That's the answer. Thank you very much for pointing me in the right direction!

Well, been working on this for hours now, and I still can't get a result. Wonder if anyone can help.

Here is the php code that I am using to connect to the database:

And here is the code that I wish to place inside the html:

<?=$recordset1['title']?>

There may be just something simple stopping this working. But its gone way over my head.

Cheers.

At first glance, I see you aren't connecting to the database. You need to run connect() (just because you define it, doesn't make it run).

Hi teammatt3. Thanks for you comment. I have // db connect
function connect() at the top of the script. Is this not the same thing?

Thanks,
Darren

At the top of the script you have made your own "user defined" function and called it "connect".
I.E. You have told PHP what the function called "connect" is going to do.

But as teammatt3 said, you need to actually run that function like this-
connect();

So you made a function that connects to the database and called it "connect", so before your query, run that function so it performs the connection.

I copied and pasted your code from your last post and added the required bit to run the function you made.

Some other notes.

You dont have to close the DB connection (mysql_close) as it will automatically close it when the script is finished excecuting

You can just have the database connection parameters without a function, like so

What I usually do is make a seperate file and save the database connection values in that. Then whenever I have a page where I have a query, I just include that file with the database connection details in it.

In my opinion I think it's pointless to have the database connect parameters inside a function as you have it, simply because it's extra code to define it as a function then extra code to call it later in the script.
The point of creating a function is to be able to use it whenever you want, as many times as you want. I generally only make a function when I need a block of code that I will use a few times on the same page.

I might be wrong, but I dont think you quite understood user defined functions.
If I'm correct, have a read of this, it explains it very well
http://www.tizag.com/phpT/phpfunctions.php

The reason your disconnect function wont work is because it is using the variable $db to identify what connection to close. But the variable $db is defined within another function, and therefore is out of the scope of anything outside that function.
You can make it work by declaring the variables inside a function to be "Global"..
So, something else you might want to read to understand the relationship between variables inside and outside of "user defined" functions:
http://us2.php.net/variables.scope

Another thing I just noticed with your script too.

you have this:

The query code ($query) has an unnecessary bracket at the end.
Also, $numresults and $result are both doing the same thing, there is no need for both.

Here is a simpler way with exactly the same result:

Notice how I've taken out the line -
$result = mysql_query($query) or die("Couldn't execute query");
You shouldnt really use "or die" as it will output errors to site users, if it's public that's potentially bad.

The mysql_num_rows is the amount of rows mysql returned from the query. If it didnt find "hrc010" from the specified table then $numrows will be zero
So what is often better is outputting a message like this

If nothing is found then $numrows will be 0. Sometimes it can return less than 0 so is always safe to put less than or equal to zero

mysql_num_rows() only returns a value for selecting from the table
If you are changing the table, i.e. insert, delete etc, then use mysql_affected_rows()
Logically, as delete/insert etc will or wont have 'affected' the table

Hi. Thank you ever so much for you help.

The code I have used was taken from another script that I have just modified so I can use it as I learn. Your comments have helped me a great deal. I will post my outcome when I have time to implement it.

Thanks
Darren