PDO equivalent mysql_num_rows with alert

Question

I have this code:

$pegaDados = mysql_query("SELECT * FROM curso WHERE cpf='$cpf'");

        if(mysql_num_rows($pegaDados) > 0){
          echo '<script type="text/javascript">alert("CPF já cadastrado em nosso Banco de Dados!");</script>';
        }
        else{

I want to transform it on PDO, but I'm facing problems. Can anyone help me?

I'm looking a solution on the web, I didn't find the "best" solution for it. Look my conection file below:

    <?php

define( 'MYSQL_HOST', '???' );
define( 'MYSQL_USER', '???' );
define( 'MYSQL_PASSWORD', '???' );
define( 'MYSQL_DB_NAME', '???' );

try
{
 $PDO = new PDO( 'mysql:host=' . MYSQL_HOST . ';dbname=' . MYSQL_DB_NAME, MYSQL_USER, MYSQL_PASSWORD, array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8'));
}

catch ( PDOException $e )
{
 echo 'Erro ao conectar com o MySQL: ' . $e->getMessage();
}

?>

Answer 1

Some database drivers with PDO have no natural row count function (rowCount() is only for INSERT, UPDATE or DELETE queries) , so you have to use another method. Here is what I use (EDIT :updated connection based on OP's information)

$sql = 'select * from table';
$data = $PDO->query($sql);
$rows = $data->fetchAll();
$num_rows = count($rows);

Then you can test:

if($num_rows > 0){
    // your code here
}

---

EDIT Updated code based on new information from OP:

$sql = "SELECT * FROM curso WHERE cpf = :cpf"; 
$stmt = $PDO->prepare( $sql ); 
$stmt->bindParam( ':cpf', $cpf ); 
$result = $stmt->execute(); 
$rows = $result->fetchAll(); 
$num_rows = count($rows);

Answer 2

I just changed the :cpf variable to $cpf, and it works!

<?php

require '../conexao.php';

$nome               =           addslashes ($_POST['nome']);
$foto               =           addslashes ($_POST['foto']);
$cpf                =           addslashes ($_POST['cpf']);
$rg                 =           addslashes ($_POST['rg']);
$email              =           addslashes ($_POST['email']);
$telefone           =           addslashes ($_POST['telefone']);
$endereco           =           addslashes ($_POST['endereco']);
$bairro             =           addslashes ($_POST['bairro']);
$cidade             =           addslashes ($_POST['cidade']);
$estado             =           addslashes ($_POST['estado']);
$observacoes        =           addslashes ($_POST['observacoes']);
$curso              =           addslashes ($_POST['curso']);

$newquery = "SELECT * FROM curso WHERE cpf = $cpf";

$data = $PDO->query($newquery);
$rows = $data->fetchAll();
$num_rows = count($rows);

if($num_rows > 0){
    echo '<script type="text/javascript">alert("CPF já cadastrado em nossa base de dados!");</script>';
}

else{

$sql = "INSERT INTO curso SET foto = :foto, nome = :nome, email = :email, cpf = :cpf, rg = :rg, telefone = :telefone, endereco = :endereco, bairro = :bairro, cidade = :cidade, estado = :estado, observacoes = :observacoes, curso = :curso";

$stmt = $PDO->prepare( $sql );
$stmt->bindParam( ':foto', $foto );
$stmt->bindParam( ':nome', $nome );
$stmt->bindParam( ':email', $email );
$stmt->bindParam( ':cpf', $cpf );
$stmt->bindParam( ':rg', $rg );    
$stmt->bindParam( ':telefone', $telefone );
$stmt->bindParam( ':endereco', $endereco );
$stmt->bindParam( ':bairro', $bairro );
$stmt->bindParam( ':cidade', $cidade );
$stmt->bindParam( ':estado', $estado );
$stmt->bindParam( ':observacoes', $observacoes );
$stmt->bindParam( ':curso', $curso );
$result = $stmt->execute();

echo '<script type="text/javascript">alert("Matrícula realizada com sucesso!");</script>';
echo "<script>window.location = 'https://pag.ae/bck57zw';</script>";

}

?>

Answer 3

You should try this one

$sql = "SELECT * FROM curso WHERE cpf='$cpf'";
$pegaDados = $con->prepare($sql);
$pegaDados->execute();
if($pegaDados->rowCount() > 0){
    echo '<script type="text/javascript">alert("CPF já cadastrado em nosso Banco de Dados!");</script>';
}

$con is your database connection.