Professional Web Applications Themes

Searching with multiple search parameters PHP - Dreamweaver AppDev

I am attempting to build a multiple parameter search/result page in dreamweaver using php. I have been following along in the tutorial up until the recordset insertion. In step 5 of the tutorial "Searching with multiple search parameters" it says to give a value for the runtime values and then lists off examples for ASP Coldfusion and JSP but not PHP. AAARGH! Can anyone give me an example of what a runtime value would look like in PHP? The SQL in the tutorial looks like this: SELECT EMPLOYEEID, FIRSTNAME, LASTNAME, DEPARTMENT, EXTENSION ? FROM EMPLOYEE WHERE LASTNAME LIKE 'varLastName' AND ...

  1. #1

    Default Searching with multiple search parameters PHP

    I am attempting to build a multiple parameter search/result page in
    dreamweaver using php. I have been following along in the tutorial up until the
    recordset insertion.

    In step 5 of the tutorial "Searching with multiple search parameters" it says
    to give a value for the runtime values and then lists off examples for ASP
    Coldfusion and JSP but not PHP. AAARGH! Can anyone give me an example of what
    a runtime value would look like in PHP? The SQL in the tutorial looks like this:

    SELECT EMPLOYEEID, FIRSTNAME, LASTNAME, DEPARTMENT, EXTENSION ?
    FROM EMPLOYEE WHERE LASTNAME LIKE 'varLastName' AND DEPARTMENT ?
    LIKE 'varDept'

    Thanks!

    V

    vaene Guest

  2. #2

    Default Re: Searching with multiple search parameters PHP

    vaene wrote:
    > a runtime value would look like in PHP? The SQL in the tutorial looks like this:
    >
    > SELECT EMPLOYEEID, FIRSTNAME, LASTNAME, DEPARTMENT, EXTENSION ?
    > FROM EMPLOYEE WHERE LASTNAME LIKE 'varLastName' AND DEPARTMENT ?
    > LIKE 'varDept'
    SELECT EMPLOYEEID, FIRSTNAME, LASTNAME, DEPARTMENT, EXTENSION
    FROM EMPLOYEE WHERE LASTNAME LIKE '$lastName' AND DEPARTMENT
    LIKE '$dept'

    --
    David Powers
    Author, "Foundation PHP 5 for Flash" (friends of ED)
    Co-author "PHP Web Development with DW MX 2004" (Apress)
    [url]http://computerbookshelf.com[/url]
    David Powers Guest

Similar Threads

  1. Parsing Search Parameters
    By Charles R. Thompson in forum Coldfusion - Advanced Techniques
    Replies: 0
    Last Post: May 3rd, 01:47 PM
  2. ANN: InterAKT Site Search - search in multiple tables
    By Alexandro Colorado in forum Macromedia Dynamic HTML
    Replies: 0
    Last Post: November 29th, 04:23 PM
  3. Search multiple keywords across multiple fields
    By Darren Heinrich in forum ASP Database
    Replies: 3
    Last Post: February 6th, 05:29 AM
  4. MySql search question. Searching on keywords
    By dpg in forum PHP Development
    Replies: 1
    Last Post: August 9th, 06:49 AM
  5. searching multiple ages
    By John Vinson in forum Microsoft Access
    Replies: 0
    Last Post: July 19th, 01:17 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139