Click here to Skip to main content
15,887,386 members
Home / Discussions / Linux, Apache, MySQL, PHP
   

Linux, Apache, MySQL, PHP

 
PinnedForum Guidelines - PLEASE READ PinPopular
Chris Maunder28-Jul-09 2:39
cofounderChris Maunder28-Jul-09 2:39 
Questionexample paypal payments Pin
vic5321-Mar-24 10:18
professionalvic5321-Mar-24 10:18 
Questionphp Pin
Dancane Odiwuor18-Dec-23 3:49
Dancane Odiwuor18-Dec-23 3:49 
AnswerRe: php Pin
Richard MacCutchan18-Dec-23 5:01
mveRichard MacCutchan18-Dec-23 5:01 
QuestionPHP 8.2 - Unsupported operand types: string * int Pin
Aruna KN13-Jun-23 19:48
Aruna KN13-Jun-23 19:48 
AnswerRe: PHP 8.2 - Unsupported operand types: string * int Pin
Richard MacCutchan13-Jun-23 21:10
mveRichard MacCutchan13-Jun-23 21:10 
AnswerRe: PHP 8.2 - Unsupported operand types: string * int Pin
Member 102471327-Mar-24 23:38
Member 102471327-Mar-24 23:38 
QuestionChoosing an editor Pin
jpaxtons9-Jun-23 9:48
jpaxtons9-Jun-23 9:48 
AnswerRe: Choosing an editor Pin
Deepak Vasudevan23-Aug-23 1:57
Deepak Vasudevan23-Aug-23 1:57 
QuestionFatal error: Uncaught Error: Call to a member function prepare() on null in Pin
Nicolas Veloso25-Apr-23 9:47
Nicolas Veloso25-Apr-23 9:47 
Hello, I get this error when updating or editing data in a "name" field, I leave this error in more detail: Fatal error: Uncaught Error: Call to a member function prepare() on null in C:\xampp\htdocs\pdo\conectar.php:46 Stack trace: #0 C:\xampp\htdocs\pdo\editar.php(20): Datos->setDatos('update candidat...') #1 {main} thrown in C:\xampp\htdocs\pdo\conectar.php on line 46


conectar.php:

PHP
<?php
class Conectar{
private $conn;
public function conectar(){
try{
$this->conn = new PDO("mysql:dbname=sistema\_votos;host=localhost", "root", "");
} catch(PDOException $error){
die("Error: ".$error);
}
return $this->conn;
}
public function setNames(){
return $this->conn->query("SET NAMES 'utf8'");
}
}
class Datos extends Conectar{
private $bd;
public function \_\_construct(){
$this->bd = self::conectar();
self::setNames();
}
public function getDatos($sql){
$datos = $this->bd->prepare($sql);
if (!$datos) {
echo "\\nPDO::errorInfo():\\n";
print\_r($this->bd->errorInfo());
die();
}
$datos->execute();
$this->bd=null;
return $datos->fetchAll();
}
public function getDato($sql){
$datos = $this->bd->prepare($sql);
$datos->execute();
$this->bd=null;
return $datos->fetch();
}
public function setDatos($sql){
$datos = $this->bd->prepare($sql);
$datos->execute();
//return $this->bd->lastInsertId();
}
}


editar.php

conectar.php:

<?php
class Conectar{
private $conn;
public function conectar(){
try{
$this->conn = new PDO("mysql:dbname=sistema\_votos;host=localhost", "root", "");
} catch(PDOException $error){
die("Error: ".$error);
}
return $this->conn;
}
public function setNames(){
return $this->conn->query("SET NAMES 'utf8'");
}
}
class Datos extends Conectar{
private $bd;
public function \_\_construct(){
$this->bd = self::conectar();
self::setNames();
}
public function getDatos($sql){
$datos = $this->bd->prepare($sql);
if (!$datos) {
echo "\\nPDO::errorInfo():\\n";
print\_r($this->bd->errorInfo());
die();
}
$datos->execute();
$this->bd=null;
return $datos->fetchAll();
}
public function getDato($sql){
$datos = $this->bd->prepare($sql);
$datos->execute();
$this->bd=null;
return $datos->fetch();
}
public function setDatos($sql){
$datos = $this->bd->prepare($sql);
$datos->execute();
//return $this->bd->lastInsertId();
}
}


I'm desperate, because I can't find the solution, add that I've tested the connection and with respect to that everything works fine, so it's not a connection problem.

AnswerRe: Fatal error: Uncaught Error: Call to a member function prepare() on null in Pin
Richard MacCutchan25-Apr-23 9:58
mveRichard MacCutchan25-Apr-23 9:58 
Question.htaccess Query String Redirect Pin
Aruna KN20-Apr-23 5:05
Aruna KN20-Apr-23 5:05 
QuestionPHP Warning: Attempt to read property "post_content" on null Pin
Aruna KN17-Apr-23 23:09
Aruna KN17-Apr-23 23:09 
AnswerRe: PHP Warning: Attempt to read property "post_content" on null Pin
Richard MacCutchan17-Apr-23 23:59
mveRichard MacCutchan17-Apr-23 23:59 
QuestionProper parameterised queries for database access Pin
Aruna KN11-Apr-23 6:35
Aruna KN11-Apr-23 6:35 
AnswerRe: Proper parameterised queries for database access Pin
Afzaal Ahmad Zeeshan11-Apr-23 10:11
professionalAfzaal Ahmad Zeeshan11-Apr-23 10:11 
GeneralRe: Proper parameterised queries for database access Pin
Aruna KN11-Apr-23 18:25
Aruna KN11-Apr-23 18:25 
GeneralRe: Proper parameterised queries for database access Pin
Richard MacCutchan11-Apr-23 21:52
mveRichard MacCutchan11-Apr-23 21:52 
GeneralRe: Proper parameterised queries for database access Pin
Aruna KN11-Apr-23 22:13
Aruna KN11-Apr-23 22:13 
GeneralRe: Proper parameterised queries for database access Pin
Richard MacCutchan11-Apr-23 22:29
mveRichard MacCutchan11-Apr-23 22:29 
GeneralRe: Proper parameterised queries for database access Pin
Aruna KN12-Apr-23 1:34
Aruna KN12-Apr-23 1:34 
QuestionPHP Fatal error: Uncaught mysqli_sql_exception Pin
Aruna KN10-Apr-23 4:47
Aruna KN10-Apr-23 4:47 
AnswerRe: PHP Fatal error: Uncaught mysqli_sql_exception Pin
Richard MacCutchan10-Apr-23 6:04
mveRichard MacCutchan10-Apr-23 6:04 
GeneralRe: PHP Fatal error: Uncaught mysqli_sql_exception Pin
Aruna KN10-Apr-23 6:41
Aruna KN10-Apr-23 6:41 
GeneralRe: PHP Fatal error: Uncaught mysqli_sql_exception Pin
Richard MacCutchan10-Apr-23 6:56
mveRichard MacCutchan10-Apr-23 6:56 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.