Ad:

PHP Discussion Thread
Unsolved
Views: 658

Feb 2nd, 2009

can't post a reply message in .php

Expand Post »

i used phpmyadmin software then i create a database named sycom_dbase, but the problem i can execute it. but there is no output? and error messages.. any comments suggestions. why did it happens. where should i save all my php files.. www? i save it in www folder but it didn't still connect to the database i guess. any connectors needed? please help thnks..
(im NEWBIE here)
Here's my sample code

PHP Syntax (Toggle Plain Text)
<?php
 
$sName = $_POST['engrSName'];
$sAdd = $_POST['engrAdd'];
$sPCode = $_POST['engrPCode'];
$sLline = $_POST['engrLline'];
$sMob = $_POST['engrMno'];
$sAge = $_POST['engrAge'];
$sBday = $_POST['engrYear'];
$sUname = $_POST['engrUName'];
$sPword = $_POST['engrPName'];
$sEmail = $_POST['engrEmail'];
 
mysql_connect("localhost","admin","charmander") or die('Error: ' . mysql_error());
mysql_select_db("sycom_dbase") or die('Error: ' . mysql_error());
 
mysql_query("INSERT INTO sycom_accountuser (sycom_Name, sycom_Address, sycom_PostalCode, sycom_Landline, sycom_Mobile, sycom_Age, sycom_Birthday, sycom_Username, sycom_Password, sycom_Email) VALUES(".$sName.",".$sAdd.",".$sPCode.",".$sLline.",".$sMob.",".$sAge.",".$sBday.",".$sUname.",".$sPword.",".$sEmail.")");
 
echo "Database Updated...";
 
 
?>
<?php

$sName = $_POST['engrSName'];
$sAdd = $_POST['engrAdd'];
$sPCode = $_POST['engrPCode'];
$sLline = $_POST['engrLline'];
$sMob = $_POST['engrMno'];
$sAge = $_POST['engrAge'];
$sBday = $_POST['engrYear'];
$sUname = $_POST['engrUName'];
$sPword = $_POST['engrPName'];
$sEmail = $_POST['engrEmail'];

mysql_connect("localhost","admin","charmander") or die('Error: ' . mysql_error());
mysql_select_db("sycom_dbase") or die('Error: ' . mysql_error());

mysql_query("INSERT INTO sycom_accountuser (sycom_Name, sycom_Address, sycom_PostalCode, sycom_Landline, sycom_Mobile, sycom_Age, sycom_Birthday, sycom_Username, sycom_Password, sycom_Email) VALUES(".$sName.",".$sAdd.",".$sPCode.",".$sLline.",".$sMob.",".$sAge.",".$sBday.",".$sUname.",".$sPword.",".$sEmail.")");

echo "Database Updated...";


?>

Similar Threads

PHP Sendmail Tutorial in PHP
PHP Form Validation ??? in PHP
PHP e-mail SMTP error ??? in PHP
PHP E-mail setting ??? in PHP
Error Message: Cannot find server; page cannot be displayed in Viruses, Spyware and other Nasties

rapperhuj

Reputation Points: 7

Solved Threads: 0

Light Poster

Offline

40 posts
since Apr 2007

Permalink

Feb 2nd, 2009

Re: can't post a reply message in .php

Sorry mate, you're not making much sense. What exactly is the problem. What errors do you get? Have you tried accessing the DB with a very simple query?

ardav

Sponsor

Featured Poster

Reputation Points: 1048

Solved Threads: 949

Sarcastic Poster

Offline

6,698 posts
since Oct 2006

Permalink

Feb 2nd, 2009

Re: can't post a reply message in .php

how to do it?
can u just give me some simple codes and where should i save my php files?

rapperhuj

Reputation Points: 7

Solved Threads: 0

Light Poster

Offline

40 posts
since Apr 2007

Permalink

Feb 2nd, 2009

Re: can't post a reply message in .php

You can put your files anywhere in your local server as long they have acces to the connection string:

PHP Syntax (Toggle Plain Text)
mysql_connect("localhost","admin","charmander") or die('Error: ' . mysql_error());
mysql_select_db("sycom_dbase") or die('Error: ' . mysql_error());
mysql_connect("localhost","admin","charmander") or die('Error: ' . mysql_error());
mysql_select_db("sycom_dbase") or die('Error: ' . mysql_error());

As a rule, you'd create a connection include file:

/includes/db.inc.php

You'd place this code into the file and then include this file in all your db-using "normal php files". A simple way to do this would be:

e.g. for files in your document root:

PHP Syntax (Toggle Plain Text)
include("includes/db.inc.php");
include("includes/db.inc.php");

then carry on creating your querystring and query the database.

ardav

Sponsor

Featured Poster

Reputation Points: 1048

Solved Threads: 949

Sarcastic Poster

Offline

6,698 posts
since Oct 2006

Permalink

Feb 2nd, 2009

Re: can't post a reply message in .php

other solutions sir.. after i included your suggestions it doesn't execute the test php file and the database..

i use phpmyadmin and created a database... if theres anything i configure first?

rapperhuj

Reputation Points: 7

Solved Threads: 0

Light Poster

Offline

40 posts
since Apr 2007

Permalink

Feb 2nd, 2009

Re: can't post a reply message in .php

Can you get a php file to show in your browser at all? Without any MySQL I mean. Just something easy like:

PHP Syntax (Toggle Plain Text)

echo "Hello World!";

Last edited by ardav; Feb 2nd, 2009 at 8:18 pm.

ardav

Sponsor

Featured Poster

Reputation Points: 1048

Solved Threads: 949

Sarcastic Poster

Offline

6,698 posts
since Oct 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: PHP Captcha Problem -- Please help me

Next Thread in PHP Forum Timeline: problems with php include

DaniWeb Message

Cancel Changes

User Name
Password