Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by gglgokop1704
-
how can i insert data into a table in postgresql database
Hi Jpadie, Thank you very very much. It works fine when I changed from int8[] and float8[] to numeric and text[]to varchar. All this while it has been a postgres proiblem and not the script you gave me. This is the message: Database Record inserted correctly thanks very much again Gokop- gglgokop1704
- Post #35
- Forum: PHP
-
how can i insert data into a table in postgresql database
Hi, I changed the criteria_parameters to Criteria_Parameters and see the error: Warning: pg_query(): Query failed: ERROR: relation "criteria_parameters" does not exist in /var/www/html/newconnection.php on line 61 Problem inserting database record. Error was ERROR: relation...- gglgokop1704
- Post #32
- Forum: PHP
-
how can i insert data into a table in postgresql database
Hi Jpadie, My first postgres table was Criteria_Parameters and columns were 'CriteriaID', 'DomainID', 'Criteria_Name', 'Upper_Lim', 'Lower_Lim', 'Range', 'Unit'. But after running the php script it complains. I went through the postgres documentation and I saw that the script converts all names...- gglgokop1704
- Post #31
- Forum: PHP
-
how can i insert data into a table in postgresql database
In postgres, I declared the table fields data types as: criteriaid as int8[] domainid as int8[] criteria_name as text[] upper_lim as float8[] lower_lim as float8[] range as float8[] unit as text[] Has this got anything to do with the error. Anyway they were declaed as int8, float8 and text...- gglgokop1704
- Post #29
- Forum: PHP
-
how can i insert data into a table in postgresql database
Hi, It gave this error: Warning: pg_query(): Query failed: ERROR: array value must start with "{" or dimension information in /var/www/html/newconnection.php on line 62 Problem inserting database record. Error was ERROR: array value must start with "{" or dimension information in line 62 i.e...- gglgokop1704
- Post #28
- Forum: PHP
-
how can i insert data into a table in postgresql database
By commenting the $fields = implode (" , ", $fields); below foreach and above $query, I got: Warning: pg_query(): Query failed: ERROR: syntax error at or near "Array" at character 34 in /var/www/html/newconnection.php on line 62 Problem inserting database record. Error was ERROR: syntax error...- gglgokop1704
- Post #26
- Forum: PHP
-
how can i insert data into a table in postgresql database
Hi Thanks, Without changing anything, I got: Warning: implode(): Bad arguments. in /var/www/html/newconnection.php on line 51 Warning: implode(): Bad arguments. in /var/www/html/newconnection.php on line 51 Warning: implode(): Bad arguments. in /var/www/html/newconnection.php on line 51...- gglgokop1704
- Post #25
- Forum: PHP
-
how can i insert data into a table in postgresql database
Hi Jpadie, See the codes: <?php //set the debug parameters ini_set('display_errors','on'); error_reporting (E_ALL); //start the motor switchboard(); function switchboard(){ if (isset($_POST['submit'])){ processForm(); } displayForm(); } function displayForm(){ echo...- gglgokop1704
- Post #23
- Forum: PHP
-
how can i insert data into a table in postgresql database
You have done so well Jpadie. I did that and got this error: Warning: implode(): Bad arguments. in /var/www/html/newconnection.php on line 50 Warning: implode(): Bad arguments. in /var/www/html/newconnection.php on line 50 Warning: implode(): Bad arguments. in /var/www/html/newconnection.php...- gglgokop1704
- Post #21
- Forum: PHP
-
how can i insert data into a table in postgresql database
Yes that solves the problem also. I got some errors such as criteria_parameters relations, but I solved them. The error is : Warning: pg_query(): Query failed: ERROR: array value must start with "{" or dimension information in /var/www/html/newconnection.php on line 60 Problem inserting...- gglgokop1704
- Post #19
- Forum: PHP
-
how can i insert data into a table in postgresql database
Itried to comment the is_binary and leave the is_string. I got this error: Warning: pg_query(): Query failed: ERROR: array value must start with "{" or dimension information in /var/www/html/newconnection.php on line 60 Problem inserting database record. Error was ERROR: array value must start...- gglgokop1704
- Post #18
- Forum: PHP
-
how can i insert data into a table in postgresql database
Thanks again, Error reduced to: Fatal error: Call to undefined function: is_binary() in /var/www/html/newconnection.php on line 71 Regards Gokop- gglgokop1704
- Post #16
- Forum: PHP
-
how can i insert data into a table in postgresql database
Hi Jpadie, Thanks. At least I saw errors now with this change in the input button type. See errors displayed on the browser: Warning: Invalid argument supplied for foreach() in /var/www/html/newconnect.php on line 49 Notice: Undefined variable: dbValues in /var/www/html/newconnect.php on line...- gglgokop1704
- Post #14
- Forum: PHP
-
how can i insert data into a table in postgresql database
Hi Jpadie, It looks ok, however it does not insert data into the table. I have even granted insert, select, udate priviledges to the globus user. I will try working on configurations in httpd.conf and php.ini and see what happens. Thanks for your great help. Gokop- gglgokop1704
- Post #12
- Forum: PHP
-
how can i insert data into a table in postgresql database
The two files are kept in the /var/www/html/ path. I access them through http://host/criteria.htm- gglgokop1704
- Post #10
- Forum: PHP
