php

Webservice error

i am new to webservices, I have created a basic stockmarket webservice, I have successfully created the server script for it and placed it in my server, Now I also creted a clent script and accessed it hruogh the same server.. Is it valid ? can boh files be accesed from the same server? or do I have to place them in different servers? If...

How to use where condition for the for a selected column using subquery?

I have two columns as company and product. I use the following query to get the products matching particular string... select id,(select name from company where product.cid=company.id) as company,name,selling_price,mrp from product where name like '$qry_string%' But when i need to list products of specific company how can i do? i t...

Basics of automated tests?

Hi, Till now I've been testing my web (usually written in PHP) as well as desktop applications (normally Java or C#) manually. Now I read somewhere on the net about automated tests. I tried searching to know about it in details but almost all searches end up at things like PHPUnit. Could someone please put some light on the theory behind...

PHP & MySQL - Deleting table rows problem.

Okay my script is supposed to delete a specific users case which is stored in 2 MySQL tables but for some reason when the user deletes the specific case it deletes all the users cases I only want it to delete the case the user selects. I was wondering how can I fix this problem? Thanks in advance for helping. Here is the PHP & MySQL cod...

Alternative to array_shift function

Ok, I need keys to be preserved within this array and I just want to shift the 1st element from this array. Actually I know that the first key of this array will always be 1 when I do this: // Sort it by 1st group and 1st layout. ksort($disabled_sections); foreach($disabled_sections as &$grouplayout) ksort($grouplayout); ...

Zendframework / PgSQL fetchAll orderby

i have a pgsql table with fields id, identifier, name. id serial NOT NULL, identifier character varying(16), name character varying(128) I want to fetchAll values from the table orderby identifier. but identifier is having values 12, 100, 200, 50 and after $table->fetchAll(null, 'identifier'); is giving the result 100, 12, ...

PHP DomDocument class unable access domnode

Hi. I dont parse this url: http://foldmunka.net $ch = curl_init("http://foldmunka.net"); //curl_setopt($ch, CURLOPT_NOBODY, true); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); //curl_setopt($ch, CURLOPT_HEADER, true); curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true); //not necessary unless the file redirects (like the PHP example we'r...

Equivalent of running $_SERVER['DOCUMENT_ROOT'] when running php in terminal

Hey all, I was wondering if there is some variable that will return what $_SERVER['DOCUMENT_ROOT'] returns when I call PHP like this: ./somescript If not, how do people get around this case? I'm looking to be able to call the same script (a template compiler) in both the web browser and the terminal. Thanks! Matt Mueller ...

How to send HTML email on new registration in DRUPAL 6?

I want to send the HTML email to new registered user. I am using Drupal 6. It has facility to send the mail to new registered user but the email is in only text format. But now how can i send the user mail in HTML format so that i can have some images and also some header - footer? Thanks in advance. Nitish Panchjanya Corporation ...

Echo certain value from smarty array

Hi, So currently I have an array with smarty.. {foreach from=$_sequences key=k item=v} Name => {$v.menu} Type => {$v.type} Step => {$v.pri} Data =>{$v.data} {/foreach} which gives me: Name => Test Type => Audio Step => 1 Data => audio1 Name => Test2 Type => Audio Step => 2 D...

How to display content of one site in another using PHP?

Hello I'm trying to show contents of two websites in one another , someone suggest me to use RSS reader but my question is : is there anything else i could try to show the contents , beside using rss !? i thought i can connect to the database of another website , but that didnt work / thanks in advance ...

Drupal, mysql server settings

hi, I've a problem to configure database settings in Drupal. I will propose here some sample data: Database Mysql: Database: databaseName User: user Password: password Server: server.com Server Choice: mysqldb2 (in phpmyadmin I have this option and I can choose between mysqldb1 and mysqldb2 to access to the mysql server) The error me...

In PHP + MySQL, How do I join many tables with conditions

Hi, I'm trying to get the users full activity throughout the website. I need to Join many tables throughout the database, with that condition that it is one user. What I currently have written is: SELECT * FROM comments AS c JOIN rphotos AS r ON c.userID = r.userID AND c.userID = '$defineUserID'; But What it is returning is ever...

Modify the server side functions using jquery

Hi, I am developing one website using cakephp and jquery technologies. Server-side there are some functions which handles sql queris. As per requirement I want to modify server side functions on client side using jquery AJAX call. E.g. : Below is the function on server side to modify users information. function modifyUser(username,us...

How to include CKeditor which is outside of your document root

Hi, Is it possible to use CKeditor which resides outside of your document root inside document root application? For e.g. I am having directory structure like: My Documentroot C://xampp/htdocs/example.com My CKeditor is outside and parallel to document root say C://xampp/lib/ckeditor How can I call ckeditor.js whi...

PHP regex extract date

i have $date variable 2009-04-29 which is Y-m-d anybody can give idea how to extract into $d, $m, $y using simplest method as possible? regex is preferable. any more suggestion with simple method will be chosen. :) ...

[PHP Array] - Sorting data and print out in alphabetic order

Hi all, I got an array which contains some data like this: $arrs = Array("ABC_efg", "@@zzAG", "@$abc", "ABC_abc") I was trying to print the data out in this way (Printing in alphabetic order): [String begins with character A] ABC_abc ABC_efg [String begins with character other than A to Z] @$abc @@zzAG I don't know how to do it. ...

How to activate php_mailparse.dll in xampp server

Hi, I am using xampp in windows. My 1.7.3 xampp server does not have php_mailparse.dll in php.ini. I tried to install it in all possible way but it gives module error. Now I have taken xampp 1.6.4 it does have php_mailparse.dll extension in php.ini file. I have configured it like below - extension=php_mbstring.dll extension=php_mailpa...

generate unix timestamp from last time

hi guys, suppose i have one column in mysql database which is stated last time one equipment is up in h:i:s format (ex: 00:05:11) or 1d21h, means that the equipment is on since 5 min before, what is the best method i can convert this to unix timestamp, say if using php script how? or direct convert last unix timestamp using mysql functi...

How to Pregreplace {number}) with \n{number})

How can i replace {number}) with \n{number}) Say i have something like this 1) test string testing new string. 2) that is also a new string no new line. 3) here also no new lines. The output should be something like this 1) test string testing new string. 2) that is also a new string no new line. 3) here also no new lines. How c...