<?php error_reporting(E_ALL); ini_set('display_errors', 'on'); ?> /* paste the code above at the top of your script to enable error reporting and run the app from a browser. */ On 7/26/13, Samuel Waithaka <samwaithaka@gmail.com> wrote:
Code is not executing in the first place; you'd at least expect a PHP error. Check your PHP installation; do a "Hello World"; the phpinfo()?.. make sure that your file is a .php (not php.txt....) - means you have to unhide file extensions.
On Fri, Jul 26, 2013 at 6:15 PM, Andrew Nduati <nduatiandrew@gmail.com>wrote:
(' .$name. $cname. ''; mysql_close($dblink); ?>) Hey thats is what I'm getting.. Still looks the same as before..
On Fri, Jul 26, 2013 at 5:13 PM, Victor Yegon <viktayeg@gmail.com> wrote:
<?php
//Define database connection
$dblink = mysql_connect("localhost","root","") or die("Could not connect"); mysql_select_db("sample") or die(mysql_error());
$query = mysql_query("select * from Customers");
while($row = mysql_fetch_array($query)) {
$name = $row['CustomerName']; $cname= $row['ContactName']; }
echo '<div>' .$name. $cname. '</div>';
mysql_close($dblink); ?>
Check your table name if C is in uppercase or lowercase.
On Fri, Jul 26, 2013 at 4:01 PM, Andrew Nduati <nduatiandrew@gmail.com>wrote:
Looks like the same problem (*'; } mysql_close($connection); ?>*)
On Fri, Jul 26, 2013 at 3:31 PM, Eugene Maritim < kiprotich.maritim@gmail.com> wrote:
Ok! I just tweaked your code a little, Update the code as suits you!
<?php
//Define database connection $connection = mysql_connect('host', 'username', 'password');
//Select our database if(!mysql_select_db('sample')) { echo 'Could not connect to the database'; die(); }//if
$customers = mysql_query('select * from Customers', $connection);
while($profile = mysql_fetch_array($customers)) { echo $profile['CustomerName'] . ', ' . $profile['ContactName']; echo '<br/>'; }
mysql_close($connection);
On Fri, Jul 26, 2013 at 3:09 PM, Andrew Nduati <nduatiandrew@gmail.com>wrote:
Thanks for the response. The problem is still the same. I've just tried getting rid of the second echo but all I get is a blank screen. And I've confirmed that the DB has records.
On Fri, Jul 26, 2013 at 1:00 PM, Eugene Maritim < kiprotich.maritim@gmail.com> wrote:
> Hey! > > Find edited code below: > 1. Swapped the order params of mysql_select > 2. Changed mysql_select.db to mysql_select_db > > <html> > <head> > <title>PHP Test</title> > </head> > <body> > <?php > > > //SQL Part > $host="localhost"; > $username="root"; > $password=""; > > > > $conn= mysql_connect($host,$username,$password) or exit("Connection > Error".mysql_error()); > > mysql_select_db('sample') or exit("Database not found"); > > > //Data from the query is stored in $result > $result = mysql_query("SELECT * FROM profiles", $conn); > > > while($row = mysql_fetch_array($result)) > { > echo $row['CustomerName'] . " " . $row['ContactName']; > echo "<br>"; > } > mysql_close($conn); > ?> > </body> > </html> > > > > On Fri, Jul 26, 2013 at 2:46 PM, Andrew Nduati < > nduatiandrew@gmail.com> wrote: > >> Good Afternoon Skunks, >> Below is my PHP code that is meant to run an SQL Select >> query however it doesn't seem to be working. All I'm getting when I >> open it >> in the browser (*"; } mysql_close($con); ?> "*) >> Please assist. >> Kind regards. >> >> >> >> <html> >> <head> >> <title>PHP Test</title> >> </head> >> <body> >> <?php >> >> >> //SQL Part >> $host="localhost"; >> $username="root"; >> $password="*****"; >> >> >> $conn= mysql_connect($host,$username,$password) or exit("Connection >> Error".mysql_error()); >> >> mysql_select.db('sample') or exit("Database not found"); >> >> //Data from the query is stored in $result >> $result = mysql_query($conn,"SELECT * FROM Customers"); >> >> while($row = mysql_fetch_array($result)) >> { >> echo $row['CustomerName'] . " " . $row['ContactName']; >> echo "<br>"; >> } >> mysql_close($conn); >> ?> >> </body> >> </html> >> >> _______________________________________________ >> skunkworks mailing list >> skunkworks@lists.my.co.ke >> ------------ >> List info, subscribe/unsubscribe >> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >> ------------ >> >> Skunkworks Rules >> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >> ------------ >> Other services @ http://my.co.ke >> > > > _______________________________________________ > skunkworks mailing list > skunkworks@lists.my.co.ke > ------------ > List info, subscribe/unsubscribe > http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks > ------------ > > Skunkworks Rules > http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 > ------------ > Other services @ http://my.co.ke >
_______________________________________________ skunkworks mailing list skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ skunkworks mailing list skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ skunkworks mailing list skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Regards,
Yegon Victor | Web Specialist/Internet Consultant |
_______________________________________________ skunkworks mailing list skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ skunkworks mailing list skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Samuel Waithaka http://twitter.com/samwaithaka
-- Regards, -- k n "Knowing is not enough; we must apply. Willing is not enough; we must do." - Bruce Lee