-
Posts
24,484 -
Joined
-
Last visited
-
Days Won
866
Everything posted by Krydos
-
The php I posted above was the expansion of the psuedocode that you didn't understand What is your sql query?
-
It's just psuedocode. <?php // however you get your username variable $username = "maicol07"; // load database values require 'config.php'; // connect to database $con = new mysqli($db_host, $db_user, $db_pass, $db_data); if ($conn->connect_error) die("Connection failed: ".$conn->connect_error); // perform query $sql = "show tables like $username_"; $result_tables = $con->query($sql); // start dropdown select echo "<select>"; // for each table in database while ($row_tables = $result_tables->fetch_assoc()) { // store the name of the table we're working with $table = $row_tables["Tables_in_$db_data"]; // perform query $sql = "select data from $table"; $result_data = $con->query($sql); // for each value in the column data while ($row_data = $result_data->fetch_assoc()) { // store the value of this row of data $data = $row_data['data']; // create a dropdown entry echo "<option value='$data'>$data</option>"; } } echo "</select>"; This code is untested.
-
You could do queries in a while loop. show tables while (another table) { select * from table }
-
Well, the show command only loads the tables that start with the username, and then the select tags display the names of the tables which start with the username_ bit. Maybe I'm not understanding what you're trying to do?
-
Closing due to inactivity.
-
Yes, the invite for that transaction ID was sent.
-
There you go http://olsenalways.win/test.aspx
-
[Solved] Postgres Db Seems To Be Down Johnny Server
Krydos replied to bobspar's topic in Escalated Requests
It's working again. -
Please post the following information: Your cPanel usernameYour main domain
-
The config.php is a common way to separate the $db_host, $db_user, $db_pass, and $db_data variables from the code. If you have 15 different php files they can all include config.php to load those database variables, and if you change the password for example you only have to change it in one place. It's good programming practice to do stuff like this. In this case the config.php would look like: <?php $db_host = "localhost"; $db_user = "maicol07_user"; $db_pass = "bestpaswordever"; $db_data = "maicol07_db"; Change line 11 to $sql = "show tables like '$username_%";
-
How To Set Index.py/.cgi As Default Index
Krydos replied to poeka's topic in Website Management and Coding
Installed. -
We already have mod_deflate installed which does the same thing, but works for all file types not just php files. Put something like this in your .htaccess to enable it <IfModule mod_deflate.c> AddOutputFilterByType DEFLATE text/text text/html text/plain text/xml text/css application/x-javascript application/javascript </IfModule> You can test your pages to see if it's enabled properly by using a tool like this http://www.whatsmyip.org/http-compression-test/
-
It takes a few hours for the email address change to go through sometimes.
-
PHP files need to be permissions 644. You phpinfo.php file was 664. There you go http://wardracs.heliohost.org/phpinfo.php
-
How To Set Index.py/.cgi As Default Index
Krydos replied to poeka's topic in Website Management and Coding
Yeah, we can install python modules for you. Just let us know: Module name (webob)Python version you're usingServer that you're on -
Not really. You can install ruby gems yourself through cpanel. If you need a particular version of python or some module installed let us know. The idea behind requesting java and requesting mono is it takes a lot of server resources for each account that those are enabled on so we want only the people who actually need it to have it active.
-
It should work on 5.6. Are you sure you aren't using 5.5 or something else? Ah, figured it out. The error isn't our server at all: Source: https://stackoverflow.com/questions/11680709/file-get-contents-give-me-403-forbidden That particular website has some protection against people using file_get_contents on it. If you use curl with good headers you can get the data from them without them knowing it's not a real browser. That wouldn't stop them from figuring out that the requests are coming from a server not a real persons IP address and if they're really zealous about not having their data scraped they could always block our IP...
-
[Solved] Call To Undefined Function Mysqli_Connect()
Krydos replied to deep958's topic in Escalated Requests
Yes, mysqli is functional on Tommy. -
[Solved] Call To Undefined Function Mysqli_Connect()
Krydos replied to deep958's topic in Escalated Requests
This might help. https://stackoverflow.com/questions/1390607/how-could-i-change-this-mysql-to-mysqli -
Yes, you can select a single IP to allow access from or you can allow access from all IPs. Enabled.
-
Which version of php are you using? That's because you hadn't requested aspx access yet. There you go http://meraj.gq/test.aspx
-
Can't Access My Website (Mysqli Is Disabled?)
Krydos replied to sosmed96's topic in Customer Service
Source: https://www.helionet.org/index/topic/28813-johnny-backlog/ As the news says we recommend switching to mysql instead of mysqli temporarily or switching to Tommy where mysqli is working. -
How To Set Index.py/.cgi As Default Index
Krydos replied to poeka's topic in Website Management and Coding
You've actually got all the permissions correct and files created properly and everything. Very impressive! The 500 error is because the python module webob isn't installed. www is actually a symlink to public_html, and symlinks always have 777 permissions.