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 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.