Searching MySQL with PHP -


I am doing a project where I want to enter an artist / band name in a text box Where it will be open my MySQL database for event information and display the results / content on the second page. The code below is within my index.php where it should get information from the search.ffp (also below). I have seen it completely and I am not sure why this is not working and I can not understand what to do. Help would be great! (I really need to pass this class!) :)

(index.php) 

  & lt; Form Name = "Search" action = "Search Php" method = "Received" & gt; & Lt; Div align = "center" & gt; & Lt; Input type = "article" name = "q" /> & Lt; P & gt; & Lt; Input type = "submit" name = "submit" value = "search" /> & Lt; / P & gt; & Lt; / Form & gt;

(search.php) 

  & lt ;? Get the search variable from Php // URL $ var = @ & amp; _GET ['q']; $ Trimmings = trim ($ var); // Exclude spaces from spaces / lines // spaces to return $ range = 10; // Check for blank string and display the message. If ($ trimmed == "") {resonant "
 please enter a name. & Lt; / p & gt;"; Go out; } // Check for a search parameter if (! Isset ($ var)) {resonant "& lt; p> We do not find the search parameter! "; Go out; } // database connect to mysql_connect ("localhost", "root", "password"); // Specify mysql_select_db database ("Itor") or die ("Unable to select database"); // Create a SQL query $ query = "Select from events * where artist_name like \"% trimmed% \ "sorted by date"; $ Numresults = mysql_query ($ query); $ Numrows = mysql_num_rows (numresults); // If there are no results, offer a Google search as an option ($ numrows == 0) {resonance "
 result "; Echo "& lt; p & gt; sorry, your search: & amp; quot;" $ Trimmed "& Amp; quot; Returned zero results & lt; / p & gt;"; // google echo "& lt; p & gt; & lt; a href =" http://www.google.com/search?q= "$ trimmed." \ "Target = \" _ blank \ "title = \" look-up \ "$ trimmed." To do a Google search, click on \ "& gt; here & lt; / a & gt; & lt; / p & gt;"; } // Next Setting that if the script is given, if 0 is not used (empty ($ s)) {$ s = 0; } // Get the result $ query. = "Border $ s, $ limit"; $ Result = mysql_query ($ query) or die ("query can not be executed"); // What was searched for "display" & lt; P & gt; You searched: & amp; Quot; ". $ Var" & Amp; Quot; & Lt; / P & gt; "/ / results result set echo start to show" results "; $ count = 1 + $ s; // When results returned, ($ line = mysql_fetch_array ($ result)) {$ title = $ Row ["artist_name"]; echo "$ count) & amp ;. Nbsp; $ Heading "$ counts ++;} $ CurrPage = (($ s / $ limit) + 1;"  = 1) {// Bypass PREV link if S $ is $ first = ($ s- $ limit); print "& amp; nbsp; & lt; a href = \" $ PHP_SELF? S = $ prevs and q = $ var Calculate the number of pages that require \ "& gt; and amp; lt; & amp; lt; last 10

You're missing the $ symbol I think that 

  $ var = @ & amp; _GET ['q'];

probably should be 

  $ var = @ $ _GET ['q'];

Unless you really want a reference, in that case it should be: (If you If you want a reference, then this need is not required, but you should check $ var before trying to access it) 

  $ var = & amp; $ _GET ['Q '];

I It'll do little to write more. 

  if (! Isset ($ _ GET [ 'q'])) {echo "& Lt; P & gt; We do not find the search parameters! & Lt; / P & gt; "; go out;} $ Trimmed = trim ($ _GET ['q']); if ($ trimmed ==" ") {resonant" & lt; P & gt; Please enter a name. & Lt; / P & gt; "; go out;}

Comments

Post a Comment

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

I'm having trouble overriding a ModelForm save method. I get this error I'm: Exception type: TypeErier Exception Value: Save () found an unexpected keyword argument 'committed' My intentions include a form 3 fields Submit several values ​​for, then create an object for each combination of those areas, and to save each object file models.py class collarsult type (models.Model): id = model. AutoField (db_column = 'icontact_result_code_type_id', primary_key = true) callResult = models.ForeignKey ( 'CallResult', db_column = 'icontact_result_code_id') campaign = models.ForeignKey ( 'campaign', db_column = 'icampaign_id') CALLTYPE = models.ForeignKey ( 'CALLTYPE', db_column = 'icall_type_id') agent = models.BooleanField (db_column = 'bagent', default = true) teamLeader = models.BooleanField (db_column = 'bTeamLeader', default = true) active = models.BooleanField (db_column = Django.form...
Read more

html - CSS autoheight, but fit content to height of div -

I have a div in which there are three children- div in the left and middle div: float: left while true: float: true because it is my layout Actually will spoil, I've used ClearFix Hack: .cf {zoom: 1; }. Cf: First,. Cf: {content: ""; Display: Table; }. Cf: After {clear: both; } It still works, but I want to be the right div an indicator. So it should fill 100% of the parent unit of height. How can I complete this? PS is the full code: & Lt; / Div & gt; & Lt; Div class = "mobile_content" & gt; & Lt; H5 & gt; {{Data.titel}} & lt; / H5> & Lt; Table & gt; & Lt; TR & gt; & Lt; Th & gt; Komponist: & lt; / Th & gt; & Lt; TD & gt; {{Data.komponist}} & lt; / TD & gt; & Lt; / TR & gt; & Lt; TR & gt; & Lt; Th & gt; Instrument: & lt; / Th & gt; & Lt; TD & gt; {{Data.instrumente}} & lt; / TD & gt; & Lt; / TR & gt;...
Read more

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -

I have been trying to use Qt5 multimedia to record audio with QAudioInput, however, when I see If QAudioInput is started, it increases the master volume of my sound device to 100%. How can I prevent QAudioInput from changing the master volume? My current development platform is Linux with PalsAdio (with flat audio disabled). How can I use QAudioInput : QAudioDeviceInfo device_info = QAudioDeviceInfo :: defaultInputDevice (); QAudio format format; Format.setSampleRate (44100); Format.setChannelCount (1); Format.setSampleSize (16); Format.setCodec ("Audio / PCM"); Format.setSampleType (QAudioFormat :: SignedInt); Format.setByteOrder (QAudioFormat :: LittleEndian); Std :: cout & lt; & Lt; Device_info.deviceName (). ToUtf8 (). ConstData () & lt; & Lt; Std :: endl; QAudioInput * default_device = new QAudioInput (device_info, format); QIODevice * default_io_device = default_device-> Start (); a QAudioInput.setVolume () method is not you I ...
Read more