Search found 10 matches

by kelvin24
Sun Sep 23, 2012 7:32 am
Forum: mySQL & php coding
Topic: Help with mysqldump
Replies: 0
Views: 430

Help with mysqldump

<?php $dbhost = "localhost"; $dbuser = "root"; $dbpwd = "kelvin"; $dbname = "softeng"; date_default_timezone_set('Asia/Brunei'); $dumpfile = $dbname . "_" . date("Y-m-d_H-i-s") . ".sql"; passthru("/usr/bin/mysqldump --opt --host=$dbhost --user=$dbuser --password=$dbpwd $dbname > $dumpfile"); // rep...
by kelvin24
Wed Sep 19, 2012 6:56 am
Forum: mySQL & php coding
Topic: Help
Replies: 0
Views: 382

Help

<?php $localhost = "localhost"; $user = "root"; $password = "kelvin"; $db = "softeng"; $connect = @mysql_connect($localhost, $user, $password) or die("Could not connect to Localhost"); $db_handle = @mysql_select_db($db) or die("Could not connect to database"); echo "<center><table border='0'>"; if(...
by kelvin24
Wed Sep 05, 2012 8:43 am
Forum: mySQL & php coding
Topic: Password Confirmation
Replies: 1
Views: 712

Password Confirmation

Im trying to add a user and it requires to enter its password once again but when I enter a different password in the re type field it still records the data to the database. Here's my code <?php $con = mysql_connect('mysql16.000webhost.com', 'a1969010_root', 'kelvin0324') OR die("Error: ".mysql_err...
by kelvin24
Thu Aug 23, 2012 6:55 am
Forum: mySQL & php coding
Topic: PLEASE VERIFY MySQL SYNTAX
Replies: 1
Views: 541

PLEASE VERIFY MySQL SYNTAX

What is wrong with this syntax?

Code: Select all

$log="UPDATE log SET logouttime='$time' WHERE username='$_SESSION['username']'";
by kelvin24
Wed Aug 22, 2012 6:34 pm
Forum: PHP General
Topic: PHP track user activities and log
Replies: 1
Views: 455

PHP track user activities and log

Hello Guys! I'm an amateur in PHP coding is there a tutorial on how to track user activities and the time when he/she logs out and putit in a MySQL table?Please HELP :help:
thanks
by kelvin24
Wed Aug 15, 2012 6:22 pm
Forum: mySQL & php coding
Topic: Multiple Drop down list to filter MySQL Tables
Replies: 0
Views: 1108

Multiple Drop down list to filter MySQL Tables

I want to filter my table in MySQL by many categories but once I'd finished the other drop down list the IF statements of the first Drop down was not able to filter the table. The If Statement of the second filter was the one recognized. Here's the code.Please :help: <div> <form <?php echo $_SERVER[...
by kelvin24
Tue Aug 14, 2012 9:58 pm
Forum: mySQL & php coding
Topic: PLEASE HELP! Cannot access the Databace in MySQL
Replies: 7
Views: 1850

Re: PLEASE HELP! Cannot access the Databace in MySQL

I need a little help I tried using to use <td width='250px'> to edit the width of table row but nothing happened. This is my code. <?php $username = "root"; $password = "kelvin"; $hostname = "localhost"; $dbhandle = @mysql_connect($hostname, $username, $password) or die("Could not connect to databas...
by kelvin24
Tue Aug 14, 2012 6:08 pm
Forum: mySQL & php coding
Topic: PLEASE HELP! Cannot access the Databace in MySQL
Replies: 7
Views: 1850

Re: PLEASE HELP! Cannot access the Databace in MySQL

Thanks for all your help Guys!
by kelvin24
Tue Aug 14, 2012 8:09 am
Forum: mySQL & php coding
Topic: PLEASE HELP! Cannot access the Databace in MySQL
Replies: 7
Views: 1850

Re: PLEASE HELP! Cannot access the Databace in MySQL

kathirsrs wrote:Hi,

The same code works fine in my system.So please check with DB name and SQL connection.

The DB is correct. How will I know if the connection is correct?
by kelvin24
Mon Aug 13, 2012 5:26 pm
Forum: mySQL & php coding
Topic: PLEASE HELP! Cannot access the Databace in MySQL
Replies: 7
Views: 1850

PLEASE HELP! Cannot access the Databace in MySQL

I'm new to PHP and I'm seeking for your help. I have watched some tutorial about displaying MySQL tables in html and I've done exactly what it does but still it didn't display the tables. What's wrong with my code? :help: <?php $con = mysql_connect("localhost","root","kelvin"); if (!$con) { die('Cou...