PHP Code not work in PHP CLI

Question

i made php code with database connection named test.php like below :

<?
$mysqli = new mysqli("localhost","root","","monster");

/* check connection */
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

/* return name of current default database */
if ($result = $mysqli->query("INSERT INTO `earth` (`monster_id`, `type`, `name`) VALUES
(NULL, 'defender', 'tortoise')
")) {
    $row = $result->fetch_row();
    printf("Default database is %s.\n", $row[0]);
    $result->close();
}
$mysqli->close();
?>

it works when i call via browser http://localhost/learn/test.php and data inserted to my database

but when i running in PHP CLI

php -r '    $mysqli = new mysqli("localhost","root","","monster");

    /* check connection */
    if (mysqli_connect_errno()) {
        printf("Connect failed: %s\n", mysqli_connect_error());
        exit();
    }

    /* return name of current default database */
    if ($result = $mysqli->query("INSERT INTO `earth` (`monster_id`, `type`, `name`) VALUES
    (NULL, 'defender', 'tortoise')
    ")) {
        $row = $result->fetch_row();
        printf("Default database is %s.\n", $row[0]);
        $result->close();
    }
    $mysqli->close();'

no data inserted. update now i tes to eval($code); seems OKAY in windows but not in LINUX

The syntax highlighter seems to think you have a quote escaping issue.. — Ben
– Ben, Commented Jan 29, 2014 at 9:30
now i tes to eval($code); seems OKAY in windows but not in LINUX — BaloonBang
– BaloonBang, Commented Jan 30, 2014 at 9:12

NLSaini · Accepted Answer · 2014-01-29 09:22:07Z

1

try this

php -r '    $mysqli = new mysqli("localhost","root","","monster");

    /* check connection */
    if (mysqli_connect_errno()) {
        printf("Connect failed: %s\n", mysqli_connect_error());
        exit();
    }

    /* return name of current default database */
    if ($result = $mysqli->query("INSERT INTO `earth` (`monster_id`, `type`, `name`) VALUES
    (NULL, \'defender\', \'tortoise\')
    ")) {
        $row = $result->fetch_row();
        printf("Default database is %s.\n", $row[0]);
        $result->close();
    }
    $mysqli->close();'

answered Jan 29, 2014 at 9:22

NLSaini

2571 silver badge10 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

NLSaini Over a year ago

change (NULL, \'defender\', \'tortoise\') to (NULL, \"defender\", \"tortoise\")

sobyte · Accepted Answer · 2014-01-29 09:20:45Z

0

I guess you have kind of a syntax error there. You're starting your php code with ' and at the INSERT INTO statement you're wrapping your values also with '. Maybe that's the problem?

answered Jan 29, 2014 at 9:20

sobyte

963 bronze badges

Comments

Hamza · Accepted Answer · 2014-01-29 09:30:20Z

0

Try this

php -r '    $mysqli = new mysqli("localhost","root","","monster");

/* check connection */
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}
$type="defender";
$name="tortoise";
/* return name of current default database */
if ($result = $mysqli->query("INSERT INTO `earth` (`monster_id`, `type`, `name`) VALUES
(NULL, $type, $name)")) 
{
    $row = $result->fetch_row();
    printf("Default database is %s.\n", $row[0]);
    $result->close();
}
$mysqli->close();'

answered Jan 29, 2014 at 9:30

Hamza

1,5932 gold badges19 silver badges31 bronze badges

Collectives™ on Stack Overflow

PHP Code not work in PHP CLI

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related