javascript and php

chintupintu03

Hi all,

Here is my problem.

I am using onclick method to perform some statements.

The function is :

function func_update_values()
{
var act_counting = '<?php echo mysql_num_rows(mysql_query("SELECT * FROM members_m")) ; ?>' ;

alert ( "count obtained " ) ;
alert ( act_counting) ;

}

The above part works fine and displays the result obtained by query.

Now my problem is,

Similar to above query, if I want to delete some records from one table and update rows in another, how it is to be carried out ?

I have tried with statement like ;

'<?php mysql_query("DELETE FROM member_activity_r WHERE member_id = user_id") ; ?>' ;

/ user_id is taken by executing another query within function /

This statement does not work.

therealairness

have u tried using "$user_id" instead?

chintupintu03

Hi therealairness,

I am taking the user ID as :
var user_id = '<?php echo $HTTP_SESSION_VARS["ses_cid"]; ?>' ;

so it has to be "user_id" in the query and not "$user_id", isn't it?

I am trying to display the result for checking as :

var del_rec = '<?php echo mysql_query("DELETE FROM member_activity_r WHERE contact_id = user_id"); ?>' ;

alert ( "DEL REC " ) ;
alert (del_rec) ;

It does not show value for del_rec. Whereas for

var quote = '<?php echo mysql_num_rows(mysql_query("SELECT * FROM activity_m")); ?>';
alert ( " QUOTE " ) ;
alert ( quote) ;

This shows the count of rows returned by the query.

Is it that, query returning single row can be processed and query involving multiple rows does not support ?

Can anybody help me further? Is there any other way to solve this problem?

doorman

<?php mysql_query("DELETE FROM member_activity_r WHERE member_id = " . user_id ) ; ?>

therealairness

How about if go like this?

<?php $user_id = $HTTP_SESSION_VARS["ses_cid"]; ?>

var del_rec = '<?php echo mysql_query("DELETE FROM member_activity_r WHERE contact_id = $user_id "); ?>' ;

alert ( "DEL REC " ) ;
alert (del_rec) ;

chintupintu03

Hi therealairness and doorman,

I tried with the following statements within my function.

<?php $user_id = $HTTP_SESSION_VARS["ses_cid"]; ?>

var del_rec = '<?php echo mysql_query("DELETE FROM member_activity_r WHERE contact_id = $user_id "); ?>' ;

It dies not show the value of $user_id.

But what happens is, all the records are deleted as soon as the program is executed. How the statements within the function are executed before invoking the function. [ The function I am calling through "Onclick" of a button ]

doorman

Yeah sorry, I posted before I looked close enough to see what your code was really doing.

when its being parsed, the parser recognised the php tags and executes your code, the fact that its in a string you are trying to assign to a javascript variable doesnt matter. The result of the execution is stored in your variable. The alert simply prints out the result that was created as the page was generated.

therealairness

You session variable must blank or session variable does not exist check your typo. You can try the following after the delete.

var err_mes = '<?php echo mysql_error(); ?>' ;

alert ( "ERR_MES" ) ;
alert (err_mes) ;

It will display the error message. You can also display the session variable. It will give you an idea what is going on. By the way, did u start the session on this page.

Moonglobe

you can't do that. you're trying to access a javascript variable from PHP, but at the time the PHP is run, the JS hasnt been interpreted yet, or even been sent to the client.

so just change

 var user_id = '<?php echo $HTTP_SESSION_VARS["ses_cid"]; ?>' ;

 <?php $user_id = $HTTP_SESSION_VARS["ses_cid"]; ?>

and then just do

'<?php mysql_query("DELETE FROM member_activity_r WHERE member_id = $user_id") ; ?>' ;

see what i mean?

chintupintu03

Hi therealairness and doorman,

The user_id gets assigned through the statement :

<?php $user_id = $HTTP_SESSION_VARS["ses_cid"]; ?>

The major problem is deleting the rows for this user_id and insert new rows based on criteria, within javascript.

How to check the statement ( query formed within mysql_query ) :

var del_rec = '<?php echo mysql_query("DELETE FROM member_activity_r WHERE contact_id = $user_id "); ?>' ;

doorman

Any php in your page will be executed by the server and the results sent as the web page.

If you want to deal with the database in some way using php based on the results of some javascript, then you will have to POST those results to the server.

The alert statement can only print a string. do a view source from your browser and you will see what i mean.

Please don't be offended by this, but it sounds like you don't understand the difference between server side and client side programming.