Page 2 - Good free php host

ASP Free Forums Sponsor:

#16

January 3rd, 2006, 10:23 AM

baseballdude_

Expert Learner

ASP Free Intermediate (1500 - 1999 posts)

Join Date: Feb 2005

Location: Wisconsin

Posts: 1,891

Folding Points: 22104 Folding Title: Starter Folder

Time spent in forums: 1 Week 5 Days 13 h 46 m 3 sec
Reputation Power: 70

Send a message via Yahoo to baseballdude_

Send a message via Google Talk to baseballdude_

While I understand and agree that it is nice to have it all at your immediate access, I also feel that the help you receive from a webhost (free or not) is valuable for a beginner. I feel the transition from using a host to hosting your own should be easier than jumping right into it.

As for some of your statements, I really don't agree.

FTP is just as fast as saving on your own machine.
Host interfaces are not "annoying."

__________________
www.xoise.com - www.ourfreegames.com - www.g1games.com - www.randomtools.net - www.xenocide-rpg.com - Lyrics Search Engine

#17

January 3rd, 2006, 11:33 AM

RadioactiveFrog

Senior Glowing Wizard

ASP Free God 7th Plane (8000 - 8499 posts)

Join Date: May 2005

Location: Sussex

Posts: 8,223

Folding Points: 160711 Folding Title: Super Ultimate Folder - Level 1

Time spent in forums: 3 Weeks 4 Days 3 h 46 m 30 sec
Reputation Power: 326

Send a message via MSN to RadioactiveFrog

Quote:

Originally Posted by oneMSBi

you cannot tweak the php ini on a live host now can you ? for example i recently had to write a couple of php apps that interfaced with a set of embedded systems over tcp/ip. I doubt you could find a live host with the sockets extension (on windows or its linux equivilent) enabled.

Secondly, you have much much less control over gloabl configuration parameters, and since the administration of the system is not in your direct control you cannot test your scripts out to the full extent. I often run load tests using massive client request loops form another machine. Checking for data leaks in the mysql part of my php code.

then there is the issue of access. On your own machine you have total control of all your files and can edit and maintain them with the greatest ease. No slow ftp, no irritating host interfaces or ssh.

Just edit the file and hit refresh on your browser. When you make a tweak to the php configuration, just restart apache and your good to go.

As for learning the control panel of a free/not free host.. well two thigns wrong with that as a plus point. You assume that is the only host you will use.. and in most enterprise scenarios, there is no control panel for developers.

Besides the best way to check and develop a mysql or any other database app with php is when you have direct access to the db so that you can experiment with your query's etc...

but i'm rambling.. this is my view..

i think this may never end, there are pros and cons for both. But as for editing the php ini, it is good to know how to do that, agreed, but most sites people develop will be on hosts where they can't do that !!

As for learning the control panel and staying with that host...most linux hosts use cPanel! And if not that then i believe it is plesk the second most common!!

__________________

#18

January 6th, 2006, 10:46 AM

Black&White

Play up Pompey!

Join Date: Feb 2005

Location: Hampshire, ENG

Posts: 1,100

Folding Points: 9032 Folding Title: Novice Folder

Time spent in forums: 1 Week 1 Day 22 h 26 m 43 sec
Reputation Power: 62

Thanks for all the comments guys, like I said before I'll look at it in more detail in a week or two. I'd rep you all but the new years rep fest has probaly stopped that

__________________
Matt

Folding At Home - fold to cure!

#19

January 6th, 2006, 12:15 PM

RadioactiveFrog

Senior Glowing Wizard

Join Date: May 2005

Location: Sussex

Posts: 8,223

Time spent in forums: 3 Weeks 4 Days 3 h 46 m 30 sec
Reputation Power: 326

Quote:

Originally Posted by Black&White

Thanks for all the comments guys, like I said before I'll look at it in more detail in a week or two. I'd rep you all but the new years rep fest has probaly stopped that

Let us know if you have any more questions when you get round do looking into it more !!

#20

January 17th, 2006, 03:21 PM

Black&White

Play up Pompey!

Join Date: Feb 2005

Location: Hampshire, ENG

Posts: 1,100

Time spent in forums: 1 Week 1 Day 22 h 26 m 43 sec
Reputation Power: 62

Quote:

Originally Posted by RadioactiveFrog

Let us know if you have any more questions when you get round do looking into it more !!

Time for the questions to start as I've started to look at learning php.

I opted to go for free hosting at xr4free which isn't brilliant, had down time yesterday but it'll do if I'm only spending 30 minutes twice a week on this for now.

I have a problem with this code, well just a general programming problem. If $i is already used in the while statement, then how can I get data from another table like the stuff commented out.

What I'm trying to do in the code is loop through taking data from one database table, whilst extracting further data from another table based on the results from the first table. (the code can explain it better than I can)

Please point out if I'm using completely the wrong technique for anything/everything, this is just adapted from examples on the net. I'm a php n00b so feel free to treat me like one

php Code:

Original - php Code

 
<?
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM fmaresult";
$result=mysql_query($query);
 
$num=mysql_numrows($result);
mysql_close();
 
if ($num > 0) {
?>
<table width="500px">
  <tr>
    <th width="30%" align="center">Time</th>
    <th width="70%" align="center">Result</th>
  </tr>
<?
$i=0;
while ($i < $num) {
 
$id=mysql_result($result,$i,"id");
$home=mysql_result($result,$i,"home");
$away=mysql_result($result,$i,"away");
$hgoals=mysql_result($result,$i,"hgoals");
$agoals=mysql_result($result,$i,"agoals");
$generated=mysql_result($result,$i,"generated");
 
//$query = "SELECT * FROM fma where (id = $home)";
//$result = mysql_query($query);
//$hname = mysql_result($result,$i,"name");
 
//$query = "SELECT * FROM fma where (id = $away)";
//$result = mysql_query($query);
//$aname = mysql_result($result,$i,"name");
 
if( $odd = $i%2 )
{
    $class = "style2";
}
else
{
    $class = "general";
}
 
?>
  <tr class="<? echo $class ?>">
    <td width="30%" align="center"><? echo $generated ?></td>
    <td width="70%" align="center"><? echo $hname . " " . $hgoals . " - " . $agoals . " " . $aname ?></td>
  </tr>
<?
$i++;
}
?>
</table>
<?
}
?>

#21

January 17th, 2006, 04:55 PM

RadioactiveFrog

Senior Glowing Wizard

Join Date: May 2005

Location: Sussex

Posts: 8,223

Time spent in forums: 3 Weeks 4 Days 3 h 46 m 30 sec
Reputation Power: 326

ok, a different way of coding i have to say but still

the commented out bits, a quick glance would suggest that you should use something other than $query and $result as they have already been used

Other than that you don't give any errors so i don't know what i am looking for.

to be honest i wouldn't go about it this way. General code for getting info from two dbs ...

there are two ways, you can use two query's a bit like you are or you can use a join statement! I will try to explain the first as i think that is easier to understand for beginners.

php Code:

Original - php Code

 
//query one
$get_customers = mysql_query("SELECT * FROM customer_table") or die(mysql_error());
if(mysql_num_rows($get_customers) > 0)
{
//print table headers
 
while($row = mysql_fetch_object($get_customers))
{
//you can print any info from the first query using print $row->field_name;
 
//you can query another db using something like
$get_cust_address = mysql_query("SELECT * FROM customer_addresses WHERE cust_id = ".$row->cust_id."") or die(mysql_error());
$address_row = @mysql_fetch_object($get_cust_address);
 
//then you can print anything from that query using  print $address_row->house_name;
}
}

Hopefully all that kinda helps, if you need anything explained let me know. More than happy to help. Might be better to post it in a different thread tho so post it there and PM me!!

Loadsa ppl helped me out when i was learning PHP so i am happy to return the favour!!

Comments on this post

Black&White agrees: thank you