Posted by
afoster on 25 februari 2019, 17:14
#1
This is not a php-fusion issue and hope that someone can help me with this problem. I am trying to use the attached file to pull data from mysql tables without the use of maincore.php. I would like the data to be pulled into 3 columns as this file does. Any assistance would be much appreciated.
#2
I Looked at your file, but you are saying pulling data from a table without use of maincore.php, but maincore.php is included in your script, in line 13.
furthermore the name fusion_players18 is the name of the database as a constant, but is this constant declared somewhere? Not in your script. There should be something like:
define("FUSION_PLAYERS18", DB_PREFIX."players18"); or use the name as a string, so it would be "fusion_players18" with quotes
Constants are always in capitals.
Keep in mind you are making a database connection in line 8, but are also including maincore on line 13, but on maincore there is also a connection made to a database. You can only have one connection active at a moment, so after calling maincore.php, your connection in line 8 is lost.
with mysqli_select_db you can select different database on same connection. In the past I made a script to switch to another database via another connection, but that was with mysql, not mysqli. You had to force a new connection by adding a parameter True for option force new link. But mysql is deprecated now. I don't know if this works with mysqli
Hope I pointing you some directions.
btw: What exactly goes wrong with your scrip?
Posted by
afoster on 25 februari 2019, 23:37
#3
Quote
douwe_yntema schreef:
I Looked at your file, but you are saying pulling data from a table without use of maincore.php, but maincore.php is included in your script, in line 13.
furthermore the name fusion_players18 is the name of the database as a constant, but is this constant declared somewhere? Not in your script. There should be something like:
define("FUSION_PLAYERS18", DB_PREFIX."players18"); or use the name as a string, so it would be "fusion_players18" with quotes
Constants are always in capitals.
Keep in mind you are making a database connection in line 8, but are also including maincore on line 13, but on maincore there is also a connection made to a database. You can only have one connection active at a moment, so after calling maincore.php, your connection in line 8 is lost.
with mysqli_select_db you can select different database on same connection. In the past I made a script to switch to another database via another connection, but that was with mysql, not mysqli. You had to force a new connection by adding a parameter True for option force new link. But mysql is deprecated now. I don't know if this works with mysqli
Hope I pointing you some directions.
btw: What exactly goes wrong with your scrip?
I was not very clear in my post. The file I attached worked fine if I use maincore.php. It does not work however, if maincore.php is not there. What I want to do is use the file to use in a folder that is not php-fusion based, and therefore would not use maincore.php.
I will review your post to see if I can make sense of what you said, since I am not very good at php. I thank you for taking the time to respond.
Posted by
afoster on 26 februari 2019, 16:17
#6
Thanks for your help on this and the file you attached. Unfortunately it only pulls the user name in the table and only in the first column. I am attaching a screen shot of a portion of the page to give you an idea of what I am describing.
I also noticed that the link you send from w3schools.com is for php7, my host is running 5.63 which is probably the reason your file is not working properly.
Edited by
afoster on 26 februari 2019, 16:26
#7
I am sorry, there was a typo in the file.
Like I said it was untested.
Corrected version attached
Posted by
afoster on 26 februari 2019, 18:22
#8
Works perfectly, thank you so much. I will now adapt the file to work in a folder that is in no way related to php-fusion. I have a good feeling that it will work.