ow-design Posted December 29, 2007 Share Posted December 29, 2007 Hi Everyone, i am still learning PHP and am roughly thinking out a redesign of an exisiting recruitment website, it can be roughly be seen on my site at ow-design.co.uk/clients/martin/opportunities.php What i need is someone to tell me or give me some code so i can search a MYSQL table called 'opportunities' with the following rows; ID, Title, Added, Category, Area I need a form where users can search for a job by entering a keyword and then after submitting it a results page shows the job with the title linked to the description page. Is this possible, also is it possible for a user to search for a job by entering a keyword and also by using a specific category?? I need urgent help on this thanks!.! Link to comment https://forums.phpfreaks.com/topic/83640-php-search-help/ Share on other sites More sharing options...
ow-design Posted December 29, 2007 Author Share Posted December 29, 2007 Please Someone Help ! Link to comment https://forums.phpfreaks.com/topic/83640-php-search-help/#findComment-425501 Share on other sites More sharing options...
tibberous Posted December 29, 2007 Share Posted December 29, 2007 This isn't remotely urgent. Urgent is like, I'm on the front page of digg and my CMS is dead - this is just an update you are thinking about doing... Link to comment https://forums.phpfreaks.com/topic/83640-php-search-help/#findComment-425507 Share on other sites More sharing options...
AndyB Posted December 29, 2007 Share Posted December 29, 2007 The place for urgent help is posting in the Freelancing forum AND offering something tangible in return (otherwise, whay would anyone give up their time?) Link to comment https://forums.phpfreaks.com/topic/83640-php-search-help/#findComment-425512 Share on other sites More sharing options...
ow-design Posted December 29, 2007 Author Share Posted December 29, 2007 No its an update i have to put in place to show my client tomorrow evening... So its urgent to me. Link to comment https://forums.phpfreaks.com/topic/83640-php-search-help/#findComment-425520 Share on other sites More sharing options...
AndyB Posted December 29, 2007 Share Posted December 29, 2007 No its an update i have to put in place to show my client tomorrow evening... So its urgent to me. Right. But it isn't urgent for people reading your post. Your problem is your problem, not ours. Link to comment https://forums.phpfreaks.com/topic/83640-php-search-help/#findComment-425524 Share on other sites More sharing options...
ow-design Posted December 29, 2007 Author Share Posted December 29, 2007 I dont really understand your point... I am on this site asking for help which is the point of this site being here... As i said its urgent to me... of course its not urgent to you. And if you think that it is "Your Problem" then perhaps you should read the description of this site... "PHP Support". .. Again if anyone can help me that would be great. Link to comment https://forums.phpfreaks.com/topic/83640-php-search-help/#findComment-425525 Share on other sites More sharing options...
tibberous Posted December 29, 2007 Share Posted December 29, 2007 Just you can't really be pushy when asking for free help - I mean, you can be, but you generally don't want to be. Link to comment https://forums.phpfreaks.com/topic/83640-php-search-help/#findComment-425546 Share on other sites More sharing options...
teng84 Posted December 29, 2007 Share Posted December 29, 2007 mods should removed this thread here instead of replying this way.. this should be locked Link to comment https://forums.phpfreaks.com/topic/83640-php-search-help/#findComment-425553 Share on other sites More sharing options...
tibberous Posted December 29, 2007 Share Posted December 29, 2007 Maybe, but it could just be remade without the URGENT in all caps after it. It's a stupid, simple question, asked rudely, but that doesn't really make it lockable. Link to comment https://forums.phpfreaks.com/topic/83640-php-search-help/#findComment-425557 Share on other sites More sharing options...
teng84 Posted December 29, 2007 Share Posted December 29, 2007 Maybe, but it could just be remade without the URGENT in all caps after it. It's a stupid, simple question, asked rudely, but that doesn't really make it lockable. when you need someone to do all the codes for you this should be in freelance.. even if you removed urgent how can you help people this way ? create a code for them.. or teach them one by one i dont think i will ! any way sorry for being rude just got out of bed .. sleeping again ! Link to comment https://forums.phpfreaks.com/topic/83640-php-search-help/#findComment-425560 Share on other sites More sharing options...
PHP_PhREEEk Posted December 30, 2007 Share Posted December 30, 2007 Your client is paying YOU to script the thing, and you come here for FREE scripting. Nice. You see, support != free scripting Support is where you have TRIED and hit a dead-end, and you need a jumpstart back on the road to a working solution. If your client is paying YOU (and that's the definition of a 'client'), then you should post on the freelance board and 'share' the wealth a bit. PhREEEk Link to comment https://forums.phpfreaks.com/topic/83640-php-search-help/#findComment-425564 Share on other sites More sharing options...
redarrow Posted December 30, 2007 Share Posted December 30, 2007 If you was polite from the begining i would off helped you, but as your such in a hurry and not in a hurry to press my paypal button your need to use google sorry m8... Link to comment https://forums.phpfreaks.com/topic/83640-php-search-help/#findComment-425568 Share on other sites More sharing options...
simcoweb Posted December 30, 2007 Share Posted December 30, 2007 Have you tried to code this yourself yet? If so, post your code. That's the normal start here. Otherwise they might as well rename the site 'Request A PHP Script.com'. Get the idea? We're all willing to help. But not willing to produce 100% of what you need. Link to comment https://forums.phpfreaks.com/topic/83640-php-search-help/#findComment-425572 Share on other sites More sharing options...
PHP_PhREEEk Posted December 30, 2007 Share Posted December 30, 2007 This is an ongoing issue with this guy... he started doing this back in February when he signed up. For example, this thread from Feb. Post titled Urgently need help!! PHP Link Hi Everyone, hope you can help me! I am 16 yrs old and design websites for companies. I have a problem with a database i am doing for a recruitment company site. you can view the non-ready one here... www.ow-design.co.uk/clients/martin_pooley/jobs.php... ... snip ... then, same post thread: I was taking a lot of info from the code and trying to adjust it, i am not great at php... yet Would you write me the code please for my jobs page & jobdetails page?? Apparently he's quite used to getting us to write code for him to charge his 'client' for... nice gig if you can get it... PhREEEk Link to comment https://forums.phpfreaks.com/topic/83640-php-search-help/#findComment-425576 Share on other sites More sharing options...
redarrow Posted December 30, 2007 Share Posted December 30, 2007 I thort oh no we got a real exspert in web design, then i looked at everythink he offers, then by suprise he used templates lol, oh no i left in disipointment.... ps... sorry m8 please read like the rest of us cheers.... Link to comment https://forums.phpfreaks.com/topic/83640-php-search-help/#findComment-425586 Share on other sites More sharing options...
ow-design Posted December 30, 2007 Author Share Posted December 30, 2007 Wow You people are all so helpful. and i think you will find im not charging my client as he is a neighbour of mine. i just needed some friendly advice of the best way to go about this... Im sure none of you ever needed help and PHP happened to come naturally to you. Link to comment https://forums.phpfreaks.com/topic/83640-php-search-help/#findComment-425626 Share on other sites More sharing options...
ow-design Posted December 30, 2007 Author Share Posted December 30, 2007 I thort oh no we got a real exspert in web design, then i looked at everythink he offers, then by suprise he used templates lol, oh no i left in disipointment.... ps... sorry mate please read like the rest of us cheers.... What Templates please explain?? Link to comment https://forums.phpfreaks.com/topic/83640-php-search-help/#findComment-425630 Share on other sites More sharing options...
teng84 Posted December 30, 2007 Share Posted December 30, 2007 maybe a CMS !.. and your problem i think you can find that in this forum just search it and sure youll finds tons of it Link to comment https://forums.phpfreaks.com/topic/83640-php-search-help/#findComment-425632 Share on other sites More sharing options...
ow-design Posted December 30, 2007 Author Share Posted December 30, 2007 Okay, the one i used for Joomla, for another non-paid community website. Right. Link to comment https://forums.phpfreaks.com/topic/83640-php-search-help/#findComment-425640 Share on other sites More sharing options...
AndyB Posted December 30, 2007 Share Posted December 30, 2007 Wow You people are all so helpful. Just to remind you, you're then one who came flying in here virtually demanding help ... except you don't actually want help, you seem to expect someone to provide sample code/code flow to solve a problem that you have an urgent need to solve. So far, you haven't even offered any code of your own - and we're always willing to help you with that. This isn't an "I want some code now, so let's have it" type of forum - except where payment is available and you post in the freelancing section. That's what it's for. If you want help, be nice about it. Show what efforts you've made. Im sure none of you ever needed help and PHP happened to come naturally to you. Not quite. But plenty of us have tried a little google searching before crashing in here with virtual demands for help. Go read a few of the tutorials on www.tizag.com to get your coding started. If you have a problem with your code, come on back and you'll get help. We all started somewhere, and mostly that was by doing not demanding. Link to comment https://forums.phpfreaks.com/topic/83640-php-search-help/#findComment-425671 Share on other sites More sharing options...
ow-design Posted December 30, 2007 Author Share Posted December 30, 2007 Okay the basic code i have so far is: <?php $link = mysql_connect('localhost', 'myusername', 'mypassword') or die(mysql_error()); mysql_select_db('opportunities'); $category = mysql_real_escape_string ($_POST['category']); $q="select * from opportunities where title like \'%$title%\' or category like \'%$category%\'"; mysql_query($q); ?> <form method="POST" action="search1.php"> <p><input type="text" name="title" size="22"></p> <p><select size="1" name="category"> <option>solicitor</option> <option>lawyer</option> <option>builder</option> </select><input type="submit" value="Submit" name="B1"></p> </form> When a user submits the form i want to be able to get info from the database where titles match 'keywords' entered in the title field. Is the above code right for this and how do i then display the results.? Thanks. Link to comment https://forums.phpfreaks.com/topic/83640-php-search-help/#findComment-426079 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.