Improve company productivity with a Business Account.Sign Up

Solved

Php POSTGRES " IN SIDE " "

Posted on 2016-10-13

1 solution

Medium Priority

157 Views

Last Modified: 2016-10-25

this code is not work in postgres when I use macro
sc_exec_sql(" sql ") I think problem come from " inside " "

sc_exec_sql("  SELECT 
  pong8."Last", 
  pong8."Timestamp", 
  pong8."Trade Volume", 
  pong8."Bid Size", 
  pong8."Ask Size", 
  pong8."Best Ask"
FROM 
  public.pong8;
    ");

Open in new window

but this below i test it work (HOW CAN i FIX " iNSIDE " " )

SELECT 
  pong8."Last", 
  pong8."Timestamp", 
  pong8."Trade Volume", 
  pong8."Bid Size", 
  pong8."Ask Size", 
  pong8."Best Ask"
FROM 
  public.pong8;

Open in new window

Comment

Question by:teera

4 Comments

LVL 41

Expert Comment

by:Sharath

ID: 418430072016-10-13

try escaping them.

sc_exec_sql("  SELECT 
  pong8.\"Last\", 
  pong8.\"Timestamp\", 
  pong8.\"Trade Volume\", 
  pong8.\"Bid Size\", 
  pong8.\"Ask Size\", 
  pong8.\"Best Ask\"
FROM 
  public.pong8;
    ");

Open in new window

Author Comment

by:teera

ID: 418430442016-10-13

Parse error: syntax error, unexpected 'Timestamp' (T_STRING) in C:\Program Files (x86)\NetMake\v81\wwwroot\scriptcase\app\Pong8\blank\index.php on line 1079

sc_exec_sql("CREATE TABLE StepOneSection as
SELECT

public.pong8.\"Timestamp\",
public.pong8.\"Last\",
public.pong8.\"Trade Price\",
public.pong8.\"Trade Volume\",
public.pong8.\"Best Bid\",
public.pong8.\"Bid Size\",
public.pong8.\"Best Ask\",
public.pong8.\"Ask Size\",
public.pong8.\"Turnover\"
FROM
Public.pong8
") ;

Open in new window

LVL 41

Accepted Solution

by:Sharath

Sharath earned 2000 total points

ID: 418445992016-10-14

try this.

sc_exec_sql(' SELECT 
  pong8."Last", 
  pong8."Timestamp", 
  pong8."Trade Volume", 
  pong8."Bid Size", 
  pong8."Ask Size", 
  pong8."Best Ask"
FROM 
  public.pong8;
    ');

Open in new window

Author Closing Comment

by:teera

ID: 418583352016-10-25

thank you

Featured Post

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment Already a member? Login.

Database Solutions Engineer FAQs

Article by: Percona

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…

Features of Laravel Framework You Must Know About

Article by: Maulik

Laravel is the most sought after web development framework. It comes with ample amount of features that make it easy for developers to work around it. Know about its features in detail.

Using PHP to Count Item Occurrences in Arrays

Video by: Marco

The viewer will learn how to count occurrences of each item in an array.

Why Use Three Nodes in a Database Cluster?

Video by: Percona

In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…