导入地址簿联系人，存储在数组中并保存到数据库

Im using Contact Grabber API to retrieve address book contacts.

我使用Contact Grabber API来检索地址簿联系人。

My intention is to then allow the user to select their contacts (via checkbox list) and insert these values into a database.

我的目的是让用户选择他们的联系人（通过复选框列表）并将这些值插入数据库。

HTML for list:

列表的HTML：

<input type="checkbox" name="user_email" value="{users_email}" />

JQUERY to post data to PHP form

JQUERY将数据发布到PHP表单

    $("#divDone").click(function() {
        var data = { 'user_email' : []};
        $(":checked").each(function() {
          data['user_email'].push($(this).val());
        });
        $.post("ajax.php", data);
    });

ajax.php

var_export($_POST);

The ajax.php file echo's the following sample (of selecting two contacts)

ajax.php文件echo是以下示例（选择两个联系人）

array (
 'user_email' => 
  array (
    0 => 'gmail',
    1 => '{email1}',
    2 => '{email2}',
  ),
)

How do extract the email values and store them into my database? Is this method correct?

如何提取电子邮件值并将其存储到我的数据库中？这种方法是否正确？

Thank you all in advance

谢谢大家

George

乔治

1 个解决方案

#1

I hope you know what a MySQL database is and how to set up a table, see below for a basic example where you take all the emails and just put them in a table called Emails which has one column email

我希望你知道MySQL数据库是什么以及如何设置表，请参阅下面的一个基本示例，其中您将收集所有电子邮件，并将它们放在一个名为Emails的表中，该表有一列电子邮件

//Did we get a post?
if(empty($_POST['user_email']) && is_array($_POST['user_email'])) {
  echo "No Email's received. Check the post.";
} else {
  $emails = $_POST['user_email'];

  $errors = "";

  //## Connect to MYSQL here ##//
  $con = null; //SEE ABOVE

  //For all the posted emails
  foreach($emails as $email) {
    //Trim and escape the input
    $email = mysqli_real_escape_string(trim($email));
    $sql = "INSERT INTO Emails (email) ";
    $sql += "VALUES ('$email')";

    //If an error occurred add it to the list
    if (!mysql_query($sql,$con)) $errors += mysql_error()."\n";
  } //for each

  //Any errors?
  if(!empty($errors)) echo $errors;
}

1 个解决方案

#1

更多相关文章

随机推荐