javascript - Having trouble in sending the results from pdo to ajax -
i want if user registered pdo provide info , send ajax , ajax message if user registered or not. working after set status in pdo , wont insert no more , ajax tells "error registering user!" time.
script:
<script type="text/javascript"> $(document).ready(function() { $('#submit').click(function (e) { e.preventdefault(); var info = {}; data.name = $('#name').val(); data.age = $('#age').val(); data.gender = $('#gender').val(); data.address = $('#address').val(); data.image = $('#imginp').val(); $.ajax({ type: "post", url: "user.php", data: data, cache: false, success: function (response) { if (number(response) == 1) { alert("user registered"); } else { alert("error registering user!"); } } }); homecoming false; }); }); </script>
user.php:
<?php $host = "localhost"; $user = "root"; $pass = ""; $db = "test"; $dbc = new pdo("mysql:host=" . $host . ";dbname=" . $db, $user, $pass); $dbc->setattribute(pdo::attr_errmode, pdo::errmode_exception); $name = @$_post['name']; $age = @$_post['age']; $address = @$_post['address']; $gender = @$_post['gender']; $imagename = @$_files['image']['name']; $q = "insert students(name, age, address, gender, imagename ) values(:name, :age, :address, :gender, :image)"; $query = $dbc->prepare($q); $query->bindparam(':name', $name); $query->bindparam(':age', $age); $query->bindparam(':address', $address); $query->bindparam(':gender', $gender); $query->bindparam(':image', $imagename); $results = $query->execute(); $results ? echo "1"; : echo "2"; ; ?>
it seems have error in :
$results ? echo "1"; : echo "2"; ;
yours demo
try :
echo $results ? "1" : "2";
working demo
you can see here tutorial.
javascript php jquery ajax pdo
No comments:
Post a Comment