Member Avatar
This question is similar to this [one](https://www.daniweb.com/programming/web-development/threads/371092/notice-undefined-index-id-on-line-26) However, my insert does not involve a form but a direct mysql query that looks like this $query2 = "insert into table(author,title,abstract) values(:author,:title,:abstract) "; $stm=$con->prepare($query2); $stm->bindValue(':author', $author, PDO::PARAM_STR); $stm->bindValue(':title', $title, PDO::PARAM_STR); $stm->bindValue(':abstract', $abstract, PDO::PARAM_STR); $stm->execute(); echo "$author &nbsp $title &nbsp $abstract <br>" In …
by Amaina 14 in Web Development ()
Member Avatar
I have this code session_start(); $username = $_SESSION['username']; function getUserRole($username, $roleid){ $con=dbConnect(); $query="select * from user inner join userrole on user.id = userrole.userid inner join role on role.id = userrole.roleid where username = $username"; $sql=$con->prepare($query); $sql->bindValue(':username',$username); $sql->bindValue(':roleid',$roleid); $sql->execute(); $row = $sql->fetch(); $username = $row['username']; $roleid = $row['roleid']; if($row > 0){ …
by Amaina 14 in Web Development ()
Member Avatar
Apparently I don’t know how to insert a row into a MySQL data base using PDP and I would like to know what I am missing This PHP PDO script does not insert data into a database. I would like to know why. It does not error out but the …
by rouse in Databases ()
Member Avatar
Im working on a small website and im a little confused on one step. I'm following a very simple mvc pattern, ive currently got one controller that creates a session array that holds all the posted data IF the form has been submitted, This data is coming from several different …
by spud91 in Web Development ()
Member Avatar
SEEMS AS IF MY ARTICLE HAS BEEN SUBMITTED TWICE. I DO APOLOGISE FOR THAT Hi guys, I'm working on a small website and I'm currently stuck on a small issue. Ive got a set of dropdown boxes created and populated in HTML, for example: <select name="heatingType" id="heatingType" required> <option value="" …
by spud91 in Web Development ()
Member Avatar
i have following code first insert is working properly and data in to database but second insert query which depends on last_insert_id() fails.I have tried to find out mistake but failed to do so? <?php namespace Solutions\File; class AddUserData { function __construct($DB_con) { $this->db = $DB_con; } public function insert_detail($productDetails){ …
by shany0786 8 in Web Development ()
Member Avatar
Hello, This tutorial is the next of “[A simple Data Layer for OOP PHP Applications](https://www.daniweb.com/programming/web-development/tutorials/500118/a-simple-data-layer-for-oop-php-applications)” so having read it and made your own tests is needed to understanding what we are doing. So far we have a Db object (child of PDO that standardize and simplifies its use) , a …
by jkon 451 in Web Development ()
Member Avatar
A simple Data Layer for OOP PHP Applications Hello, first of all to understand this tutorial would be best if you have some knowledges about OOP ( https://www.daniweb.com/programming/web-development/tutorials/437592/introduction-to-phps-object-orientation by priteas ) and DB usage (MySQL in this case) with PHP https://www.daniweb.com/programming/web-development/threads/499320/common-issues-with-mysql-and-php by diafol ). What we will try to achieve …
by jkon 451 in Web Development ()
Member Avatar
Hi I am trying to create a update function. But it not updating in the database. Please help me to fix. **Test-2.php** $whereString = ''; $bind = NULL; if(isset($_POST['Submit'])) { if($_POST) { $SCYQ64UKID = $_GET['SCYQ64UKID']; $SCYQ64AVGP = $_POST['SCYQ64AVGP']*100; $searchFields = array('SCYQ64EMAL'=>$_POST['SCYQ64EMAL'],'SCYQ64EV01'=>$_POST['SCYQ64EV01'],'SCYQ64EV02'=>$_POST['SCYQ64EV02'],'SCYQ64EV03'=>$_POST['SCYQ64EV03'],'SCYQ64EV04'=>$_POST['SCYQ64EV04'],'SCYQ64EV05'=>$_POST['SCYQ64EV05'],'SCYQ64EV06'=>$_POST['SCYQ64EV06'],'SCUSER'=>$_POST['SCUSER'],'SCYQ64AVGP'=>$SCYQ64AVGP,'SCYQ64TZ'=>$_POST['SCYQ64TZ'],'SCJOBN'=>gethostname(),'SCPID'=>'SSWEB','SCUPMJ'=>$_POST['SCUPMJ'],'SCUPMT'=>$_POST['SCUPMT']); if($post = array_filter($_POST)) { if($fields = array_intersect_key($searchFields, $post)) { …
by rpv_sen 59 in Web Development ()
Member Avatar
Hi I am trying to display count of a row using function with get values. Please help me to fix the issue **class** class Users { private $conn; private $db_name= "DATABASE"; public function __construct($db) { $this->conn = $db; } /*Join Two Tables with where condition and order by*/ public function …
by rpv_sen 59 in Web Development ()
Member Avatar
I have created a function. if i provide correct username and password. i am getting a error message as **Sorry, that username / password is invalid !** can any one please help me to fix the issue. **login.php** <?php require 'include/init.php'; $general->logged_in_protect(); if(empty($_POST) === false) { $username = trim($_POST['username']); $password …
by rpv_sen 59 in Web Development ()
Member Avatar
Hi I am trying to connection my database ODBC using function. I am getting an error **Connection error: could not find driver** **mycode is** <?php class Database{ // specify your own database credentials private $host = "servername"; private $db_name = "databsename.schemaname"; private $username = "username"; private $password = "password"; public …
by rpv_sen 59 in Web Development ()
Member Avatar
Hi there, I have a login form.which contains two input parameters. login_id and password. login_id may be mobile or email. user may use mobile no or email as login id. my table structure is uid email mobile password status when i login through mobile no it is validating and showing …
by praba_web in Web Development ()
Member Avatar
Hi Friends I am facing an issue in update query using PDO Prepare method. Please help me to fix the issue. $consql = "UPDATE $database.$constant_application SET SCYQ64EMAL=:SCYQ64EMAL, SCYQ64EV01=:SCYQ64EV01, SCYQ64EV02=:SCYQ64EV02, SCYQ64EV03=:SCYQ64EV03,SCYQ64EV04=:SCYQ64EV04, SCYQ64EV05=:SCYQ64EV05, SCYQ64EV06=:SCYQ64EV06, SCUSER=:SCUSER, SCJOBN=:SCJOBN, SCPID=:SCPID, SCYQ64AVGP=:SCYQ64AVGP, SCYQ64TZ=:SCYQ64TZ, SCUPMJ=:SCUPMJ, SCUPMT=:SCUPMT where SCYQ64CID=:SCYQ64CID"; $row = $dbh->prepare($consql); $row->bindParam(":SCYQ64EMAL",$SCYQ64EMAL); $row->bindParam(":SCYQ64EV01",$SCYQ64EV01); $row->bindParam(":SCYQ64EV02",$SCYQ64EV02); $row->bindParam(":SCYQ64EV03",$SCYQ64EV03); $row->bindParam(":SCYQ64EV04",$SCYQ64EV04); $row->bindParam(":SCYQ64EV05",$SCYQ64EV05); …
by rpv_sen 59 in Web Development ()
Member Avatar
I've been playing with PDO and got quite a shock, so I thought I'd run this past you all. I love PDO, and I thought that the "prepare once, execute many" idea behind prepared statements was beautiful. Now previous to using prepared statements, I used to build up a long …
by diafol 3,075 in Web Development ()
Member Avatar
how to put `where clause variable $didno` in following code: $pdo = Database::connect(); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $sql = "SELECT * FROM misscall WHERE did_no = ?"; $q = $pdo->query($sql); $mobile1 = array(); while ($mobi1 = $q->fetchColumn()) { $mobile1[] = $mobi1; } $mobile1list = join(",", $mobile1); Database::disconnect(); thanks in advance
by blueguy777 in Web Development ()
Member Avatar
Below is my database structure: PostUUID subid pricing Name Poscode abc1 1 100 userA 56000 abc2 2 100 userA 56000 abc3 1 100 userB 56000 abc4 2 100 userB 56000 abc5 1 100 userC 56000 abc6 2 100 userC 56000 Now I want to perform search on this table called …
by Kalaivani Nair in Databases ()
Member Avatar
I am trying to save 2 photos to my MySQL database. I can only see one of the 2 photos in the database (i.e. its name) but I see the 2 photos in the folder I store my photos. ( A picture of how the database looks like is attached.) …
by uchejava in Web Development ()
Member Avatar
Hello. I want to create a database on my pc localhost and then want to use PDO to connect with that database to creating table and so on... What should i do?
by Niloofar24 15 in Web Development ()
Member Avatar
Hello. I'm new to PHP, i've started it yesterday. I want to creat a simple CMS with (PHP and PDO), what should i do? I'm going to start with creating the CMS core. I want to create sth like a simple wordpress. What should i do? Where should i start …
by Niloofar24 15 in Web Development ()
Member Avatar
Hi, Please help me to resolve my Script Redirection problem. Actually i have developing simple crm application php using pdo->prepare. this is working fine in localhost. but what is my problem means redirection is not working, when i uploaded to server. for refernce i hereby attached . please help me …
by fireburner29 in Web Development ()
Member Avatar
Hi guys, I'm trying to connect my new project with PDO, and for simple reason witch i don't know and i've no idea i'm getting connection failedSQLSTATE[28000] [1045] Access denied for user 'www-data'@'localhost' (using password: NO) I tried everything was in my mind, i tried log to mySql by terminal, …
by hell hansen in Web Development ()
Member Avatar
Currently I have form with couple of fields and field for image. I have done with the part of field storing but don't know exactly how to store image path with PDO and can't find good tutorial. All I found was how to store image into DB instead of path. …
by JasonWung in Web Development ()
Member Avatar
i have a database table with fields mobno1 and mobno2, first i would like store all the values of field mobno1 into var1 and field mobno2 into var2 by using comma seperator and pdo. my code is as follows. $pdo = Database::connect(); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $sql = "SELECT mobno1,mobno2 FROM custreg"; …
by blueguy777 in Web Development ()
Member Avatar
Hi. so i have this div like so: ![d69e97a4413c033f6390ecaea54c6c8d](/attachments/large/4/d69e97a4413c033f6390ecaea54c6c8d.jpg "d69e97a4413c033f6390ecaea54c6c8d") see the "Add Spouse" link, when clicked will display another div: ![99b4077223bdea75c7de5b15af9b634b](/attachments/large/4/99b4077223bdea75c7de5b15af9b634b.jpg "99b4077223bdea75c7de5b15af9b634b") the edit spouse works by submitting the data wihtout refresh using `$.post`: $(document).ready(function(){ $("#submitSp").live("click", function() { var id = $("#contactid").val(); var ssalut = $("#spouse-salute").val(); var sfname = …
by nadiam in Web Development ()
Member Avatar
hello. i got this error and i have no idea why or what is going on. could someone explain in layman's term please and help me out. > Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'event_id' cannot be null' in /home/dhsbnet/public_html/ems/add_guest.php:36 Stack trace: #0 …
by nadiam in Web Development ()
Member Avatar
hi, i have an import csv script but it does not get entered into the database. only "uploaded successfully" and the data is echoed but nothing in the database is something wrong with it? and is it sql injection safe? <?php if(isset($_SESSION['sess_user_id'])) { if (isset($_POST['ubmit'])) { require "connection.php"; $session = …
by nadiam in Web Development ()
Member Avatar
how to convert this old fastioned mysql statements to pdo? <?php error_reporting(0); define("host","localhost"); define("user","root"); define("password",""); define("db","pass2"); $connect_db=mysql_connect(host,user,password) or die("cannot connect"); mysql_select_db(db, $connect_db); $username=strtolower(addslashes($_POST['username'])); $password=strtolower(addslashes($_POST['password'])); $sql="SELECT * FROM users WHERE username='$username' AND password='$password'"; $result=mysql_query($sql); $row=mysql_fetch_array($result); $count=mysql_num_rows($result); if($count==1 && $_POST['userlevel'] == "admin") { session_start(); $_SESSION['id']=$row['id']; header("location: admin.php"); } else if($count==1 && $_POST['userlevel'] …
by blueguy777 in Web Development ()
Member Avatar
<?php if(isset($_POST['login'])) { require 'connection.php'; include 'password.php'; $email = $_POST['email']; $password = $_POST['pass']; $query = $dbh->prepare("SELECT id,name,email,password FROM users WHERE email = :email"); $query->bindParam(':email', $email, PDO::PARAM_STR); $query->execute(); $userData = $query->fetch(PDO::FETCH_ASSOC); $userEmail = $userData['email']; $hash = $userData['password']; if(password_verify($password, $hash) && $email == $userEmail) { session_start(); $_SESSION['sess_user_id'] = $userData['id']; $_SESSION['sess_name'] = $userData['name']; …
by nadiam in Web Development ()
Member Avatar
I'm implementing something similar to a shopping cart - a "my favorites" page for products. Users can click on an "add to favorites" link and add products to a favorites table from which they can view the details of those products at a later time. There's no purchase on the …
by dhani09 3 in Web Development ()