1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

PHP Search Script not Working

Discussion in 'PHP' started by Sarao, Jan 26, 2011.

  1. #1
    Please suggest me where I am doing wrong? Its not searching at al.

    SEARCH FORM

    
    <html>
    	<head>
    		<title>Search the Database</title>
    	</head>
    	<body>
    	<form action="print.php" method="post">
      	 Search: <input type="text" name="term" /><br />
        <input type="submit" name="submit" value="Submit" />
    	</form>
    	</body>
    </html>
    
    PHP:


    SEARCH CODE

    
    <?php
    mysql_connect ("localhost", "root","")  or die (mysql_error());
    mysql_select_db ("shipments");
    $term = $_POST['term'];
    $sql = mysql_query("select * from info where user like '%$term%'");
    while ($row = mysql_fetch_array($sql)){
    
    $id = $result['id'];  
    $to = $result['to'];  
    $wgt = $result['wgt'];  
    $user = $result['user'];  
    $price = $result['price'];  
    $item = $result['item'];  
    $itemid = $result['itemid'];  
    
    }  
      
    ?>  
    
    <style type="text/css">
    <!--
    .K {
    	font-size: 14px;
    	font-weight: normal;
    	font-family: Tahoma, Geneva, sans-serif;
    }
    .bar {
    	font:"Free 3 of 9 Extended";
    	font-size:14px;
    }
    
    .K2 {
    	font-size: 14px;
    	font-family: tahoma, Geneva, sans-serif;
    }
    .ff {
    	font-family: "Courier New", Courier, monospace;
    }
    -->
    </style>
    
    <table align="left">
      <tr>
        <td>
          <table width="97%" align="center" background="ss.jpg">
            <tr>
              <td width="68%">SHIPID: <?php echo $id ;?></td>
              <td width="32%" class="ff">CONTENTS:<?php echo $item ;?></td>
            </tr>
          </table>
    
          <table>
            <tr>
              <td>&nbsp;</td>
            </tr>
          </table>
          <table width="800" align="center">
            <tr>
            <td class="K"><strong><U>SEND TO :</U></strong></td>
            <td class="K2">&nbsp;</td>
            <td class="K" align="right"><strong>FROM :</strong></td>
            <td class="K2">&nbsp;</td>
          </tr>
          <tr>
            <td width="12%" height="131" class="K">&nbsp;</td>
            <td align="justify" width="34%" class="K2"><table width="250">
                <tr>
                  <td class="K2" style="text-transform:uppercase"><strong><br /><?php echo ( nl2br ($to ));?></strong></td>
                  </tr>
              </table>         </td>
            <td width="14%" class="K" align="center"><p>::</p>
              <p>::</p>
              <p>::</p>
              <p>::</p></td>
            <td align="justify" width="40%" class="K2">&nbsp;</td>
          </tr>
          <tr>
            <td height="16" class="K">------------------</td>
            <td class="K2">--------------------------------------------------</td>
            <td class="K">---------------------</td>
            <td class="K">--------------------------------------------------------</td>
          </tr>
        </table>
          <table width="72%" align="center">
            <tr>
              <td align="center"><span style="font:Verdana, Geneva, sans-serif; font-size: 10px;"> :: Package Information :: </span></td>
            </tr>
          </table>
          <table  width="72%" align="center" >
            <tr align="left">
              <td width="11%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" height="20">*Content:</td>
              <td width="28%"  class="K2">SPOAcc.</td>
              <td width="8%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;">*Weight:</td>
              <td width="31%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><?php echo $wgt ;?> grams</td>
              <td width="9%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K"><p>*Price:</td>
              <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><span class="K2" style="font:Verdana, Geneva, sans-serif; font-size: 10px;"><?php echo $price ;?> USD</span></td>
              <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2" align="right">UID</td>
              <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><strong><?php echo $user ;?>;</strong></td>
            </tr>
          </table>
        <hr color="#CCCCCC" />
        <table width="100%">
          <tr>
            <td width="57%" height="67"><p>Item ID:</p>
              <?php echo $itemid ;?></td>
            <td width="43%"><p>Tracking Code:</p>
              <p>&nbsp;</p></td>
          </tr>
        </table></td>
      </tr>
    </table>
    
    
    PHP:
     
    Sarao, Jan 26, 2011 IP
  2. G3n3s!s

    G3n3s!s Active Member

    Messages:
    325
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    80
    #2
    what's your problem?
    However' this code can show you ONLY one result, because you're filling same variable with diifferent data in while(){}
     
    G3n3s!s, Jan 26, 2011 IP
  3. MyVodaFone

    MyVodaFone Well-Known Member

    Messages:
    1,048
    Likes Received:
    42
    Best Answers:
    10
    Trophy Points:
    195
    #3
    To start with change while ($row =

    to

    while ($results =

    or else change to example

    $id = $row['id'];
     
    MyVodaFone, Jan 26, 2011 IP
  4. G3n3s!s

    G3n3s!s Active Member

    Messages:
    325
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    80
    #4
    wow MyVodaFone nice eyes! I missed that at all!
    I apologise for my first reply :D
    Thank you
     
    G3n3s!s, Jan 26, 2011 IP
  5. Sarao

    Sarao Peon

    Messages:
    110
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    I did the following changes but it still does not work

    
    <?php  
    $con = mysql_connect("localhost","root","");
    if (!$con)
      {
      die('Could not connect: ' . mysql_error());
      }
    
    mysql_select_db("shipments", $con);
    $term = $_POST['term'];
    $results = mysql_query("select * from info where user like '%$term%'");
      
    while ($result = mysql_fetch_array($results)) {  
    $id = $result['id'];  
    $to = $result['to'];  
    $wgt = $result['wgt'];  
    $user = $result['user'];  
    $price = $result['price'];  
    $item = $result['item'];  
    $itemid = $result['itemid'];  
    
    }  
      
    ?>  
    
    <style type="text/css">
    <!--
    .K {
    	font-size: 14px;
    	font-weight: normal;
    	font-family: Tahoma, Geneva, sans-serif;
    }
    .bar {
    	font:"Free 3 of 9 Extended";
    	font-size:14px;
    }
    
    .K2 {
    	font-size: 14px;
    	font-family: tahoma, Geneva, sans-serif;
    }
    .ff {
    	font-family: "Courier New", Courier, monospace;
    }
    -->
    </style>
    
    <table align="left">
      <tr>
        <td>
          <table width="97%" align="center" background="ss.jpg">
            <tr>
              <td width="68%">SHIPID: <?php echo $id ;?></td>
              <td width="32%" class="ff">CONTENTS:<?php echo $item ;?></td>
            </tr>
          </table>
    
          <table>
            <tr>
              <td>&nbsp;</td>
            </tr>
          </table>
          <table width="800" align="center">
            <tr>
            <td class="K"><strong><U>SEND TO :</U></strong></td>
            <td class="K2">&nbsp;</td>
            <td class="K" align="right"><strong>FROM :</strong></td>
            <td class="K2">&nbsp;</td>
          </tr>
          <tr>
            <td width="12%" height="131" class="K">&nbsp;</td>
            <td align="justify" width="34%" class="K2"><table width="250">
                <tr>
                  <td class="K2" style="text-transform:uppercase"><strong><br /><?php echo ( nl2br ($to ));?></strong></td>
                  </tr>
              </table>         </td>
            <td width="14%" class="K" align="center"><p>::</p>
              <p>::</p>
              <p>::</p>
              <p>::</p></td>
            <td align="justify" width="40%" class="K2">&nbsp;</td>
          </tr>
          <tr>
            <td height="16" class="K">------------------</td>
            <td class="K2">--------------------------------------------------</td>
            <td class="K">---------------------</td>
            <td class="K">--------------------------------------------------------</td>
          </tr>
        </table>
          <table width="72%" align="center">
            <tr>
              <td align="center"><span style="font:Verdana, Geneva, sans-serif; font-size: 10px;"> :: Package Information :: </span></td>
            </tr>
          </table>
          <table  width="72%" align="center" >
            <tr align="left">
              <td width="11%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" height="20">*Content:</td>
              <td width="28%"  class="K2">PhotoGraphy Acc.</td>
              <td width="8%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;">*Weight:</td>
              <td width="31%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><?php echo $wgt ;?> grams</td>
              <td width="9%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K"><p>*Price:</td>
              <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><span class="K2" style="font:Verdana, Geneva, sans-serif; font-size: 10px;"><?php echo $price ;?> USD</span></td>
              <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2" align="right">UID</td>
              <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><strong><?php echo $user ;?>;</strong></td>
            </tr>
          </table>
        <hr color="#CCCCCC" />
        <table width="100%">
          <tr>
            <td width="57%" height="67"><p>Item ID:</p>
              <?php echo $itemid ;?></td>
            <td width="43%"><p>Tracking Code:</p>
              <p>&nbsp;</p></td>
          </tr>
        </table></td>
      </tr>
    </table>
    
    
    PHP:
    It sayd undefined variables on all the places where its

    <?php echo $id ;?>
    
    PHP:
     
    Sarao, Jan 27, 2011 IP
  6. MyVodaFone

    MyVodaFone Well-Known Member

    Messages:
    1,048
    Likes Received:
    42
    Best Answers:
    10
    Trophy Points:
    195
    #6
    Just at a glance try this... its not tested, but basically you need to put your table into the while loop
    
    <style type="text/css">
    <!--
    .K {
        font-size: 14px;
        font-weight: normal;
        font-family: Tahoma, Geneva, sans-serif;
    }
    .bar {
        font:"Free 3 of 9 Extended";
        font-size:14px;
    }
    
    .K2 {
        font-size: 14px;
        font-family: tahoma, Geneva, sans-serif;
    }
    .ff {
        font-family: "Courier New", Courier, monospace;
    }
    -->
    </style>
    
    
    <?php  
    $con = mysql_connect("localhost","root","");
    if (!$con)
      {
      die('Could not connect: ' . mysql_error());
      }
    
    mysql_select_db("shipments", $con);
    $term = $_POST['term'];
    $results = mysql_query("select * from info where user like '%$term%'");
      
    while ($result = mysql_fetch_array($results)) {  
    $id = $result['id'];  
    $to = $result['to'];  
    $wgt = $result['wgt'];  
    $user = $result['user'];  
    $price = $result['price'];  
    $item = $result['item'];  
    $itemid = $result['itemid'];  
    
    echo '
    
    <table align="left">
      <tr>
        <td>
          <table width="97%" align="center" background="ss.jpg">
            <tr>
              <td width="68%">SHIPID: <?php echo $id ;?></td>
              <td width="32%" class="ff">CONTENTS:<?php echo $item ;?></td>
            </tr>
          </table>
    
          <table>
            <tr>
              <td>&nbsp;</td>
            </tr>
          </table>
          <table width="800" align="center">
            <tr>
            <td class="K"><strong><U>SEND TO :</U></strong></td>
            <td class="K2">&nbsp;</td>
            <td class="K" align="right"><strong>FROM :</strong></td>
            <td class="K2">&nbsp;</td>
          </tr>
          <tr>
            <td width="12%" height="131" class="K">&nbsp;</td>
            <td align="justify" width="34%" class="K2"><table width="250">
                <tr>
                  <td class="K2" style="text-transform:uppercase"><strong><br /><?php echo ( nl2br ($to ));?></strong></td>
                  </tr>
              </table>         </td>
            <td width="14%" class="K" align="center"><p>::</p>
              <p>::</p>
              <p>::</p>
              <p>::</p></td>
            <td align="justify" width="40%" class="K2">&nbsp;</td>
          </tr>
          <tr>
            <td height="16" class="K">------------------</td>
            <td class="K2">--------------------------------------------------</td>
            <td class="K">---------------------</td>
            <td class="K">--------------------------------------------------------</td>
          </tr>
        </table>
          <table width="72%" align="center">
            <tr>
              <td align="center"><span style="font:Verdana, Geneva, sans-serif; font-size: 10px;"> :: Package Information :: </span></td>
            </tr>
          </table>
          <table  width="72%" align="center" >
            <tr align="left">
              <td width="11%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" height="20">*Content:</td>
              <td width="28%"  class="K2">PhotoGraphy Acc.</td>
              <td width="8%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;">*Weight:</td>
              <td width="31%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><?php echo $wgt ;?> grams</td>
              <td width="9%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K"><p>*Price:</td>
              <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><span class="K2" style="font:Verdana, Geneva, sans-serif; font-size: 10px;"><?php echo $price ;?> USD</span></td>
              <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2" align="right">UID</td>
              <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><strong><?php echo $user ;?>;</strong></td>
            </tr>
          </table>
        <hr color="#CCCCCC" />
        <table width="100%">
          <tr>
            <td width="57%" height="67"><p>Item ID:</p>
              <?php echo $itemid ;?></td>
            <td width="43%"><p>Tracking Code:</p>
              <p>&nbsp;</p></td>
          </tr>
        </table></td>
      </tr>
    </table> ';
    }
    ?>
    
    PHP:
     
    MyVodaFone, Jan 27, 2011 IP
  7. Sarao

    Sarao Peon

    Messages:
    110
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    It now diplays a Blank Page. :(
     
    Sarao, Jan 27, 2011 IP
  8. G3n3s!s

    G3n3s!s Active Member

    Messages:
    325
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    80
    #8
    MyVodaFone -> sorry but wrong, ou forgot there are <?php ?> tags in that tables
    <style type="text/css">
    <!--
    .K {
        font-size: 14px;
        font-weight: normal;
        font-family: Tahoma, Geneva, sans-serif;
    }
    .bar {
        font:"Free 3 of 9 Extended";
        font-size:14px;
    }
    
    .K2 {
        font-size: 14px;
        font-family: tahoma, Geneva, sans-serif;
    }
    .ff {
        font-family: "Courier New", Courier, monospace;
    }
    -->
    </style>
    
    
    <?php  
    $con = mysql_connect("localhost","root","");
    if (!$con)
      {
      die('Could not connect: ' . mysql_error());
      }
    
    mysql_select_db("shipments", $con);
    $term = $_POST['term'];
    $results = mysql_query("select * from info where user like '%$term%'");
      
    while ($result = mysql_fetch_array($results)) {  
    $id = $result['id'];  
    $to = $result['to'];  
    $wgt = $result['wgt'];  
    $user = $result['user'];  
    $price = $result['price'];  
    $item = $result['item'];  
    $itemid = $result['itemid'];  
    
    echo '
    
    <table align="left">
      <tr>
        <td>
          <table width="97%" align="center" background="ss.jpg">
            <tr>
              <td width="68%">SHIPID: '.$id.'</td>
              <td width="32%" class="ff">CONTENTS:'.$item.'</td>
            </tr>
          </table>
    
          <table>
            <tr>
              <td>&nbsp;</td>
            </tr>
          </table>
          <table width="800" align="center">
            <tr>
            <td class="K"><strong><U>SEND TO :</U></strong></td>
            <td class="K2">&nbsp;</td>
            <td class="K" align="right"><strong>FROM :</strong></td>
            <td class="K2">&nbsp;</td>
          </tr>
          <tr>
            <td width="12%" height="131" class="K">&nbsp;</td>
            <td align="justify" width="34%" class="K2"><table width="250">
                <tr>
                  <td class="K2" style="text-transform:uppercase"><strong><br />'.nl2br ($to).'</strong></td>
                  </tr>
              </table>         </td>
            <td width="14%" class="K" align="center"><p>::</p>
              <p>::</p>
              <p>::</p>
              <p>::</p></td>
            <td align="justify" width="40%" class="K2">&nbsp;</td>
          </tr>
          <tr>
            <td height="16" class="K">------------------</td>
            <td class="K2">--------------------------------------------------</td>
            <td class="K">---------------------</td>
            <td class="K">--------------------------------------------------------</td>
          </tr>
        </table>
          <table width="72%" align="center">
            <tr>
              <td align="center"><span style="font:Verdana, Geneva, sans-serif; font-size: 10px;"> :: Package Information :: </span></td>
            </tr>
          </table>
          <table  width="72%" align="center" >
            <tr align="left">
              <td width="11%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" height="20">*Content:</td>
              <td width="28%"  class="K2">PhotoGraphy Acc.</td>
              <td width="8%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;">*Weight:</td>
              <td width="31%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2">'.$wgt.' grams</td>
              <td width="9%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K"><p>*Price:</td>
              <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><span class="K2" style="font:Verdana, Geneva, sans-serif; font-size: 10px;">'.$price.' USD</span></td>
              <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2" align="right">UID</td>
              <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><strong>'.$user'</strong></td>
            </tr>
          </table>
        <hr color="#CCCCCC" />
        <table width="100%">
          <tr>
            <td width="57%" height="67"><p>Item ID:</p>
              '.$itemid.'</td>
            <td width="43%"><p>Tracking Code:</p>
              <p>&nbsp;</p></td>
          </tr>
        </table></td>
      </tr>
    </table> ';
    }
    ?>
    PHP:
     
    G3n3s!s, Jan 27, 2011 IP
  9. Sarao

    Sarao Peon

    Messages:
    110
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #9
    Thanx, it now gives me an error

    
    Parse error: parse error, expecting `','' or `';'' in C:\wamp\www\print.php on line 78
    
    Code (markup):
     
    Sarao, Jan 27, 2011 IP
  10. G3n3s!s

    G3n3s!s Active Member

    Messages:
    325
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    80
    #10
    If that line is wrong, sorry for that... try this
    <style type="text/css">
    <!--
    .K {
        font-size: 14px;
        font-weight: normal;
        font-family: Tahoma, Geneva, sans-serif;
    }
    .bar {
        font:"Free 3 of 9 Extended";
        font-size:14px;
    }
    
    .K2 {
        font-size: 14px;
        font-family: tahoma, Geneva, sans-serif;
    }
    .ff {
        font-family: "Courier New", Courier, monospace;
    }
    -->
    </style>
    
    
    <?php  
    $con = mysql_connect("localhost","root","");
    if (!$con)
      {
      die('Could not connect: ' . mysql_error());
      }
    
    mysql_select_db("shipments", $con);
    $term = $_POST['term'];
    $results = mysql_query("select * from info where user like '%$term%'");
      
    while ($result = mysql_fetch_array($results)) {  
    $id = $result['id'];  
    $to = $result['to'];  
    $wgt = $result['wgt'];  
    $user = $result['user'];  
    $price = $result['price'];  
    $item = $result['item'];  
    $itemid = $result['itemid'];  
    
    echo '
    
    <table align="left">
      <tr>
        <td>
          <table width="97%" align="center" background="ss.jpg">
            <tr>
              <td width="68%">SHIPID: '.$id.'</td>
              <td width="32%" class="ff">CONTENTS:'.$item.'</td>
            </tr>
          </table>
    
          <table>
            <tr>
              <td>&nbsp;</td>
            </tr>
          </table>
          <table width="800" align="center">
            <tr>
            <td class="K"><strong><U>SEND TO :</U></strong></td>
            <td class="K2">&nbsp;</td>
            <td class="K" align="right"><strong>FROM :</strong></td>
            <td class="K2">&nbsp;</td>
          </tr>
          <tr>
            <td width="12%" height="131" class="K">&nbsp;</td>
            <td align="justify" width="34%" class="K2"><table width="250">
                <tr>
                  <td class="K2" style="text-transform:uppercase"><strong><br />'.(nl2br ($to)).'</strong></td>
                  </tr>
              </table>         </td>
            <td width="14%" class="K" align="center"><p>::</p>
              <p>::</p>
              <p>::</p>
              <p>::</p></td>
            <td align="justify" width="40%" class="K2">&nbsp;</td>
          </tr>
          <tr>
            <td height="16" class="K">------------------</td>
            <td class="K2">--------------------------------------------------</td>
            <td class="K">---------------------</td>
            <td class="K">--------------------------------------------------------</td>
          </tr>
        </table>
          <table width="72%" align="center">
            <tr>
              <td align="center"><span style="font:Verdana, Geneva, sans-serif; font-size: 10px;"> :: Package Information :: </span></td>
            </tr>
          </table>
          <table  width="72%" align="center" >
            <tr align="left">
              <td width="11%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" height="20">*Content:</td>
              <td width="28%"  class="K2">PhotoGraphy Acc.</td>
              <td width="8%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;">*Weight:</td>
              <td width="31%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2">'.$wgt.' grams</td>
              <td width="9%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K"><p>*Price:</td>
              <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><span class="K2" style="font:Verdana, Geneva, sans-serif; font-size: 10px;">'.$price.' USD</span></td>
              <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2" align="right">UID</td>
              <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><strong>'.$user'</strong></td>
            </tr>
          </table>
        <hr color="#CCCCCC" />
        <table width="100%">
          <tr>
            <td width="57%" height="67"><p>Item ID:</p>
              '.$itemid.'</td>
            <td width="43%"><p>Tracking Code:</p>
              <p>&nbsp;</p></td>
          </tr>
        </table></td>
      </tr>
    </table> ';
    }
    ?>
    PHP:
     
    G3n3s!s, Jan 27, 2011 IP
  11. Sarao

    Sarao Peon

    Messages:
    110
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #11
    ITs giving me an error on line where '.$itemid.' is. Not sure whats wrong.
     
    Sarao, Jan 27, 2011 IP
  12. G3n3s!s

    G3n3s!s Active Member

    Messages:
    325
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    80
    #12
    sorry. find line
        <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><strong>'.$user'</strong></td>
    PHP:
    and replace that line with
        <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><strong>'.$user.'</strong></td>
    PHP:
    dot missing :D
     
    G3n3s!s, Jan 27, 2011 IP
  13. Sarao

    Sarao Peon

    Messages:
    110
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #13
    I did that already, before you replied :p

    Anyways, but now I am facing another problem. When I search for something which is not present in DB, it simply give me a blank page and not an error. I know that we require to put some code to show error, but since I no know PHP asking your help once again, please :)
     
    Sarao, Jan 27, 2011 IP
  14. seoelk.com

    seoelk.com Peon

    Messages:
    19
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #14
    You can find some answers in php manual: php.net/manual/en/function.mysql-query.php #1 example
     
    seoelk.com, Jan 27, 2011 IP
  15. drctaccess

    drctaccess Peon

    Messages:
    62
    Likes Received:
    1
    Best Answers:
    1
    Trophy Points:
    0
    #15
    Replace this:
    
    <?php  
    $con = mysql_connect("localhost","root","");
    if (!$con)
      {
      die('Could not connect: ' . mysql_error());
      }
    
    mysql_select_db("shipments", $con);
    $term = $_POST['term'];
    $results = mysql_query("select * from info where user like '%$term%'");
      
    while ($result = mysql_fetch_array($results)) {  
    $id = $result['id'];  
    $to = $result['to'];  
    $wgt = $result['wgt'];  
    $user = $result['user'];  
    $price = $result['price'];  
    $item = $result['item'];  
    $itemid = $result['itemid'];  
    
    echo '
    
    <table align="left">
      <tr>
        <td>
          <table width="97%" align="center" background="ss.jpg">
            <tr>
              <td width="68%">SHIPID: '.$id.'</td>
              <td width="32%" class="ff">CONTENTS:'.$item.'</td>
            </tr>
          </table>
    
          <table>
            <tr>
              <td>&nbsp;</td>
            </tr>
          </table>
          <table width="800" align="center">
            <tr>
            <td class="K"><strong><U>SEND TO :</U></strong></td>
            <td class="K2">&nbsp;</td>
            <td class="K" align="right"><strong>FROM :</strong></td>
            <td class="K2">&nbsp;</td>
          </tr>
          <tr>
            <td width="12%" height="131" class="K">&nbsp;</td>
            <td align="justify" width="34%" class="K2"><table width="250">
                <tr>
                  <td class="K2" style="text-transform:uppercase"><strong><br />'.(nl2br ($to)).'</strong></td>
                  </tr>
              </table>         </td>
            <td width="14%" class="K" align="center"><p>::</p>
              <p>::</p>
              <p>::</p>
              <p>::</p></td>
            <td align="justify" width="40%" class="K2">&nbsp;</td>
          </tr>
          <tr>
            <td height="16" class="K">------------------</td>
            <td class="K2">--------------------------------------------------</td>
            <td class="K">---------------------</td>
            <td class="K">--------------------------------------------------------</td>
          </tr>
        </table>
          <table width="72%" align="center">
            <tr>
              <td align="center"><span style="font:Verdana, Geneva, sans-serif; font-size: 10px;"> :: Package Information :: </span></td>
            </tr>
          </table>
          <table  width="72%" align="center" >
            <tr align="left">
              <td width="11%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" height="20">*Content:</td>
              <td width="28%"  class="K2">PhotoGraphy Acc.</td>
              <td width="8%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;">*Weight:</td>
              <td width="31%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2">'.$wgt.' grams</td>
              <td width="9%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K"><p>*Price:</td>
              <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><span class="K2" style="font:Verdana, Geneva, sans-serif; font-size: 10px;">'.$price.' USD</span></td>
              <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2" align="right">UID</td>
              <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><strong>'.$user'</strong></td>
            </tr>
          </table>
        <hr color="#CCCCCC" />
        <table width="100%">
          <tr>
            <td width="57%" height="67"><p>Item ID:</p>
              '.$itemid.'</td>
            <td width="43%"><p>Tracking Code:</p>
              <p>&nbsp;</p></td>
          </tr>
        </table></td>
      </tr>
    </table> ';
    }
    ?>
    
    Code (markup):
    with this:

    
    <?php  
    $con = mysql_connect("localhost","root","");
    if (!$con)
      {
      die('Could not connect: ' . mysql_error());
      }
    
    mysql_select_db("shipments", $con);
    $term = $_POST['term'];
    $results = mysql_query("select * from info where user like '%$term%'");
    $found = 0;  
    while ($result = mysql_fetch_array($results)) {  
    $found = 1;
    $id = $result['id'];  
    $to = $result['to'];  
    $wgt = $result['wgt'];  
    $user = $result['user'];  
    $price = $result['price'];  
    $item = $result['item'];  
    $itemid = $result['itemid'];  
    
    echo '
    
    <table align="left">
      <tr>
        <td>
          <table width="97%" align="center" background="ss.jpg">
            <tr>
              <td width="68%">SHIPID: '.$id.'</td>
              <td width="32%" class="ff">CONTENTS:'.$item.'</td>
            </tr>
          </table>
    
          <table>
            <tr>
              <td>&nbsp;</td>
            </tr>
          </table>
          <table width="800" align="center">
            <tr>
            <td class="K"><strong><U>SEND TO :</U></strong></td>
            <td class="K2">&nbsp;</td>
            <td class="K" align="right"><strong>FROM :</strong></td>
            <td class="K2">&nbsp;</td>
          </tr>
          <tr>
            <td width="12%" height="131" class="K">&nbsp;</td>
            <td align="justify" width="34%" class="K2"><table width="250">
                <tr>
                  <td class="K2" style="text-transform:uppercase"><strong><br />'.(nl2br ($to)).'</strong></td>
                  </tr>
              </table>         </td>
            <td width="14%" class="K" align="center"><p>::</p>
              <p>::</p>
              <p>::</p>
              <p>::</p></td>
            <td align="justify" width="40%" class="K2">&nbsp;</td>
          </tr>
          <tr>
            <td height="16" class="K">------------------</td>
            <td class="K2">--------------------------------------------------</td>
            <td class="K">---------------------</td>
            <td class="K">--------------------------------------------------------</td>
          </tr>
        </table>
          <table width="72%" align="center">
            <tr>
              <td align="center"><span style="font:Verdana, Geneva, sans-serif; font-size: 10px;"> :: Package Information :: </span></td>
            </tr>
          </table>
          <table  width="72%" align="center" >
            <tr align="left">
              <td width="11%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" height="20">*Content:</td>
              <td width="28%"  class="K2">PhotoGraphy Acc.</td>
              <td width="8%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;">*Weight:</td>
              <td width="31%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2">'.$wgt.' grams</td>
              <td width="9%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K"><p>*Price:</td>
              <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><span class="K2" style="font:Verdana, Geneva, sans-serif; font-size: 10px;">'.$price.' USD</span></td>
              <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2" align="right">UID</td>
              <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><strong>'.$user'</strong></td>
            </tr>
          </table>
        <hr color="#CCCCCC" />
        <table width="100%">
          <tr>
            <td width="57%" height="67"><p>Item ID:</p>
              '.$itemid.'</td>
            <td width="43%"><p>Tracking Code:</p>
              <p>&nbsp;</p></td>
          </tr>
        </table></td>
      </tr>
    </table> ';
    }
    if($found == 0)
    {
      echo 'No result found';
    }
    ?>
    
    Code (markup):
     
    drctaccess, Jan 28, 2011 IP
  16. G3n3s!s

    G3n3s!s Active Member

    Messages:
    325
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    80
    #16
    drtaccess why so hard? Just replace whole given code with this
    <style type="text/css">
    <!--
    .K {
        font-size: 14px;
        font-weight: normal;
        font-family: Tahoma, Geneva, sans-serif;
    }
    .bar {
        font:"Free 3 of 9 Extended";
        font-size:14px;
    }
    
    .K2 {
        font-size: 14px;
        font-family: tahoma, Geneva, sans-serif;
    }
    .ff {
        font-family: "Courier New", Courier, monospace;
    }
    -->
    </style>
    
    
    <?php  
    $con = mysql_connect("localhost","root","");
    if (!$con)
      {
      die('Could not connect: ' . mysql_error());
      }
    
    mysql_select_db("shipments", $con);
    $term = $_POST['term'];
    $results = mysql_query("select * from info where user like '%$term%'");
    if (mysql_num_rows($results) == 0) {echo "No results";}
    while ($result = mysql_fetch_array($results)) {  
    $id = $result['id'];  
    $to = $result['to'];  
    $wgt = $result['wgt'];  
    $user = $result['user'];  
    $price = $result['price'];  
    $item = $result['item'];  
    $itemid = $result['itemid'];  
    
    echo '
    
    <table align="left">
      <tr>
        <td>
          <table width="97%" align="center" background="ss.jpg">
            <tr>
              <td width="68%">SHIPID: '.$id.'</td>
              <td width="32%" class="ff">CONTENTS:'.$item.'</td>
            </tr>
          </table>
    
          <table>
            <tr>
              <td>&nbsp;</td>
            </tr>
          </table>
          <table width="800" align="center">
            <tr>
            <td class="K"><strong><U>SEND TO :</U></strong></td>
            <td class="K2">&nbsp;</td>
            <td class="K" align="right"><strong>FROM :</strong></td>
            <td class="K2">&nbsp;</td>
          </tr>
          <tr>
            <td width="12%" height="131" class="K">&nbsp;</td>
            <td align="justify" width="34%" class="K2"><table width="250">
                <tr>
                  <td class="K2" style="text-transform:uppercase"><strong><br />'.(nl2br ($to)).'</strong></td>
                  </tr>
              </table>         </td>
            <td width="14%" class="K" align="center"><p>::</p>
              <p>::</p>
              <p>::</p>
              <p>::</p></td>
            <td align="justify" width="40%" class="K2">&nbsp;</td>
          </tr>
          <tr>
            <td height="16" class="K">------------------</td>
            <td class="K2">--------------------------------------------------</td>
            <td class="K">---------------------</td>
            <td class="K">--------------------------------------------------------</td>
          </tr>
        </table>
          <table width="72%" align="center">
            <tr>
              <td align="center"><span style="font:Verdana, Geneva, sans-serif; font-size: 10px;"> :: Package Information :: </span></td>
            </tr>
          </table>
          <table  width="72%" align="center" >
            <tr align="left">
              <td width="11%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" height="20">*Content:</td>
              <td width="28%"  class="K2">PhotoGraphy Acc.</td>
              <td width="8%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;">*Weight:</td>
              <td width="31%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2">'.$wgt.' grams</td>
              <td width="9%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K"><p>*Price:</td>
              <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><span class="K2" style="font:Verdana, Geneva, sans-serif; font-size: 10px;">'.$price.' USD</span></td>
              <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2" align="right">UID</td>
              <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><strong>'.$user.'</strong></td>
            </tr>
          </table>
        <hr color="#CCCCCC" />
        <table width="100%">
          <tr>
            <td width="57%" height="67"><p>Item ID:</p>
              '.$itemid.'</td>
            <td width="43%"><p>Tracking Code:</p>
              <p>&nbsp;</p></td>
          </tr>
        </table></td>
      </tr>
    </table> ';
    }
    ?>
    PHP:
     
    G3n3s!s, Jan 28, 2011 IP