I'm putting my club's membership database online.
I have a Member table in the database with fields such as FirstName, LastName etc. I have a web form with matching input variables Member_FirstName, Member_LastName that's going to be used for inserting a new member into the database, so I'll be populating an SQL statement such as
My plan was to have a set of intermediate variables
so that I could have a pre built SQL statement that would simply substitute the intermediate variables.
OK - that's the background...now the question is, how do I generate the intermediate variables in a loop of column names.
So in pseudo code...
I've been trying to use 'eval()' but can't get the syntax correct, so any views on correct syntax or a better/alternative way to do this appreciated.
eval is evil. You'd spend more code on trying to prevent security problems than anything else, and even then there'd probably be (more than) a few left.
Brilliant - thanks pludi. I thought I'd tried this previously and couldn't get it working, so eval was a clutch at straws. The description and example on the link were invaluable.
greetings,
pretty new to php and i think i might be missing some fundamental limitation of isset. i have two php scripts below that are executed by crond, one using --host X and one that does not. and below that are three different attempts at generating a command line that will be executed. the... (8 Replies)
Hi All,
i have a requirement where i have to run a script with at least 25 arguements and position of arguements can also change. the unapropriate way is like below. can we achieve this in more good and precise way??
#!/bin/ksh
##script is sample.ksh
age=$1
gender=$2
class=$3
.
.
.... (3 Replies)
I have made a script that requires another php script for functions.
I need a way so that the required script can read and write the main script's variables.
Best Regards, John Wei
---------- Post updated at 08:54 AM ---------- Previous update was at 08:40 AM ----------
Sorry Guys, EDIT: my... (1 Reply)
Hello everyone,
I've been looking how to pass variables between bash and php-cli in 1 file. So far i got this:
#!/bin/bash
echo "This is bash"
php << EOF
<?php
echo "This is php\n";
?>
EOF
I would now like to be able to pass a variable declared in the bash to the php. I already... (0 Replies)
Hi everybody, I need the help of the Unix community once again :)
I have some code which queries an XML feed and displays the results for me. I would like to enter the XML output in to my database, but I am having trouble passing the variables while INSERTing.
Here is my code that I need to... (0 Replies)
Dear All,
I have one problem in my script, awk statement as
1. it is not evaluate the second variable $stake but the first one $channel is being done.
2.I want to assign the whole awk statement to a variable actual_code which is not being executed in my script.
#!/usr/bin/sh
echo "Enter... (3 Replies)
Hello everybody,
I am having problem in converting byte array variables to Hexa String variables for Linux. I have done, converting byte array variables to Hexa String variables for Windows but same function doesn't work for linux. Is there any difference in OS ? The code for Windows is given... (2 Replies)
Hello,
Could you please let me know what is the problem here..
28:var1="SERVER_$j"
29:eval $var1=`grep "^DBSERVER=" "$i" |cut -d"=" -f2`
i get this error:
syntax error at line 29 : `|' unexpected
Thanks for your quick response..This is urgent..pls..
Regards
Kaushik (5 Replies)
Say I write something like the following:
var1=1
var2=2
for int in 1 2
do
echo "\$var$int"
done
I want the output to be:
1
2
Instead I get something like:
$var1
$var2 (2 Replies)