Php display data stuff.

rysliv

im trying to work with mysql and php i just got super confused with all this ****

what im trying to do is make the data in a table of my Mysql thing DISPLAY ON THE PAGE

this is all i found on the entire internet.

$query="SELECT * FROM contacts";
$result=mysql_query($query);

PATHETIC

WHERE WOULD I *ING PUT THIS *!!!!

all i see is Echo then some crap i dont know what it is.

then $query="SELECT * FROM contacts";
$result=mysql_query($query);

i dont even know how you guys script stuff for php anymore it used to be easy and simple to me now its HARD AND ADVANCED what the hell is this.

Bjom

It still is easy and simple. This might help.

ixalmida

I don't see what your problem is, except that you only went half-way there. Let's look at what each statement does:

1) $query="SELECT FROM contacts";
- This statement is simply a convenient way to store a query string in a variable. You could just as easily have skipped it: $result = mysql_query("SELECT FROM contacts");

2) $result=mysql_query($query);
- This creates a recordset called $result. The actual data isn't in a very useful format yet. NOTE: You may need to specify a database connection, which you'd get from a mysql_connect() statement. So you'd have: $result = mysql_query($query, $connection);

3) $row = mysql_fetch_assoc($result);
- This is the next step - fetching a row of data into an array called $row. NOTE: Though there are other ways to access a single field of data without this step, this way is generally the fastest.

4) echo $row['contact_name'];
- This will output an individual database field called "contact_name". You could also use print(), but I think echo() is more descriptive of output to a screen.

That's pretty much it (assumed you've correctly made your connection). Is that too complicated?

rysliv

Here is exactly what i would like.

My servers

takes the logged in users servers from the mysql database and lists the ones he has on the my servers list.

showing name of server cpu ram operating system

does same for remote control things but it has to have a link which i dont even know how to script this anymore cause i was away from a computer for a year and i forgot all this knowledge and im pissed about it i hate it!

i would love to be able to make this website of mine possible which is server hosting stuff but i cant cause i dont know how or ever under stand how php/mysql works anymore only thing i can do is integrate the script in a html page and use it.

😕

:mad:

😕

:mad:

🙁

ixalmida

Your question is too general. I would suggest you purchase a good book on PHP and MySQL and read it.

As for launching a remote control session, you might try:

<head>
<script>
  function runTSC()
    {
    var shell = new ActiveXObject("WScript.shell");
    shell.run("mstsc.exe");
    }
</script>
</head>

<body>
<p><A href="#" onclick="runTSC();">Click here.</a></p>
</body>

rysliv

🙂

i figured it all out no worrys if any moderator is there they can delete this thread.

Weedpacket

Actually, more useful to everyone would be if you posted your solution.