Simon, Pls scroll down and get us the lower half also.
Kind regards, Bernard 2009/8/14 Simon Mutama <[email protected]>: > Bernard, > > See attached. > > Simn > > 2009/8/14 Bernard Wanyama <[email protected]> >> >> Hi Simon, >> >> Please give us the output of the phpinfo() function. >> Do a small php file like below and put it together with the rest of >> the php scripts, then access it via the browser: >> >> <?php >> phpinfo(); >> ?> >> >> This should help us understand what is present and what is not. >> >> Kind regards, >> Bernard >> >> 2009/8/14 Simon Mutama <[email protected]>: >> > Bernard, >> > >> > I do have it installed. Synaptics shows that the package is installed >> > and >> > when I run >> > >> > sudo apt-get install php5-mysql' >> > >> > The result is: >> > >> > php5-mysql is already the newest version. >> > >> > Simon >> > >> > >> > 2009/8/14 Bernard Wanyama <[email protected]> >> >> >> >> Simon, >> >> >> >> You might want to check that you have the package php5-mysql installed >> >> (PHP extensions that add MySQL functionality). >> >> >> >> If not, do a 'sudo apt-get install php5-mysql' >> >> >> >> HTH. >> >> >> >> Kind regards, >> >> Bernard >> >> >> >> 2009/8/14 Simon Mutama <[email protected]>: >> >> > All, >> >> > >> >> > I am running a LAMP server on Ubuntu 8.10. Can connect to the >> >> > database >> >> > using >> >> > either phpmyadmin or the CLI and manipulate databases successfully. I >> >> > can >> >> > also run .php files in my browser successfully provided the files do >> >> > not >> >> > contain any database functions. >> >> > >> >> > However, when I try to use PHP with MySQL functions, I get either a >> >> > blank >> >> > page or a syntax error. What am I doing wrong? >> >> > >> >> > For instance, the following code results in the syntax error: >> >> > >> >> > Parse error: syntax error, unexpected T_STRING in >> >> > /var/www/Test_Database_Access.php on line 6 >> >> > >> >> > <html> >> >> > <head></head> >> >> > <body> >> >> > <?php >> >> > // open connection to MySQL server >> >> > $connection = mysql_connect('localhost', 'guest', 'pass') ↵ >> >> > or die ('Unable to connect!'); >> >> > >> >> > // select database for use >> >> > mysql_select_db('northwind') or die ('Unable to select database!'); >> >> > // create and execute query >> >> > $query = 'SELECT * FROM items'; >> >> > $result = mysql_query($query) ↵ >> >> > or die ('Error in query: $query. ' . mysql_error()); >> >> > // check if records were returned >> >> > if (mysql_num_rows($result) > 0) >> >> > { >> >> > // print HTML table >> >> > echo '<table width=100% cellpadding=10 cellspacing=0 border=1>'; >> >> > echo >> >> > >> >> > '<tr><td><b>ID</b></td><td><b>Name</b></td><td><b>Price</b></td></tr>'; >> >> > // iterate over record set >> >> > // print each field >> >> > while($row = mysql_fetch_row($result)) >> >> > { >> >> > echo '<tr>'; >> >> > echo '<td>' . $row[0] . '</td>'; >> >> > echo '<td>' . $row[1] . '</td>'; >> >> > echo '<td>' . $row[2] . '</td>'; >> >> > echo '</tr>'; >> >> > } >> >> > echo '</table>'; >> >> > } >> >> > else >> >> > { >> >> > // print error message >> >> > echo 'No rows found!'; >> >> > } >> >> > // once processing is complete >> >> > // free result set >> >> > mysql_free_result($result); >> >> > // close connection to MySQL server >> >> > mysql_close($connection); >> >> > ?> >> >> > </body> >> >> > </html> >> >> > >> >> > Thanks >> >> > >> >> > Simon Mutama >> >> > >> >> > >> >> > _______________________________________________ >> >> > LUG mailing list >> >> > [email protected] >> >> > http://kym.net/mailman/listinfo/lug >> >> > %LUG is generously hosted by INFOCOM http://www.infocom.co.ug/ >> >> > >> >> > The above comments and data are owned by whoever posted them >> >> > (including >> >> > attachments if any). The List's Host is not responsible for them in >> >> > any >> >> > way. >> >> > --------------------------------------- >> >> > >> >> > >> >> > >> >> >> >> >> >> >> >> -- >> >> Bernard Wanyama >> >> Technical Manager >> >> Syntech Associates Ltd >> >> Suite 422, GPO Building >> >> Plot 35, Kampala Rd, Kampala, UGANDA >> >> Web: www.syntechug.com >> >> Cell: +256 71 2193979 >> >> Fixed: +256 41 4251591 >> > >> > >> > >> > -- >> > Simon Mutama >> > +256-753-259080 >> > >> >> >> >> -- >> Bernard Wanyama >> Technical Manager >> Syntech Associates Ltd >> Suite 422, GPO Building >> Plot 35, Kampala Rd, Kampala, UGANDA >> Web: www.syntechug.com >> Cell: +256 71 2193979 >> Fixed: +256 41 4251591 > > > > -- > Simon Mutama > +256-753-259080 > -- Bernard Wanyama Technical Manager Syntech Associates Ltd Suite 422, GPO Building Plot 35, Kampala Rd, Kampala, UGANDA Web: www.syntechug.com Cell: +256 71 2193979 Fixed: +256 41 4251591 _______________________________________________ LUG mailing list [email protected] http://kym.net/mailman/listinfo/lug %LUG is generously hosted by INFOCOM http://www.infocom.co.ug/ The above comments and data are owned by whoever posted them (including attachments if any). The List's Host is not responsible for them in any way. ---------------------------------------
