0

Hi All, help me please!.
How to create Query for my project problem.

Mysql table:

CREATE TABLE `outbox` (
`id` INT( 11 ) NOT NULL ,
`phone_number` VARCHAR( 20 ) NOT NULL ,
`text` VARCHAR( 160 ) NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM ;


CREATE TABLE `contacts` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(25) NOT NULL,
  `phone` varchar(20) NOT NULL,
  `group_name` varchar(20) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

INSERT INTO `contacts` VALUES (1, 'jala', '+60111', 'friends');
INSERT INTO `contacts` VALUES (2, 'jali', '+60222', 'friends');
INSERT INTO `contacts` VALUES (3, 'jalu', '+60333', 'friends');
INSERT INTO `contacts` VALUES (4, 'kada', '+60444', 'members');
INSERT INTO `contacts` VALUES (5, 'kadi', '+60555', 'members');
INSERT INTO `contacts` VALUES (6, 'kadu', '+60666', 'members');

Form:

<html>
<body>
<h1>Form Send SMS Message</h1>

<form method="post" action="insert.php">
<table>
  <tr><td>Send To</td><td>:</td><td>
       <select name="group">
       <option selected>Select Phone Group</option>
         <option value="members">Members Group</option>
         <option value="friends">Friends Group</option>
       </select>
       </td><tr>   
  </tr>
  <tr><td>Message</td><td>:</td><td><textarea name="message" rows="10" cols="20"></textarea></td></tr>  
</table>
<input type="submit" name="submit" value="submit">
</form>
</body>
</html>

proses Form:

<?php
include ("koneksi.php");
$con = mysql_connect($servername,$username ,$password);
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("smsd");

        $group=$_POST['group'];
        $message=$_POST['message'];

    $qr_contacts = "SELECT phone FROM contacts WHERE group_name = $group";
    $rs_contacts = mysql_query($qr_contacts);
    while($data = mysql_fetch_array($rs_contacts))
        {
        $id= $data['id'];
        $phone= $data['phone'];

        // I Want insert to outbox tabel (phone_number, text) VALUES ('$phone','$message')
        // How to Create Query? 
        // Thank you.
        }

?>

Edited by gacoekchip.pokher

2
Contributors
4
Replies
5
Views
5 Years
Discussion Span
Last Post by LastMitch
0

@gacoekchip.pokher

Just this:

$query = mysql_query ("INSERT INTO outbox (phone_number, text) VALUES ('$phone','$message')") or die (mysql_error());

Can you also Click Solved from the previous thread if the answer I provided solved your question.

Edited by LastMitch: grammer

0

@LastMitch:

if $group =="friends";
$phone = '+60111', '+60222', '+60333';

How to insert to outbox table for one click?.

Edited by gacoekchip.pokher

0

@gacoekchip.pokher

I'm not gonna write out the whole code! I'm just gonna should you how to begin it.

This is the first few lines:

if ($_POST['$group'] == "friends"){
    $phone = $_POST['post'];
    $tquery = "SELECT phone FROM contacts WHERE group_name = '$group'";
    //Start here to finish the code
    }

If you have any more question just post it here.

Can you also Click Solved from the previous thread if the answer I provided solved your question. The reason why so other members need to find that answer, they can look at your thread. On your bottom left corner there's button called "Mark Question Solved".

Edited by LastMitch: grammer

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.