Hi everyone. I have made a multiple page form in php using a mysql database, one table to take data for an <option> drop down menu and another table from the same db to save the data entered in the form (the second table is created if it doesn't exist). It also sends an email with the data on it through PEAR's Mail.php. I have another php script that reads the data entered in this second table and has a search function. Every connection to the mysql server is done through a connect.inc.php file, in order to detect errors easily.
Locally, everything works perfectly, I have installed an Appsrv, with all the default settings. I imported the database i had locally to the x10hosting server, uploaded all php files and tryed it out. The drop down menu is displayed correctly, so there is no connection error (remember every connection is done the same way through a connection function).
Once i submit the form, everything seems to be working fine, no errors are thrown (neither by for the email sent, nor for the db entry saved), nontheless, nothing is done properly. The user for the db has all the privileges, so that shouldn't be an issue (it's the only user i have, and the only db). I tryed deleting the second table, so the script could create a new one, but it doesn't do that either. Locally, if i do something wrong when sending the email, i get an error (say, putting a different password), here, nothing's shown. The only error i get from mysql, is when i try and force a wrong user/pass, so there it outputs an error, else, nothing's shown
When viewing the data in the second database, it show it all, but it's not capable of searching (it shows everything as a result of the search, it worked correctly locally of course). I use this code to search:
I saw on other threads Pear isn't installed by default, how can i do that? the only require_once file is "Mail.php". The email not being sent is a class b problem, the main issue is I cannot insert into a table, create a new one, or search among one.. the only change i made from the local version is the user, password, db for the connection file. (the structure is the same locally and on the server for the db and tables)
To wrap this whole thing up
- Can't create a new table
- Can't insert into an existing table
- Can't search among a table
- No errors
- I can't send emails from pear (maybe not installed, not a main issue so far anyway..)
I don't know what else to try.. If anyone can help me, i would really apreciate it.. If you'd need any code (maybe things are not clear without it) i'll put it here too
Locally, everything works perfectly, I have installed an Appsrv, with all the default settings. I imported the database i had locally to the x10hosting server, uploaded all php files and tryed it out. The drop down menu is displayed correctly, so there is no connection error (remember every connection is done the same way through a connection function).
Once i submit the form, everything seems to be working fine, no errors are thrown (neither by for the email sent, nor for the db entry saved), nontheless, nothing is done properly. The user for the db has all the privileges, so that shouldn't be an issue (it's the only user i have, and the only db). I tryed deleting the second table, so the script could create a new one, but it doesn't do that either. Locally, if i do something wrong when sending the email, i get an error (say, putting a different password), here, nothing's shown. The only error i get from mysql, is when i try and force a wrong user/pass, so there it outputs an error, else, nothing's shown
When viewing the data in the second database, it show it all, but it's not capable of searching (it shows everything as a result of the search, it worked correctly locally of course). I use this code to search:
Code:
SELECT Name, id, MATCH (Name, id) AGAINST ('$frase' IN BOOLEAN MODE) AS coincidences
FROM $table WHERE MATCH (Name, id) AGAINST ('$frase' IN BOOLEAN MODE) ORDER BY Name $order LIMIT $start, 10000"To wrap this whole thing up
- Can't create a new table
- Can't insert into an existing table
- Can't search among a table
- No errors
- I can't send emails from pear (maybe not installed, not a main issue so far anyway..)
I don't know what else to try.. If anyone can help me, i would really apreciate it.. If you'd need any code (maybe things are not clear without it) i'll put it here too