mysql - Google Cloud SQL & PHP tutorial isn't editing database? -



mysql - Google Cloud SQL & PHP tutorial isn't editing database? -

i'm learning how utilize google cloud sql , trying connect database using php. i'm next google instructions here.

i created 3 files (guestbook.php, sign.php, , app.yaml) , copied code presented in article. in order connect database, used pdo_mysql variant.

in guestbook.php , sign.php, in if statement: replaced <your-project-id> , <your-instance-name> appropriate. left '' password empty.

in guestbook.php , sign.php, in else statement: replaced 127.0.0.1 , <password> appropriate. left 3306 is.

in app.yaml: replaced <your-application-name> appropriate.

i saved 3 files in local directory , deployed using googleappenginelauncher.

when loaded first page, looked fine. typed in , nail submit. got redirected page /guestbook, told:

error: not found requested url /guestbook not found on server.

i new web apps , php in general. have no thought error message asking me do. i've uploaded files google server using app launcher. i'm confident i've followed instructions closely.

some things i've tried doing:

in guestbook.php , sign.php, filled in '' appropriate password.

in guestbook.php , sign.php, deleted default 3306.

in guestbook.php , sign.php, deleted if statement , used content of else statement.

in app.yaml: added -url: /guestbook.

in guestbook.php , sign.php, switched pdo_mysql mysqli.

none of attempts above did solve problem. attempts 1 resulted in message unable connect..

edit:

in sign.php, changed header('location: '."/guestbook"); header('location: '."/");. seems have gotten rid of url not found error, seems nil in database beingness altered. php doing nil alter database.

what doing wrong? how can prepare problem , connect, read, , write database?

figured out. guestbook php code broken, plain , simple. seek redirect (using location header) after output , tags, illegal.

the result of is, if you're not logged in, code supposed redirect login page, doesn't. , when seek post invitee book, "$user" null, page fails.

oh yeah, , sign.php page redirects /guestbook, correctly identified doesn't exist. , redirects @ top of sign.php code, create code afterwards nothing. here's fixed code.

guestbook.php:

<?php utilize google\appengine\api\users\user; utilize google\appengine\api\users\userservice; $user = userservice::getcurrentuser(); if ($user === null) { header('location: ' . userservice::createloginurl($_server['request_uri'])); } ?> <html> <body> <h2>guestbook entries</h2> <?php // create connection. echo 'hello, ' . htmlspecialchars($user->getnickname()) . '<br>'; $db = null; if (isset($_server['server_software']) && strpos($_server['server_software'],'google app engine') !== false) { // connect app engine. try{ $db = new pdo(mysql:unix_socket=/cloudsql/<your-project-id>:<your-instance-name>;dbname=guestbook', 'root', ''); }catch(pdoexception $ex){ die(json_encode( array('outcome' => false, 'message' => 'unable connect.') ) ); } } else { // connect development environment. try{ $db = new pdo('mysql:host=127.0.0.1:3306;dbname=guestbook', 'root', '<password>'); }catch(pdoexception $ex){ die(json_encode( array('outcome' => false, 'message' => 'unable connect') ) ); } } seek { // show existing guestbook entries. foreach($db->query('select * entries') $row) { echo "<div><strong>" . $row['guestname'] . "</strong> wrote <br> " . $row['content'] . "</div>"; } } grab (pdoexception $ex) { echo "an error occurred in reading or writing guestbook."; } $db = null; ?> <h2>sign guestbook</h2> <form action="/sign" method="post"> <div><textarea name="content" rows="3" cols="60"></textarea></div> <div><input type="submit" value="sign guestbook!!"></div> </form> </body> </html>

and sign.php

<?php utilize google\appengine\api\users\user; utilize google\appengine\api\users\userservice; $user = userservice::getcurrentuser(); if (!$user) { die("not logged in"); } $db = null; if (isset($_server['server_software']) && strpos($_server['server_software'],'google app engine') !== false) { // connect app engine. try{ $db = new pdo('mysql:unix_socket=/cloudsql/<your-project-id>:<your-instance-name>;dbname=guestbook', 'root', ''); }catch(pdoexception $ex){ die(json_encode( array('outcome' => false, 'message' => 'unable connect.') ) ); } } else { // connect development environment. try{ $db = new pdo('mysql:host=127.0.0.1:3306;dbname=guestbook', 'root', '<password>'); }catch(pdoexception $ex){ die(json_encode( array('outcome' => false, 'message' => 'unable connect') ) ); } } seek { if (array_key_exists('content', $_post)) { $stmt = $db->prepare('insert entries (guestname, content) values (:name, :content)'); $stmt->execute(array(':name' => htmlspecialchars($user->getnickname()), ':content' => htmlspecialchars($_post['content']))); $affected_rows = $stmt->rowcount(); // log $affected_rows. } } grab (pdoexception $ex) { // log error. } $db = null; header('location: '."/"); ?>

php mysql google-app-engine google-cloud-sql

Comments

Post a Comment

Popular posts from this blog

Delphi change the assembly code of a running process -

Delphi change the assembly code of a running process - i'm trying alter address 00741fa5 has push test.009e721c . alter push test.009e71c8 . procedure callback; asm force $9e71c8 end; procedure tform2.btn1click(sender: tobject); var ppid :dword; pprocess : cardinal; begin getwindowthreadprocessid(findwindow(nil,pchar('test')), @ppid); pprocess := openprocess(process_all_access, false, ppid); injectasm(pprocess, $741fa5, 10, integer(@callback), 0); end; here injectasm function (with error checking) function injectasm(process: longword; injectaddress, injectsize, codeaddress, codesize : integer): pointer; var csize, rsize : integer; replaced : array of byte; jmp : array [0..4] of byte; jmpaddress : integer; nopv : byte; : integer; nbr: ulong_ptr; begin //injectsize must equal or greater 5, because need space our //(far) jmp wwxxyyzz instruction //if there's no space, inject in place of few instructions if injectsize ...
Read more

json - Hibernate and Jackson (java.lang.IllegalStateException: Cannot call sendError() after the response has been committed) -

json - Hibernate and Jackson (java.lang.IllegalStateException: Cannot call sendError() after the response has been committed) - hello have problem hibernate , jackson. have 2 pojos @entity @table(name = "users") public class user implements serializable { static final long serialversionuid = 4235637833262722256l; @id @generatedvalue private int id; @column(name = "creation_date") private date creationdate; @column(name = "first_name") private string firstname; @column(name = "last_name") private string lastname; @version @column(name = "version") private int version; @column(name = "e_mail") private string email; @column(name = "enabled") private boolean enabled; @column(name = "login") private string login; @column(name = "password") private string password; @jsonmanagedreference("role") @onetomany(mappedby = "user", cascade = cascadetype.all,fetch = fetchtyp...
Read more

C++ 11 "class" keyword -

C++ 11 "class" keyword - i've started using c++ 11 little bit more , have few questions on special uses of class keyword. know it's used declare class, there's 2 instances have seen don't understand: method<class t>(); and class class_name *var; why precede typename keyword class in first example, , keyword pointer in sec example? that known elaborated type specifier , necessary when class name "shadowed" or "hidden" , need explicit. class t { }; // love of god don't t t; t t2; if compiler smart, give these warnings: main.cpp:15:5: error: must utilize 'class' tag refer type 't' in scope t t2; ^ class main.cpp:14:7: note: class 't' hidden non-type declaration of 't' here t t; ^ if class not defined, deed forwards declaration. for example: template <typename t> void method() { using type = typename t::value_type; } method...
Read more