Volunteers??

BandWitch

Is there any volunteers who can help me make a host search script??

Thanks

drawmack

95% of the functions for that script can be found in the manual already written for you all you have to do is put them together.

TheDefender

No disrespect BandWitch, but as I have watched you through your various posts here, you have done nothing to help yourself. We have all tried to point you in the direction for help, and you just keep starting new threads asking for others to do the work for you... Given what you know about PHP and MySQL, this is no exception.

You are trying to run before you learn how to walk or even crawl... How about you try writing some scripts to print "Hello World", then work your way through arrays and DB connectivity to build a fully functional data-driven website.

I know it sounds silly, but if you are diligent about it, you can learn it failry quickly. The bottom line is that there is nobody who is going to "volunteer" their time for free to build you a website that you can have done in a couple of weeks with diligence.

BandWitch

:bemused: :queasy:
ok,
just give me a link with a script i can modify! That's the only thing i need! Please help me

smoothcriminal

Hotscripts provde many thousands of free scripts, its up to you to find what you want.

BandWitch

i know hostcripts but i need a spesific script to modify and make a host search script?
any urls?

TheDefender

Listen, we have told you this time and time again... YOU HAVE TO MODIFY ONE OF THE SCRIPTS. Only YOU are the one who knows what YOU want, so go there, and look at them all, and find one that is close to what you want, and modify it.

Heck, go find a good book to read, and read it, because what it sounds like is you are going to be doing BASIC INSERT, UPDATE, SELECT and DELETE MySQL commands anyhow, and EVERY book out there goes over those basics.

Also, try reading the PHP and MySQL manuals (again, like we've told you), because they also have all of the BASIC info you want.

I will bet you a million bucks you haven't even storyboarded your idea yet, so how in the heck can you possibly know what script to choose from (or better yet) since you haven't provided US a storyboard, how in the heck can WE possibly point you to a script either?

YOU have to actually do some work for this. Like I said before, you are going to be hard pressed to find anyone to write you a script for FREE...

planetsim

Have you even tried any of the scripts from hotscripts? an explaination from the people that upload bit doesnt always explain what features are in the script and most of the time the older ones are quite good but are not always supported..

TheDefender is right too you wont find anyone really these days that will produce a good job (of course that leaves the people new wanting to get there feet wet to give it ago for free).

TheDefender

OK, in the spirit of at least getting you started, here is a little something. Keep these points in mind:

There is NO ERROR CHECKING
There are a hundred ways to accomplish what you want to do, and this is just a sample.
There is no guarantee this will work (and it probably won't) for your particular needs.
I am providing absolutely NO support or help with this code. It is only to give a brief demo of what you seek.
This was only written to show you how you can get started.

To the REGS... No code critique here please. I know of the problems with this code.
[/list=1]

Like I said before, you gotta crawl before you can walk or run, so go learn PHP and MySQL before you even consider modifying anything. Your lack of knowledge shows through to the fact that you don't think a script exists that can be modified. Someone with some PHP and MySQL knowledge would recognize a modifiable script and be able to pick it apart to suit their needs. Heck, someone like WeedPacket or LaserLight could take a counter script and modify it to do what you want, so don't think it can't be done.

Table 1 [hosts]
host_id Primary, Auto Increment INT(11)
host_name VARCHAR(30)
host_url VARCHAR(255)

Table 2 [packages]
package_id Primary, Auto Increment INT(11)
host_id INT(11)
package_name VARCHAR(20)
package_cost INT(5)
package_features TEXT

Your Form to find things (search.php)

<form action="searchhosts.php" method="POST">
<SELECT name="lowend">
<option value="5">5</option>
<option value="10">10</option>
<option value="10">15</option>
<option value="10">20</option>
</SELECT>

<SELECT name="highend">
<option value="5">25</option>
<option value="10">30</option>
<option value="10">35</option>
<option value="10">40</option>
</SELECT>

PHP<input TYPE="checkbox" NAME="feature1" VALUE="PHP" checked>
MySQL<input TYPE="checkbox" NAME="feature2" VALUE="MySQL" checked>
Unlimited Pop 3 Email<input TYPE="checkbox" NAME="UnlimitedPop3" VALUE="Yes" checked>

<input type="submit" value="Find It"><input type="reset" value="Start Over">
</form>

Your page to display results (searchhosts.php)

<?php

$lowend = $_POST['lowend'];
$highend = $_POST['highend'];
$features = $_POST['feature1'].", ".$_POST['feature2'].", ".$_POST['feature3'];

// Create your connection to your DB
$connect = mysql_pconnect($db_host, $db_user, $db_pass) or die("Could not connect: ".mysql_error());
mysql_select_db($db_name, $connect) or die('Unusable database: '.mysql_error());

// Create your SQL statement
$sql = "SELECT * FROM hosts AS h,packages AS p";
IF(isset($lowend) && (isset($highend))) $sql .= " WHERE p.package_cost BETWEEN '".$lowend."' AND '".$highend."'";
IF(isset($features)) $sql .= " AND p.package_features LIKE '".$features."'";
$sql .= " AND h.host_id = p.host_id";
$sql .= " ORDER BY p.package_cost ASC";

// Execute the query
$getqry = mysql_query($sql);

// Display the results if one or more were found.  If not, echo message to let the user know no results were found.
IF(mysql_num_rows($getqry) >= 1){
	WHILE($gotqry = mysql_fetch_array($getqry)) {
		echo "<a href=\"".$gotqry['host_url']."\" target=\"_blank\">".$gotqry['host_name']."</a> ".$gotqry['package_name']." ".$gotqry['package_cost']." ".$gotqry['package_features']."<BR />";	
	}
} ELSE {
	echo "No Results were found to match your search criteria.";
}

?>

LordShryku

Defender, you're nicer than I am.

BandWitch, we're not your personal Google. Do the research yourself. If you have a question pertaining to the code, post it. Otherwise, don't expect us to do anything for you.

TheDefender

LOL LordShryku... There are a few factors going into my thought process...

1) BandWitch has now started about 4 threads asking the exact same thing, and each time, given the same information, and has not answered the clue phone any time.
2) I know this code needs a lot of work to actually be functional.
3) I figured BandWitch would get the point we've been trying to make every time, when trying to implement my code that it doesn't matter what the code is or does, if it's prewritten, it ALWAYS needs mods to even work or do what he/she wants it to do anyhow.
4) I also figure BandWitch might even learn enough of a lesson by this to not come back posting the same thing over and over again without following the guidance of some of the more experienced coders.

Oh, BandWitch, Lord is also one of those SuperCoders who can take the counter script and turn it into a Web Host search script too.... (Sorry I left you out before Lord 😉)

LordShryku

It's ok Defender. After this long around here, I hope it goes without saying 😉

But it doesn't take a SuperCoder to do this. Just someone who's not lazy. This is one of my pet peeves around here. I don't go to the store, walk into the cereal aisle, then pull some random shopper away and say "Can you go get me a box of Lucky Charms?".

tekky

Originally posted by LordShryku
.....I don't go to the store, walk into the cereal aisle, then pull some random shopper away and say "Can you go get me a box of Lucky Charms?".

Hah! Of course not! Thats absurd...
That's what the managers are for!!! :evilgrin:

TheDefender

I don't go to the store, walk into the cereal aisle, then pull some random shopper away and say "Can you go get me a box of Lucky Charms?".

Hmmmm... {pulling out notebook} Jotted down: # 104 of the list of things to try before I die...

Uh, Lord, please clarify, do I need to be within 10 feet of said cereal before I make this request, just to add to the absurdity? LOL

LordShryku

Be glad you have the safety of the internet here. Try that, and you'd probably be told to f*ck off. Persist, like someone here does(I won't mention names), and you'd probably get hurt :p

TheDefender

I'm going shopping this afternoon. I think I will test this theory, first on my wife, and if all goes well, I will try it out on a store staff member first, and then a fellow shopper... 3 Weeks worth of testing... I will let you all know how it goes... LOL.

BuzzLY

For a proper test, do the following:

Enter the store, and ask the nearest person where the cereal is.

If they say, "in the cereal aisle," ask where it is. If they tell you the aisle number, ask if you have to count the aisles, or if they are pre-numbered.

Move on to the next person. Ask the same questions, only this time, when they tell you the aisle number, ask them to take you there.

After everyone tells you to f##k off, you'll eventually find someone to walk you to the aisle. When they do, immediately sit down in one of those wheelchair carts and ask them to push you to the aisle.

When you get to the aisle, you must of course ask the person to get a box of cereal down, and you must start reading the box. Then, when you are done, hand it back, saying "that won't work," and ask for the next cereal box. Keep this up until he/she throws the box at your head.

Continue with the next person willing to help you. Be patient, as this will take some time.

Once you have found the cereal you need, see if you can get the person to follow you home and pour your cereal for you. As an added bonus, see if they will feed you.

Assuming you make it this far, immediately spit it out in disgust, and exclaim "that tastes like s##t!", and start the process over by going back to the store.

TheDefender

Well, I think I am going to have to skip all of that BuzzLy... The test with my wife was a huge success (which of course means it didn't go well 😉) I asked her to reach the Cheerios on the top shelf (which of course she couldn't, since she is several inches shorter than I am), and her response was a curt "Get the d%&n Cheerios yourself, or settle for these Kix on the bottom shelf..."

Well, needless to say, I am not a huge fan of Kix, so we didn't get cereal at all... I guess I am going to have to settle on the remaining Cocoa Puffs (4 in a bowl for a week) until we go shopping again.

The funny thing is she never asked me why I wanted her to get them for me... Ahhhh, isn't 10 years of marriage bliss, well...... blissful? LOL

Drakla

I'm in London at the moment, so I can do the Ebineezer approach and just shout out of the window "You there... boyyyy... do they still have the prize big packet of Weetabix up at the corner shop - the one with the Spiderman toy inside?"

"Yes sir, I think so."

"Well go and get it BOY - quick quick!"

Lord - you must have been around this place for ages, and I always wonder, has anybody yet said "The Taming of the Shryku" to you? I must have happened, no?

LordShryku

August 2002's when I joined. And no, no ones's said that.

Yet....