php - I'm making a newsletter for a website and it does not connect to the server -


i'm making newsletter promo website , doesn't work me, simple form, register.php , connect.php connect database php. code looks this:

the connect.php

<?php $servername = "localhost"; $username = "root"; $password = "laidinis69"; $database = "promo";  $con = mysqli_connect($servername, $username, $password, $database); ?>

the register.php

<?php include('connect.php'); $form_name = $_post['name']; $form_email = $_post['email']; $query = 'select * subscribers name="' .$form_name. '";';  if($result = mysqli_query($con, $query)) {     if(mysqli_num_rows($result) == 0) {         $query = 'insert subscribers (name, email) values("'.$form_name.'","'.$form_email.'")';         if(mysqli_query($con, $query)) {             echo "registered";         }     } else {         echo "already exists";     } }  header('location: register.php'); ?>

the form on index.html file:

<form action="register.php" method="post"> name: <input type="text" name="name"><br> email: <input type="text" name="email"><br> <input type="submit" name="register" value="subscribe"> </form>

when press on subscribe button, redirects me register.php , not put in data in database.

i believe need try changing line

if($result = mysqli_query($con, $query)) { ...

to this

$result = mysqli_query($con, $query); if(mysqli_num_rows($result) == 0) {     $query = 'insert subscribers (name, email) values ("'.$form_name.'","'.$form_email.'")';

and sure delete } goes if-satement you'll deleting.


-

Popular posts from this blog

Apache NiFi ExecuteScript: Groovy script to replace Json values via a mapping file -

i working apache nifi 0.5.1 on groovy script replace incoming json values ones contained in mapping file. mapping file looks (it simple .txt): header1;header2;header3 a;some text;a2 i have started following: import groovy.json.jsonbuilder import groovy.json.jsonslurper import java.nio.charset.standardcharsets def flowfile = session.get(); if (flowfile == null) { return; } flowfile = session.write(flowfile, { inputstream, outputstream -> def content = """ { "field1": "a" "field2": "a", "field3": "a" }""" def slurped = new jsonslurper().parsetext(content) def builder = new jsonbuilder(slurped) builder.content.field1 = "a" builder.content.field2 = "some text" builder.content.field3 = "a2" outputstream.write(builder.toprettystring().ge...
Read more

node.js - How do I prevent MongoDB replica set from querying the primary? -

read-operations-only: is there way have mongodb replica set, make mongodb instance on box connected to, mongodb gets queried? i have 3 ec2 instances behind aws load balancer. on each ec2 instance runs mongodb, part of replica set. i have express endpoints on nodejs , connect replica set follows mongodb.mongoclient.connect('mongodb://1.1.1.1,2.2.2.2,3.3.3.3.', function (err, db) { if (err) { complete('{}'); } else { i distribute load of queries evenly across 3 instances of mongodb replica set instead of default having queries routed ec2 instance primary mongodb defined, because destroys point of load balancer (which balance load of queries across 3 instances evenly). my understanding when connecting mongodb replica set, primary instance selected unless primary instance down, , therefore purpose of every secondary instance serve backup. in example people call hot,cold,cold. because there 2...
Read more