phpList.org

Automatic confirmation subscriber for hidden webform

Hello
Following the documentation on the website,
I created a hidden form to automatically subscribe in my phpList an user, when he fill out the contact form on my site.
Usually the subscriber receives an email to confirm your registration, when direct access to my phpList
I wanted to know if they can handle differently if the subscriber that’s entered via hidden form. I would like the user’s subscription is made directly without confirmation.
it’s possible? There is a particular parameter to be included in the string passed with method = "POST"
thanks

can you link to this?

Yes

This is the link: http://www.costellazionifamiliariesistemiche.it/content/richiedi-informazioni

My active list in 6

<div style="display:none;">
	<iframe id="ponyo_frame" name="ponyo_frame"></iframe>    
	<form id="richiesta_info_form" method="POST" action="http://www.lacittadellaluce.org/phplist/?p=subscribe&id=6" target="ponyo_frame">
		<input name="email" size="20" type="text" value="<?php echo $_SESSION['email'];?>" />
		<input name="emailconfirm" size="20" type="text" value="<?php echo $_SESSION['email'];?>" />
		<input name="list[6]" type="hidden" value="signup" checked /> 
		<input id="htmlemail" name="htmlemail" type="hidden" value="1" />
		<input type="hidden" name="subscribe" value="yes">
	</form>    
	<script>
	document.getElementById("richiesta_info_form").submit();
	</script>
</div>

You could shortcut the whole thing by running this on submit…

<?php
//    ADDS New Subscriber to selected list, confirmed

$servername = "mydomain.com";    //ENTER YOUR DOMAIN NAME
$username = "mydbusername";        //ENTER YOUR DATABASE USERNAME
$password = "mydbpassword";        //ENTER YOUR DATABASE PASSWORD
$dbname = "mydbname";            //ENTER YOUR DATABASE NAME
$dbprefix = "phplist";            //REPLACE WITH YOUR DATABASE PREFIX IF DIFFERENT THAN DEFAULT
$listid = 6;                    //THE listid YOU WANT TO ADD THE EMAIL TO
$addy = $_SESSION['email'];
$mydate = date('Y-m-d H:i:s');
$conn = mysqli_connect($servername, $username, $password, $dbname);

if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
} else {
    $sql = "SELECT ".$dbprefix."_user_user.email ";
    $sql .= "FROM ".$dbname.".".$dbprefix."_user_user ";
    $sql .= "INNER JOIN ".$dbname.".".$dbprefix."_listuser ON (".$dbprefix."_user_user.id = ".$dbprefix."_listuser.userid) ";
    $sql .= "WHERE ".$dbprefix."_user_user.email = '".$addy."' AND listid = '".$listid."';";
    $result = mysqli_query($conn, $sql);
    $exists = $result->num_rows;
    if ($exists > '0'){
        echo "$addy is already on list $listid<br />";
    } else {
        echo "I'll add $addy to list $listid<br />";
        $query = "INSERT into ".$dbprefix."_user_user(email, confirmed, entered) values ('$addy', '1', '$mydate');";
        mysqli_query($conn, $query);
        $query = "SELECT id FROM ".$dbprefix."_user_user WHERE email = '".$addy."';";
        $uuid = mysqli_query($conn, $query);
        $row = mysqli_fetch_array($uuid);
        $luuserid = $row['id'];
        $query = "INSERT into ".$dbprefix."_listuser(userid,listid,entered,modified) values ( '$luuserid', '$listid', '$mydate', '$mydate');";
        mysqli_query($conn, $query);
    };
    mysqli_close($conn);
};
?>

If you create a custom subscribe form and you want people to automatically be confirmed when they fill it out,
The forms “Action” attribute should point to this script.

None of that is programmed into the script… but it shouldn’t be difficult to add it in.

To automatically confirmed when people subscribing…

You got to edit on your subscribelib2.php
There’s a line where you can just change 0 to 1.

This is what we call single opt in…