Page 1 of 1
Including my sql connection
Posted: Sat Oct 01, 2011 2:15 pm
by YoussefSiblini
Hi Guys ,
I am trying to insert data into 2 databases, what I am using is:
Code: Select all
//insert into the ALL database
include_once "includes/ALL.php";
$addsql = mysql_query("INSERT INTO $Category (UserName, firstname, lastname) VALUES ('$UserName','$first_name','$last_name')");
//Include Second Database and insert into it
include_once "includes/Stored.php";
$addsql = mysql_query("INSERT INTO $Category (UserName, firstname, lastname) VALUES ('$UserName','$first_name','$last_name')");
But this code is not working?
Youssef
Re: Including my sql connection
Posted: Sat Oct 01, 2011 5:01 pm
by YoussefSiblini
mm I think I am adding more characters to the text field in the database, do any one have an idea how many characters am i allowed to enter into a text field in the database?
Re: Including my sql connection
Posted: Sat Oct 01, 2011 6:35 pm
by twinedev
Execute the following query:
DESCRIBE `table_name`;
Re: Including my sql connection
Posted: Sun Oct 02, 2011 3:24 am
by YoussefSiblini
sorry but what does that do?
Re: Including my sql connection
Posted: Sun Oct 02, 2011 4:05 am
by twinedev
It describes the table, including the size or varchars so you know how many characters you can put into it.
-Greg
Re: Including my sql connection
Posted: Sun Oct 02, 2011 4:25 am
by YoussefSiblini
Thank you,
I am not sure if this problem I am having is from this but I will give you an idea,
First this error happen only if the user put lots of text, and it work fine if he input a few amount of text.
I got a text area in my page user input in that area then when the user press the button that value stored in a temporary table (which works fine), when I try to copy the data from this temporary table into the actual table it does not copy them (as mentioned only if the user input a big amount of characters in the text area).
Here is the info:
Temporary table
Code: Select all
# Column Type Collation Attributes Null Default Extra Action
1 id int(11) No None AUTO_INCREMENT Change Drop More
2 track_ID varchar(255) latin1_swedish_ci Yes NULL Change Drop More
3 UserName varchar(200) latin1_swedish_ci No None Change Drop More
4 firstname varchar(200) latin1_swedish_ci No None Change Drop More
5 lastname varchar(200) latin1_swedish_ci No None Change Drop More
6 producttittle varchar(200) latin1_swedish_ci No None Change Drop More
7 productdescription text latin1_swedish_ci No None Change Drop More
8 swaptakeplace varchar(30) latin1_swedish_ci No None Change Drop More
9 ExchangeWithTittle varchar(200) latin1_swedish_ci No None Change Drop More
10 ExchangeWithDescription text latin1_swedish_ci No None Change Drop More
11 shippingfirstname varchar(200) latin1_swedish_ci No None Change Drop More
12 shippinglastname varchar(200) latin1_swedish_ci No None Change Drop More
13 address1 varchar(200) latin1_swedish_ci No None Change Drop More
14 address2 varchar(200) latin1_swedish_ci No None Change Drop More
15 city varchar(100) latin1_swedish_ci No None Change Drop More
16 country varchar(100) latin1_swedish_ci No None Change Drop More
17 postalcode varchar(100) latin1_swedish_ci No None Change Drop More
18 phonenumber varchar(100) latin1_swedish_ci No None Change Drop More
19 email varchar(150) latin1_swedish_ci No None Change Drop More
20 Category varchar(255) latin1_swedish_ci Yes NULL Change Drop More
21 IpAddress varchar(200) latin1_swedish_ci No None Change Drop More
22 dateadded date No None Change Drop More
The actual table
Code: Select all
# Column Type Collation Attributes Null Default Extra Action
1 id int(11) No None AUTO_INCREMENT Change Drop More
2 track_ID varchar(255) latin1_swedish_ci Yes NULL Change Drop More
3 UserName varchar(200) latin1_swedish_ci No None Change Drop More
4 firstname varchar(200) latin1_swedish_ci No None Change Drop More
5 lastname varchar(200) latin1_swedish_ci No None Change Drop More
6 producttittle varchar(200) latin1_swedish_ci No None Change Drop More
7 productdescription text latin1_swedish_ci No None Change Drop More
8 swaptakeplace varchar(30) latin1_swedish_ci No None Change Drop More
9 ExchangeWithTittle varchar(200) latin1_swedish_ci No None Change Drop More
10 ExchangeWithDescription text latin1_swedish_ci No None Change Drop More
11 shippingfirstname varchar(200) latin1_swedish_ci No None Change Drop More
12 shippinglastname varchar(200) latin1_swedish_ci No None Change Drop More
13 address1 varchar(200) latin1_swedish_ci No None Change Drop More
14 address2 varchar(200) latin1_swedish_ci No None Change Drop More
15 city varchar(100) latin1_swedish_ci No None Change Drop More
16 country varchar(100) latin1_swedish_ci No None Change Drop More
17 postalcode varchar(100) latin1_swedish_ci No None Change Drop More
18 phonenumber varchar(100) latin1_swedish_ci No None Change Drop More
19 email varchar(150) latin1_swedish_ci No None Change Drop More
20 Category varchar(255) latin1_swedish_ci Yes NULL Change Drop More
21 IpAddress varchar(200) latin1_swedish_ci No None Change Drop More
22 dateadded date No None Change Drop More
Youssef
Re: Including my sql connection
Posted: Sun Oct 02, 2011 4:36 am
by YoussefSiblini
I am using this to get the info from the temporary table and add them to the actual table:
Code: Select all
// get the information from the unpaid table
$sql = mysql_query("SELECT * FROM temporary WHERE track_ID='$track_ID' LIMIT 1");
$productCount = mysql_num_rows($sql); // count the output amount
if ($productCount > 0)
{
while($row = mysql_fetch_array($sql))
{
// get the information from notpaid table
$id = $row["id"];
$UserName = $row["UserName"];
$firstname = $row["firstname"];
$lastname = $row["lastname"];
$producttittle = $row["producttittle"];
$productdescription = $row["productdescription"];
$swaptakeplace = $row["swaptakeplace"];
$ExchangeWithTittle = $row["ExchangeWithTittle"];
$ExchangeWithDescription = $row["ExchangeWithDescription"];
$shippingfirstname = $row["shippingfirstname"];
$shippinglastname = $row["shippinglastname"];
$address1 = $row["address1"];
$address2 = $row["address2"];
$city = $row["city"];
$country = $row["country"];
$postalcode = $row["postalcode"];
$phonenumber = $row["phonenumber"];
$Category = $row["Category"];
$email = $row["email"];
$ipaddress = $row["IpAddress"];
// Add the exchange into the specified table
$addsql = mysql_query("INSERT INTO $Category (track_ID, UserName, firstname, lastname, producttittle, productdescription, swaptakeplace ,ExchangeWithTittle,ExchangeWithDescription, shippingfirstname, shippinglastname, address1, address2, city, country, postalcode, phonenumber, email, Category, IpAddress, dateadded) VALUES ('$track_ID','$UserName','$first_name','$last_name','$producttittle','$productdescription', '$swaptakeplace' ,'$ExchangeWithTittle','$ExchangeWithDescription','$shippingfirstname','$shippinglastname','$address1','$address2','$city','$country','$postalcode','$phonenumber','$email','$Category','$ipaddress',now())");
}
}