Top Questions

  • 5.11 Years

    • Category : Php
    • Location : Mohali
    • Posted On : May 6, 2016

    I have two tables in my database which are: user and event for PHP mysql search multiple tables using a keyword

    create table : event like
    CREATE TABLE IF NOT EXISTS `event` (
      `id` int(32) unsigned NOT NULL AUTO_INCREMENT,
      `email` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
      `event_name` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
    then create table : user like
    CREATE TABLE IF NOT EXISTS `user` (
      `id` int(32) unsigned NOT NULL AUTO_INCREMENT,
      `email` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
      `name` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
    mysql query
    $query = "(SELECT name,email,'new_name' as type FROM user WHERE name LIKE '%te%') UNION (SELECT event_name,email,'new_event_name' as type FROM event WHERE event_name LIKE '%te%')";
    mysql_query($query);
    output
    name     email                 type
    denis terzo   abcd@gmail.it       new_name
    Andrea    abcddd.abcddd@gmail.com   new_name
    test    abcddd.vvvv@gmail.com     new_event_name
    test    abcddd.vvvv@gmail.com     new_event_name
    ram     abcddd.vvvv@gmail.com     new_name
     

Add Your Answer

When answering a question please:
  1. Read the question carefully.
  2. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
  3. If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Let's work to help developers, not make them feel stupid.