help

Turbocharged_06 · #1 (**permalink**) 05-28-2007, 01:53 AM

im trying to learn php and was trying to display some info from my mysql tutorials table

PHP Code:


			
<?php

$mysqlhost = "localhost";

$mysqluser = "user";

$mysqlpass = "pass";

$mysqltable = "table";



mysql_connect( $mysqlhost , $mysqluser ,$mysqlpass ) or die ("Could not Connect");

mysql_select_db ( $mysqltable ) or die ("could not select db $mysqltable")

$sql = (" SELECT * FROM tutorials WHERE 1=1; ");

$result = mysql_query($sql);

echo $result;

?>

i got the error

HTML Code:

 parse error: syntax error, unexpected T_VARIABLE in /home/outlbnet/domains/outlaw-web.net/public_html/teest2.php on line 9

RonK · #2 (**permalink**) 05-28-2007, 03:05 AM

Quote:

Originally Posted by Turbocharged_06

im trying to learn php and was trying to display some info from my mysql tutorials table

PHP Code:


			
<?php

$mysqlhost = "localhost";

$mysqluser = "user";

$mysqlpass = "pass";

$mysqltable = "table";



mysql_connect( $mysqlhost , $mysqluser ,$mysqlpass ) or die ("Could not Connect");

mysql_select_db ( $mysqltable ) or die ("could not select db $mysqltable")

$sql = (" SELECT * FROM tutorials WHERE 1=1; ");

$result = mysql_query($sql);

echo $result;

?>

i got the error

HTML Code:

 parse error: syntax error, unexpected T_VARIABLE in /home/outlbnet/domains/outlaw-web.net/public_html/teest2.php on line 9

i think this should be right

Code:

<?php
$mysqlhost = "localhost";
$mysqluser = "user";
$mysqlpass = "pass";
$mysqltable = "table";

mysql_connect( $mysqlhost , $mysqluser ,$mysqlpass ) or die ("Could not Connect");
mysql_select_db ( $mysqltable ) or die ("could not select db $mysqltable");
$sql = (" SELECT * FROM tutorials WHERE 1=1; ");
$result = mysql_query($sql);
echo $result;
?>

u just forgot a ; sign

skyfe · #3 (**permalink**) 05-28-2007, 08:33 PM

Quote:

Originally Posted by Turbocharged_06

im trying to learn php and was trying to display some info from my mysql tutorials table

PHP Code:


			
<?php

$mysqlhost = "localhost";

$mysqluser = "user";

$mysqlpass = "pass";

$mysqltable = "table";



mysql_connect( $mysqlhost , $mysqluser ,$mysqlpass ) or die ("Could not Connect");

mysql_select_db ( $mysqltable ) or die ("could not select db $mysqltable")

$sql = (" SELECT * FROM tutorials WHERE 1=1; ");

$result = mysql_query($sql);

echo $result;

?>

i got the error

HTML Code:

 parse error: syntax error, unexpected T_VARIABLE in /home/outlbnet/domains/outlaw-web.net/public_html/teest2.php on line 9

What you want to show from the database? First of all, this will only output(if it would work) 1 or 0... This will output the query RESULT with the query #id... For getting all rows it selected with the query, and set it into a var, you can use mysql_fetch_assoc($var_with_query). And second: You call into the mysql_select_db a TABLE and also one which have not been set into the var yet, caus the variable is defined LATER than it's called... So this should it be:

Quote:

<?php
mysql_connect("localhost", "user", "password");
mysql_select_db("database_name");
$result = mysql_query(" SELECT * FROM tutorials WHERE 1=1; ");
while($row = mysql_fetch_assoc($result)) {
echo $row['field'];
}
?>

where 'field' is the field you want to show, take for example: Inside the table 'tutorials' you have the follow fields:
name author text
and there's 1 row found with the query which have this values in the fields in the table tutorials:
name: Test tutorial
author: Noone
text: test
and you want to show the value of the field 'name' (in this case that's "Test Tutorial" as you can see above) then you can do that like this:

Quote:

<?php
mysql_connect("localhost", "user", "password");
mysql_select_db("database_name");
$result = mysql_query(" SELECT * FROM tutorials WHERE 1=1; ");
while($row = mysql_fetch_assoc($result)) {
echo $row['name'];
}
?>

I hope you understand it some better now

Good luck!

Evan · #4 (**permalink**) 06-07-2007, 09:28 PM

Quote:

Originally Posted by RonK

i think this should be right

Code:

<?php
$mysqlhost = "localhost";
$mysqluser = "user";
$mysqlpass = "pass";
$mysqltable = "table";

mysql_connect( $mysqlhost , $mysqluser ,$mysqlpass ) or die ("Could not Connect");
mysql_select_db ( $mysqltable ) or die ("could not select db $mysqltable");
$sql = (" SELECT * FROM tutorials WHERE 1=1; ");
$result = mysql_query($sql);
echo $result;
?>

u just forgot a ; sign

Haha, good spoting took me a few minz to find that, surprised he didnt see it himself :P

Nick · #5 (**permalink**) 06-10-2007, 11:47 AM

PHP Code:


			
<?php

// Set Variables

$mysqlhost = "localhost";

$mysqluser = "user";

$mysqlpass = "pass";

$mysqldb = "db";



// Connect to the server

mysql_connect($mysqlhost, $mysqluser, $mysqlpass) or die ("Could not Connect");



// Pick the database

mysql_select_db($mysqldb) or die ("Could not select $mysqldb");



// Query for all the tutorials.

$tutorials = mysql_query("SELECT * FROM tutorials");



while ($tut = mysql_fetch_array($tutorials))

{

    print_r($tut);

}

?>

Neat code is good code.

What that will do is query into the tutorial table for all the tutorials then for each tutorial it finds it will output an array of information in the format;
field => data

Depending on what columns your table has, you could use this;

PHP Code:


			
<?php

// Set Variables

$mysqlhost = "localhost";

$mysqluser = "user";

$mysqlpass = "pass";

$mysqldb = "db";



// Connect to the server

mysql_connect($mysqlhost, $mysqluser, $mysqlpass) or die ('Could not Connect');



// Pick the database

mysql_select_db($mysqldb) or die ('Could not select ' . $mysqldb);



// Query for all the tutorials.

$tutorials = mysql_query("SELECT * FROM tutorials");



$code = '<table border="1" width="50%" align="center" cellpadding="6" cellspacing="1">';

while ($tut = mysql_fetch_array($tutorials))

{

    $code .= '    <tr>';

    $code .= '        <td><strong>Title: </strong>' . $tut['title'] . '</td>';

    $code .= '        <td><strong>Posted By: </strong>' . $tut['user'] . '</td>';

    $code .= '        <td><strong>Date: </strong>' . $tut['date'] . '</td>';

    $code .= '    </tr>';

}



$code .= '</table>';

echo $code;

?>

skyfe · #6 (**permalink**) 06-10-2007, 12:11 PM

yeah, print_r(array) shows the content of an array, in this case $tut contains all rows that have been found, good script

array(field => value)
will output for each field that have been found in a row with the query I guess?

Nick · #7 (**permalink**) 06-10-2007, 12:15 PM

It will output something like this for each row found;

Code:

Array
(
    [field1] => value1
    [field2] => value2
    [field3] => value3
    [field4] => value4
    [field5] => value5
)

You can view a demo here; http://www.vbulletin-skins.com/arr.php

skyfe · #8 (**permalink**) 06-10-2007, 12:15 PM

yeah, for each row

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode