Attachment 902483 Details for Bug 1104955 – mysql.php file

mysql.php file

mysql.php (text/plain), 1022 bytes, created by Yan Du on 2014-06-05 10:46:54 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Yan Du

Created: 2014-06-05 10:46:54 UTC

Size: 1022 bytes

patch

obsolete

><?php
>    header('Content-Type: text/plain');
>    $con = mysql_connect(getenv("OPENSHIFT_MYSQL_DB_HOST").":".getenv("OPENSHIFT_MYSQL_DB_PORT"), getenv("OPENSHIFT_MYSQL_DB_USERNAME"), getenv("OPENSHIFT_MYSQL_DB_PASSWORD")) or die(mysql_error());
>mysql_select_db(getenv("OPENSHIFT_APP_NAME"), $con);
>
>    mysql_query("CREATE TABLE IF NOT EXISTS factory(id INT UNSIGNED NOT NULL, data TEXT, PRIMARY KEY(id));", $con);
>    mysql_query("COMMIT", $con);
>    $result = mysql_query("SELECT * from factory;", $con);
>    $num = mysql_num_rows($result);
>    if($num == 0) {
>        mysql_query("INSERT INTO factory VALUES(1, '1');", $con);
>    }
>    if(empty($_GET["version"])) {
>        $result = mysql_query("SELECT * from factory;", $con);
>        $row = mysql_fetch_array($result);
>        echo "version " . $row[1];
>    } else {
>        mysql_query("UPDATE factory SET data=".$_GET["version"]." WHERE id=1;" , $con);
>        echo "The mysql factory is modified";
>    }
>    mysql_query("COMMIT", $con);
>    mysql_close($con);
>?>

Actions: View

Attachments on bug 1104955: 902483