English 中文(简体)
在我准备的发言中,我与公共卫生与住房与住房与住房与住房与住房部一道,做了一些错误的事情。
原标题:something wrong with my prepared statement SQL query with PHP

I get the errors:

通知:不确定变量:C:xampphtdocssqltest.php第18行

致命错误: 第18行:C:xampphtdocssqltest.php

我使用该代码。 我如何防止在PHP中投放甲 SQL?

我完全是PDO和这种东西的新鲜事,在我手工艺的服务器上,它使用S-35.3。

我只是对此进行测试,我知道我没有采用良好的编码做法。

我的法典:

     $con = mysql_connect("localhost","root","") or die( error );
    mysql_select_db("safe",$con);


    if(isset($_POST[ lastinput ])){
    $prepared = $db->prepare( SELECT * FROM data WHERE last = :last );
    $prepared->execute(array( :last  => $_POST[ lastinput ]));

    $rows = $prepared->fetchAll();
    echo $rows[ first ];
    }
    mysql_close($con);
问题回答

使用<代码>$db->......的例子正在使用既定的PDO链接<>。 您没有建立PDO链接,因此也永远不会创建可变的<代码>db。 请从手册开始:





相关问题
SQL SubQuery getting particular column

I noticed that there were some threads with similar questions, and I did look through them but did not really get a convincing answer. Here s my question: The subquery below returns a Table with 3 ...

难以执行 REGEXP_SUBSTR

I m 查询Oracle 10g。 我有两张表格(样本数据见下文)。 i m 试图提取一些领域

SQL Query Shortcuts

What are some cool SQL shorthands that you know of? For example, something I learned today is you can specify to group by an index: SELECT col1, col2 FROM table GROUP BY 2 This will group by col2

PHP array callback functions for cleaning output

I have an array of output from a database. I am wondering what the cleanest way to filter the values is example array Array ( [0] => Array ( [title] => title 1 ...

OracleParameter and DBNull.Value

we have a table in an Oracle Database which contains a column with the type Char(3 Byte). Now we use a parameterized sql to select some rows with a DBNull.Value and it doesn t work: OracleCommand ...

Running numbers in SQL

I have a SQL-statement like this: SELECT name FROM users WHERE deleted = 0; How can i create a result set with a running number in the first row? So the result would look like this: 1 Name_1 2 ...

How to get SQL queries for each user where env is production

I’m developing an application dedicated to generate statistical reports, I would like that user after saving their stat report they save sql queries too. To do that I wrote the following module: ...

热门标签