Results 1 to 4 of 4

Thread: php

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Jul:2010
    Location: burgas
    Posts: 6

    php

    2
    .

    <?php
    $df="4anta";


    // MySQL connect information.
    $c_username = "root";
    $c_password = "";
    $c_host = "localhost";
    $c_database = "sait";

    // Connect.
    $connection = mysql_connect($c_host, $c_username, $c_password)
    or die ("It seems this site's database isn't responding.");



    mysql_query('set names utf8_general_ci', $connection);

    mysql_select_db($c_database)
    or die ("It seems this site's database isn't responding.");




    $SQL3 = "SELECT * FROM `obiavi,lichni` WHERE `text` LIKE '%$df%' AND `text` LIKE '%$df%' ";

    $result3 = mysql_query($SQL3);

    while($db_field = mysql_fetch_assoc($result3))
    {


    echo"


    $db_field[text]


    ";


    }

    ?>

  2. #2
    Registered User
    Join Date: Dec:2003
    Posts: 2,817
    UNION Mysql-a - , , ..
    Gigabyte DS3P, E4400@9x333, 2x2Gb Super T@1000Mhz, Gigabyte GTX460OC 768Mb

  3. #3
    Registered User
    Join Date: Jul:2010
    Location: burgas
    Posts: 6

    $SQL3 = "(SELECT `den1`,`text`,`mesec1`,`godina1`,`chas`, `srok`,`goliama`,`malka`,`grad`,`den`,`m esec`,`godina`,`telefon` FROM `obiavi` WHERE `text` LIKE '%$searchDuma%') UNION (SELECT `den1`,`text`,`mesec1`,`godina1`,`chas`, `srok`,`goliama`,`malka`,`grad`,`den`,`m esec`,`godina`,`telefon` FROM `lichni` WHERE `text` LIKE '%$searchDuma%')";

  4. #4
    Deleted User 4eRNoBiL's Avatar
    Join Date: Oct:2005
    Location:
    Posts: 739
    :
    Code:
    $SQL3 = "
    SELECT * FROM `obiavi,lichni` 
    WHERE `text` LIKE '%$df%' 
      AND `text` LIKE '%$df%' ";
    :
    Code:
    $SQL3 = "
    SELECT * FROM obiavi, lichni 
    WHERE obiavi.text LIKE '%$df%' 
      AND lichni.text LIKE '%$df%' ";
    - OR AND, .

    zlozi, - $df, , .
    Fujistu Lifebook E756 | Core i7-6500U / 400MHz-3.1GHz | 8 GB DDR4-2133 | Samsung PM871 / 256 GB SSD | 15" 1920x1080 | Manjaro Linux + kernel 4.19

Posting Permissions

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

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |