Shabalaka
-
Posts
2 -
Joined
-
Last visited
Never
Posts posted by Shabalaka
-
-
First off i would like to say thanks to all who read this post fully.
Hi Guys i been trying to do this for days but i cant seem to work it out, So im posting here in the hope that someone can help me.
What i have is 3 forms with all different amounts of textareas to paste content into and each line of content will correspond to the next ones to create one row of data per line in each textarea.
I know i have to use explode function to break all the data down by the delimiter which i have done.
The PHP Code i have at the moment is this.
// I,m passing all the POST vars because ideally i would like this function to be dynamic and build the SQL statement from all the field names , No MYSQL injection protection during testing plan to add later function dataformat($_POST){ // This example will receive the following variables. ( [0] => title [1] => fname [2] => lname [3] => email [4] => submit ) these field names match the db table names. // The KEYS SENT BY POST IE THE FIELD NAMES. $columns = array(); // The COrresponding VALUES FOR THE FIELDS. $rows = array(); $i = 0; foreach ($_POST as $key=>$value){ //Push the field name into the keys array array_push($columns,$key); array_push($rows,$value); } foreach($rows as $keys=>$values){ //create the array values $values = explode("\r\n",$values); echo "<br>"; print_r($values); echo "<br>"; echo "<br>"; echo "Columns : ".count($columns)."<Br>"; echo "Values : ".count($values)."<br>"; echo "Rows : ".count($rows[1])."<br>"; echo "<br>"; echo $columns; } // Pop the 2 submits off of rows and columns. array_pop($columns); array_pop($rows); }
TThe output from this code looks like this
Array ( [0] => Mr [1] => Miss [2] => Mr )
Columns : 5
Values : 3
Rows : 1
Array
Array ( [0] => Test [1] => Alice [2] => Joe )
Columns : 5
Values : 3
Rows : 1
Array
Array ( [0] => Admin [1] => Wonderland [2] => Bloggs )
Columns : 5
Values : 3
Rows : 1
Array
Array ( [0] => test@test.com [1] => alice@wonderland.com [2] => joe@bloggs.com )
Columns : 5
Values : 3
Rows : 1
Array
Array ( [0] => Submit )
Columns : 5
Values : 1
Rows : 1
Array
Now as you can see all the details for one user is in each array value ie..
Mr Test Admin has the Email test@test.com inside the [0] elements of each array.
and [1] is a new user
and element 2 is another users name and emails.
Ideally what i would like to achieve is a looped dynamic SQL which will take these elements and build an SQL statement to input them as seperate rows in the database.
Any help would be appreciated thanks
Regards Shab
Is it possible to call a method twice in a automated script?
in PHP Coding Help
Posted
Hi Guys
Im having a problem with a couple of methods in my class.
This class reads a CSV file and the iterates each line and seperates all the values into an array which we manipulate later on.
These are the 2 methods im trying to get running.
Now whats happening is it will run once and insert the new Domain Name but then when i try to run GetID again it wont do it , If i run the script a second time it does enter the new target name and then eventually if i run script a 3rd time i will recieve the output im looking for :S
I would just like to add that im trying to run the Method GetID Twice so i have no need to call it twice in the PHP page as it runs it automatically, Im relatively new to OOP php so am trying to design a few "automated" classes to perform things.
My thinking is that once GetID has run once it goes back to the break_domains function and trys to run that next GetID
Many Thanks for any replys