Miko
-
Posts
131 -
Joined
-
Last visited
Never
Everything posted by Miko
-
hmm, I was talking to fast. when I echo the var $implode I don't get the exact result. function implodeId($test){ foreach($test as $name){ $sql = "SELECT * FROM categories WHERE name = '$name' "; $query = mysql_query($sql); $row = mysql_fetch_array($query); $id = $row['id']; $array = array($id); $implode = implode(",", $array); echo $implode; } } instead of having for ex: 1,2 I have 12
-
off course! d'oh! function implodeId($test){ foreach($test as $name){ $sql = "SELECT * FROM categories WHERE name = '$name' "; $query = mysql_query($sql); $row = mysql_fetch_array($query); $id = $row['id']; $array = array($id); $implode = implode(",", $array); } } now it works, thanks!
-
Hi, I have a function needs to implode several ID from a DB: my code: <?php require("config.php"); class insert_Title { function implodeId($test){ foreach($test as $name){ $sql = "SELECT * FROM categories WHERE name = '$name' "; $query = mysql_query($sql); $row = mysql_fetch_array($query); $id = $row['id']; $implode = implode(",", $id); echo $id; } } } $test = $_POST['test']; $submit = $_POST['submit']; if(isset($submit)){ $get_id = new insert_Title(); $exec = $get_id->implodeId($test); } ?> <form name="myForm" action="<?php $_SERVER['PHP_SELF'] ?>" method="post"> <input type="checkbox" name="test[]" value="Movies" />Movies<br /> <input type="checkbox" name="test[]" value="Manga" />Manga<br /> <input type="submit" name="submit" value="Go!" /> </form> I'm getting this error: Warning: implode() [function.implode]: Invalid arguments passed in D:\xampp\htdocs\scripts\implode.php on line 15 but when I make the function without a query inside it will work...
-
hello, I'm creating a form where there are a few radio buttons and checkboxes. I have a MySQL database, in there there is a table with "Main Categories" and another table for "Sub Categories". Now the radio buttons are for the main categories and the checkboxes for the sub categories. The goal is that when a user goes to the page that has the form he should see first the radio buttons with the main categories, once he have selected one of those the checkboxes with the sub categories should be shown below. To get the data from the mysql db I'm using PHP scripting, there is no problem, my script works, but it is the java part that I'm stuck now Does anyone knows how I must code the above 'function'? Thanks!
-
sorry, but just as I told already, I'm a beginner in oop php. I don't know what the 'interface' even do, same thing with 'implements' i'm not getting any further
-
thanks for the answer, but I'm just a beginner in oop php. Most of the codes that you have written are still unknown to me. and it is a lot of code for the thing I need o_O. I just wanted to fetch data from my sql db by using a seperate file(functions.php) from my index.php.
-
index.php: <?php require_once("functions.php"); ?> <html> <head> <title>Test Functions</title> </head> <body> <?php $names = new Person(); $names->get_name(); $names_array = $names->get_name(); ?> <table> <tr> <?php foreach($names_array as $x){ echo "<td>".$x."</td>"; } ?> </tr> </table> </body> </html> functions.php: <?php require_once("config.php"); class Person{ private $names = array(); function get_name(){ $sql = "SELECT * FROM users"; $query = mysql_query($sql); while($row = mysql_fetch_array($query)){ array_push($this->names,$row['fname']); } return $this->names; } } ?>
-
ok this is very helpfull now I've got something funny So the fields are printed out as I wanted but in double this offcourse because there is a while loop in my function set_name (in file functions.php) and a foreach loop in my index.php. The goal is to keep the functions and views seperated. tried to perform it without a while loop in my function, but didn't work
-
hi, thanks for your answer! the reason that I was bringing in $fname was that I wanted to test out something. But now I'm confused with the $names variable. I'm stuck with the echo that is in my index.php. return $this->names; here it should return the var names with values from my loop, correct? in my index.php I have this to echo out the var: <body> <?php $names = new Person(); $names->set_name(); echo $names->set_name(); ?> </body> my functions.php class Person{ private $names = array(); function set_name(){ $sql = "SELECT * FROM users"; $query = mysql_query($sql); while($row = mysql_fetch_array($query)){ array_push($this->names,$row['fname']); } return $this->names; } } But it prints out 'Array' and that's it. What am I still doing wrong?
-
Hello, I'm digging further into php with oop I'm a bit playing with it to get a hand on it and for the moment I'm getting a hand on it I've created an object with a function that gets some data from a database, for the test i've created a little db name testusers with a table users, entered some users in (friends that I know) and I want to create a loop to get the data from that db: my code: class person{ public function set_name($fname){ $sql = "SELECT * FROM users"; $query = mysql_query($sql); while($row = mysql_fetch_array($query)){ return $this->fname=$row['fname']; } } } then I have a seperated index.php file: <?php require_once("functions.php"); ?> <html> <head> <title>Test Functions</title> </head> <body> <?php $fname = new person(); $fname->set_name($fname); echo $fname->set_name($fname); ?> </body> </html> so I have 2 users in my db, but seems that I get only the first entry of the database. I'm missing here something I think?
-
Hi, I'm getting a good grip with the PHP basics now Now I want to go further on by off course learn OOP PHP, I've Googled a bit to find some documentation, and documentation I found. I understand the logic of OOP that's no problem, but for the technical side I would like to try to build an object that fetches/connects to a mySQL database, in short, how to create a query in an object? I didn't find anything about that
-
I don't think that you can create tables with an '-' in there name via php. Didn't test it yet, but I don't think so. with an underscore it works that for sure.
-
Hi, thanks for your answer. I've tested it with a loop: <?php $test1 = 'test1'; $test2 = 'test2'; function Return_Test($test1,$test2){ switch($test1){ case 'test1'; $test1 = 'testbla'; break; } switch($test2){ case 'test2'; $test2 = 'yipie'; break; } return array($test1,$test2); } $return = Return_Test($test1,$test2); ?> <html> <head> <title>Hello</title> </head> <body> <table> <tr> <td><?php foreach($return as $key => $value){echo $value."<br />"} ?></td> </tr> </table> </body> </html> So this works great! But now I need to build this into another php file (functions.php) and in my index.php I should echo or print out the foreach loop, but without coding the loop in the index.php, normally I could do this with Smarty, but this unfortunally not an option is there another way?
-
Hi, I'm testing a function that should return an array containing 2 or more vars. But seems that I did something wrong because when I echo the function it gives me 'Array' <?php $test1 = 'test1'; $test2 = 'test2'; function Return_Test($test1,$test2){ switch($test1){ case 'test1'; $test1 = 'testbla'; break; case 'test2'; $test2 = 'testbla bla'; break; } switch($test2){ case 'test2'; $test2 = 'yipie'; break; case 'test2'; $test2 = 'youhou'; break; } return array($test1,$test2); } ?> <html> <head> <title>Hello</title> </head> <body> <table> <tr> <td><?php echo Return_Test($test1,$test2); ?></td> </tr> </table> </body> </html> What did I do wrong here?
-
hello, a friend of mine asked that I could create a php script which can import a text file with data content build up like this: FR|01220||S293|GCHRF,GEAFR,GEDOM||D041|0448|0|V25|37| FR|01220||S314|CBE,CES,CNL,CRU,GCHRF,GEAFR,GEDOM||D041|0448|7|V25|37| FR|01220||S882|||D041|0448|7|V25|37| FR|01220||S327328|||D016|1074|3|1|37| FR|01220||S299,S302303|CBE,CES,CNL,CRU,GCHRF,GEAFR,GEDOM||D041|0448|0|V25|37| FR|01220||S179180,S182183,S801807,S838839,S842,S845,S874875|||D041|0448|7|V25|37| FR|01230|||||D041|0448|0|V14|37| FR|01230|||CIT,GEXAP||D016|1069|3|3|37| FR|01230||S293|GCHRF,GEAFR,GEDOM||D041|0448|0|V14|37| FR|01230||S314|CBE,CES,CNL,CRU,GCHRF,GEAFR,GEDOM||D041|0448|7|V14|37| FR|01230||S882|||D041|0448|7|V14|37| FR|01230||S327328|||D016|1069|3|3|37| FR|01230||S299,S302303|CBE,CES,CNL,CRU,GCHRF,GEAFR,GEDOM||D041|0448|0|V14|37| FR|01230||S179180,S182183,S801807,S838839,S842,S845,S874875|||D041|0448|7|V14|37| FR|01240|||||D041|0435|5|P20|37| FR|01240|||CIT,GEXAP||D016|1069|3|110|37| FR|01240||S293|GCHRF,GEAFR,GEDOM||D041|0435|0|P20|37| I know that I could use an explode('|', $var) etc etc .. But how can I read in the file and tell to my script that he needs to read in the file so that I can explode the variables etc .?? Is it something like fread(filename) ? Thanks
-
found it, I had to place my return outside my while
-
Hello, I've created a function that checks in my DB if I have a record in the table CATEGORIES, if there is none it asks to add a category. If there is at least 1 record it must echo these categories, I'm doing this with a while: function Select_Categories(){ $sql = "SELECT * FROM CATEGORIES"; $query = mysql_query($sql); $num_rows = mysql_num_rows($query); if($num_rows == '0'){ echo "You do not have any Main Categories in your database! <br />Please add at least 1 Main Category to your database! <br />"; ?> <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post"> <?php echo "<ul>"; echo "<li>Category Name:</li>"; echo "<li><input type=\"text\" name=\"category_name\" /></li>"; echo "<li><input type=\"submit\" name=\"insert_category\" value=\"Insert Category!\" /></li>"; echo "</ul>"; echo "</form>"; $insert_category = $_POST['insert_category']; if(isset($insert_category)){ Insert_Category(); } return false; }else{ echo "Main Categories:"; while($row = mysql_fetch_array($query, MYSQL_ASSOC)){ $id = $row['id']; $cat_name = $row['name']; echo $cat_name."<br />"; return true; } } } But for some reason it returns me only 1 result, but I have about 15 records in my table. I'm a bit stuck here
-
actually it was to know how many records I have with the same value in the field 'nr' using some arguments thanks!
-
ah found it, SELECT nr,COUNT(nr) AS total FROM DB WHERE scan = '5' AND nr BETWEEN 'x' AND 'y' GROUP BY nr
-
hi thanks! But how do I echo the amount of doubles? Thanks!
-
hi, What kind of error do you have?
-
Hello, i'm building a query that counts how many records I have in my database, this by using a code. My query: SELECT * FROM DB WHERE scan = '5' AND nr BETWEEN 'x' AND 'y' Now the scan is not a variable so it is always 5, but the x and y are variables. So I can get these rows for exemple: 5000 5002 5002 5002 5003 5006 5008 5008 5010 etc etc .. Now I would like to count those that are double. I know that I should do this with a count: SELECT COUNT(field)AS test FROM DB ....... But I'm a bit stuck here Anyone knows how I can do that? Thanks
-
great thanks, I'll try this out
-
Hello, I'm trying to 'split' a value in 2. example: $var = '012345678910234' I would like to split this after the fourth value, meaning after the '3'. So afterworth I should have '0123' & '45678910234' Anyone know how to do that? Thanks!
-
ha it works, didn't saw the AS display at the first time thanks!
