include.. but it doesn't!

[vinnie]

this is my include file that i have uploaded on the server called
DB_1.php

<?php
function connect()
{
// SERVER connection
$con=mysql_connect('host', 'My_user_ID', 'My_Pwd');
// DB selection
$sql=mysql_select_db('Database_name');
}
?>

when i point my browser to www.yyyyyy.com/insert_form.html and i
submit the form, it recalls the follwing file:

<?php
include ("DB_1.php");
// connect();
$query_table="insert into table_name values('$_POST[nome]',
'$_POST[cognome]','$_POST[indirizzo]', '$_POST[telefono]',
'$_POST[cell]','$_POST[email]')";
$insert=mysql_query($query_table) or die(mysql_error());
if (mysql_query($query_table, $con))
{
header ("Location: http://www.yyyyyy.com/thanks.html");
exit;
}
else
{
echo '<br>something went wrong<br>';
}
?>

nothing happens, and no record are added to my database. Why? What
should i change?

[Spartacus]

vinnie wrote:

this is my include file that i have uploaded on the server called
DB_1.php

<?php
function connect()
{
// SERVER connection
$con=mysql_connect('host', 'My_user_ID', 'My_Pwd');
// DB selection
$sql=mysql_select_db('Database_name');
}
?>

when i point my browser to www.yyyyyy.com/insert_form.html and i
submit the form, it recalls the follwing file:

<?php
include ("DB_1.php");
// connect();
$query_table="insert into table_name values('$_POST[nome]',
'$_POST[cognome]','$_POST[indirizzo]', '$_POST[telefono]',
'$_POST[cell]','$_POST[email]')";
$insert=mysql_query($query_table) or die(mysql_error());
if (mysql_query($query_table, $con))
{
header ("Location: http://www.yyyyyy.com/thanks.html");
exit;
}
else
{
echo '<br>something went wrong<br>';
}
?>

nothing happens, and no record are added to my database. Why? What
should i change?

Maybe the php.ini settings need to allow include files in the "current
directory" or perhaps DB_1.php is not in the same directory as your script?

Spartacus

[skeles]

Your SQL query may be wrong. Try this one:

$query_table="insert into table_name values('".$_POST['nome']."',
'".$_POST['cognome']."','".$_POST['indirizzo']."', '".
$_POST['telefono']."',
'".$_POST['cell']."','".$_POST['email']."')";

[Schraalhans Keukenmeester]

At Wed, 13 Jun 2007 09:18:52 -0700, vinnie let h(is|er) monkeys type:

this is my include file that i have uploaded on the server called
DB_1.php

<?php
function connect()
{
// SERVER connection
$con=mysql_connect('host', 'My_user_ID', 'My_Pwd');
// DB selection
$sql=mysql_select_db('Database_name');
}
?>

when i point my browser to www.yyyyyy.com/insert_form.html and i
submit the form, it recalls the follwing file:

<?php
include ("DB_1.php");
// connect();
$query_table="insert into table_name values('$_POST[nome]',
'$_POST[cognome]','$_POST[indirizzo]', '$_POST[telefono]',
'$_POST[cell]','$_POST[email]')";
$insert=mysql_query($query_table) or die(mysql_error());
if (mysql_query($query_table, $con))
{
header ("Location: http://www.yyyyyy.com/thanks.html");
exit;
}
else
{
echo '<br>something went wrong<br>';
}
?>

nothing happens, and no record are added to my database. Why? What
should i change?

You open the connection in a function, this makes $con a local variable to
the function which goes out of scope as soon as the function ends. So your
quesry isn't sent to the db.

you could instead return $con from the function, call it like so:

$conn = connect();

and then execute your query.
Note that you should _never_ trust POST userdata (nor GET for that
matter); first validate it, sanitize it and only then put stuff into a db
table.

HTH

--
Schraalhans Keukenmeester - sc*********@the.Spamtrapexample.nl
[Remove the lowercase part of Spamtrap to send me a message]

"strcmp('apples','oranges') < 0"

[Jeff North]

On Wed, 13 Jun 2007 09:18:52 -0700, in comp.lang.php vinnie
<ce**********@gmail.com>
<11**********************@o11g2000prd.googlegroups .comwrote:

>| this is my include file that i have uploaded on the server called
| DB_1.php
|
| <?php
| function connect()
| {
| // SERVER connection
| $con=mysql_connect('host', 'My_user_ID', 'My_Pwd');
| // DB selection
| $sql=mysql_select_db('Database_name');
| }
| ?>
|
| when i point my browser to www.yyyyyy.com/insert_form.html and i
| submit the form, it recalls the follwing file:

Rename www.yyyyyy.com/insert_form.html to
www.yyyyyy.com/insert_form.php then the web server will process your
page. At present, because of the extension, the web server isn't
looking at your file to see if it needs to anything with the files'
contents.

>| <?php
| include ("DB_1.php");
| // connect();
| $query_table="insert into table_name values('$_POST[nome]',
| '$_POST[cognome]','$_POST[indirizzo]', '$_POST[telefono]',
| '$_POST[cell]','$_POST[email]')";
| $insert=mysql_query($query_table) or die(mysql_error());
| if (mysql_query($query_table, $con))
| {
| header ("Location: http://www.yyyyyy.com/thanks.html");
| exit;
| }
| else
| {
| echo '<br>something went wrong<br>';
| }
| ?>
|
| nothing happens, and no record are added to my database. Why? What
| should i change?

---------------------------------------------------------------
jn******@yourpantsyahoo.com.au : Remove your pants to reply
---------------------------------------------------------------

[Toby A Inkster]

vinnie wrote:

<?php
function connect()
{
// SERVER connection
$con=mysql_connect('host', 'My_user_ID', 'My_Pwd');
// DB selection
$sql=mysql_select_db('Database_name');
}
?>

<?php
function connect()
{
// SERVER connection
$con=mysql_connect('host', 'My_user_ID', 'My_Pwd');
// DB selection
$sql=mysql_select_db('Database_name');

return $con;
}
$con = connect();
?>

If you don't understand this, please read the PHP manual -- the part which
explains what a function is and how they work. Read the bits on variable
scope too.

--
Toby A Inkster BSc (Hons) ARCS
[Geek of HTML/SQL/Perl/PHP/Python/Apache/Linux]
[OS: Linux 2.6.12-12mdksmp, up 110 days, 20:10.]

URLs in demiblog
http://tobyinkster.co.uk/blog/2007/05/31/demiblog-urls/

[Willem Bogaerts]

<?php

include ("DB_1.php");
// connect();
$query_table="insert into table_name values('$_POST[nome]',

Why is the call to the connect function commented out? If you do want
the function to be called, remove the // at the start of that line.

Best regards,
--
Willem Bogaerts

Application smith
Kratz B.V.
http://www.kratz.nl/