10,939 Topics
| |
I want to get all the related pics corresponding to the pic selected.... here is my view page <?php foreach($detail as $row){?> <img class="primary-image" ima="<?php echo base_url();?>images/<?php echo $row->image;?>" src="<?php echo base_url();?>images/<?php echo $row->image;?>" alt="" /> <?php }?> my control page looks like this.... public function product_details($p_id) { $data['active_mn']='product_details'; $data['product']=$this->roxmodel->get_product_details($p_id); … | |
I have a form on "add-category.php" that enables the admin to create a category and doing so includes uploading an image to a folder and inserts its file name and relevant text into the database. The script worked well with mysql_, but now it stopped working after I upgraded my … | |
I'm working on shopping mobile application. The application is similar to ebay it have customer and seller. When user create account they can either create account as seller or customer. The payment will be by paypal each user need to provide their paypal account (Seller Paypal & customer PayPal) so … | |
i want to display all related images according to the image selected here is my code... my control looks like this.. public function product_details($p_id) { $data['active_mn']='product_details'; $data['detail']=$this->roxmodel->get_related_image($p_id,4,0); var_dump($data['detail']); $this->load->view('product_details',$data); } my model looks like this public function get_related_image($p_id,$limit,$offset) { $this->db->order_by("gallery.id","desc"); $this->db->where('category_id',$p_id); $query=$this->db->get('gallery',$limit,$offset); return $query->result(); } my view page looks like … | |
please i need to query 2 tables at once and display the content in table. here is the code: <?php include 'database.php'; $pdo = Database::connect(); $sql = 'SELECT producs.*,validation_superviseur.* FROM products ORDER BY product_id DESC ,validation_superviseur ORDER BY id DESC'; foreach ($pdo->query($sql) as $row) { echo '<tr>'; echo '<td>'. $row['cat_id'] … | |
final public function setMySQL($key, $value) { $this->mysql[$key] = $value; } /*-------------------------------Manage Connection-------------------------------------*/ final public function connect($type) { global $core, $_CONFIG; if(!$this->connected) {k $this->connection = $this->mysql[$type]($_CONFIG['mysql']['127.0.0.1'], $_CONFIG['mysql']['test1'], $_CONFIG['mysql']['12345']); if($this->connection) { $mydatabase = $this->mysql['nexus']($_CONFIG['mysql']['nexus'], $this->connection); if($mydatabase) { $this->connected = true; } else { $core->systemError('MySQL Engine', 'MySQL could not connect to database'); } … | |
Hi Everton one, I have the following search statement that works great, But what I would like to do is expand this to include multiple LIKE '%$search%' $STM = $dbh->prepare('SELECT * FROM tblname WHERE col=:lsecure'); $STM->bindParam(':lsecure', $search); $STM->execute(); $count = $STM->rowCount(); $results = $STM->fetchAll(PDO::FETCH_ASSOC); What I would like to do … | |
Hello,I need help in updating user image in form. I have form of around 10 fields in there is options for updating images(images which have been uploaded at time of reg)** Max 5 images is allowed **now i am successful in saving data to database and at time of updating … | |
I have a text area that I want a list to be entered. I am trying to seperate each list item and put it into a seperate sql entry. Could some one tell me what I am dong wrong? error_reporting(E_ALL); ini_set('display_errors',1); $textarray = explode("\n",$textarea);if(isset($_POST['textarea'])){ $textarea= $_POST['textarea']; $q = "INSERT INTO … | |
Hello. How can I config django (python framework) with mysql? How can i use phpmyadmin to manage my database while i'm coding in django? Thank you. | |
Hi, I know parsing json data has been discussed lots but what I want is probably a little simpler I need a little editing to the bleow php script to work as convert json data and push it into MySQL table since the script work as reading the json data … | |
| I'm making money lending system. In my database there are two mysql tables which are custormer AND income. All custormer info stored in custormer table. When I give loans these loan details stored in loan table. After I received loan amount from custormers(daily payments) these records stored in income table. … |
Im making search button and i want when user is searched to give all tickets received by that user i have this code but its just showing the last record of that db table and if i try to search other users gives me `No ticket received from that user.` … | |
Export CSV TO Mysql and Import to CSV from MYsql in PHP | |
hya all i have sorted the checkbox group out and its echoing through ok but its also echoing through userid, username twice and email address when all i want is to echo options ticked any ideals of what can be causing this please php block at top of page: <?php … | |
Hi all, I have a text box in a windows form. My question is, how to check existing text which is entered in text box through database? Please reply me with an example. in vb.net windows application. | |
I'm using [imgAreaSelect](http://odyniec.net/projects/imgareaselect/) to select image area. I have following values. Need Help to upload original image to "../original-images/" folder & cropped images to "../uploads/" folder. Upload cropped images with new filename "$newfilename" Plz help Thanks in advance. $x1 $y1 $x2 $y2 $w $h $filename = $_FILES["image"]["name"]; $file_basename = substr($filename, … | |
hi...iam stuck with this code pls help me here is my controller public function men_clothing() { $data['active_mn']='men_clothing'; $data['men']=$this->roxmodel->get_category_by_parent($p_id=8); $data['kids']=$this->roxmodel->get_category_by_parent($p_id=9); $data['galllery']=$this->roxmodel->get_galleryImages($p_id); } my model looks like this public function get_galleryImages($p_id) { $this->db->where('category_id',$p_id); $query = $this->db->get('gallery')->result(); return $query; /* $this->db->where('gallery.category_id',$p_id); $this->db->select('gallery.*,category.id'); $this->db->join('category','category.parent_id=gallery.category_id'); return $this->db->get('gallery')->result(); */ } my view page look like this … | |
Hello guys, im trying to learn how to use dynamic data table, which means i want to use data table as my searching result table. but i dint know how to make it because when the search result filled in the table, the sort and other "DataTable" function is not … | |
My login script is displaying the following error message: Warning: Illegal string offset 'hash' on line 30. Here is the code that generates the error: <?php // configuration require("../../includes/config.php"); // if form was submitted if ($_SERVER["REQUEST_METHOD"] == "POST") { // validate submission if (empty($_POST["username"])) { adminapologize("You must provide your username."); … | |
hi...iamb struggling with this code please help me my controller is this .. public function men_clothing() { $data['active_mn']='men_clothing'; $data['men']=$this->roxmodel->get_category_by_parent($p_id=8); $data['kids']=$this->roxmodel->get_category_by_parent($p_id=9); $data['galllery']=$this->roxmodel->get_galleryImages($p_id=10,11); } my model page looks like this... public function get_galleryImages($p_id) { $this->db->where('gallery.category_id',$p_id); $query = $this->db->get('gallery')->result(); return $query; } my view page looks like this... <?php foreach($galllery as $row){?> <img … | |
Hello, please check the attachment for details. What i need is : The sum of all the full_trade_amount for that route The list of routes that share a customer with that route The number customers shared with that route The number of columns with data can vary so a route … | |
Hi there, I follow this tutorial for my web app. link: http://www.thesoftwareguy.in/creating-multi-user-role-based-admin-using-php-mysql-bootstrap/ Can anyone give me idea to do this same app using mysqli? Thanks. | |
Hello guys, I had to change the host of my web page , now I'm having trouble accessing the page because of problems in the connection string with the base. Error that occurs : Warning : mysql_select_db ( ) expects parameter 2 to be resource , null given in /var/www/web/Classes/AcessDatabase.php … | |
I have this in my my.cnf wait_timeout=1800 interactive_timeout=1800; net_read_timeout=1800; net_write_timeout=1800 but when i execute show processlist; I have processes that still running more than 4500sec even they are in 'Sleep' command. please help about this, thank you. | |
Hi, I am new to this concept. I have one master database. and 2 or more client databases. In master database, it has all the clients database username and password, Structure of the all client databases are same. Consider My Master Database is alpha, I have 2 client database , … | |
hello guys i make a database software and i want to import sql file into mySQL database with query , so that when user click button this sql file is auto import , Is there any way to do this , thankx | |
I input the previous inputted values via php variables into the value section of the input tag, but when I go to modify it and update it to the database, the value still stays the same. Is there anyways to combine the two , so that for instance when a … | |
I am having difficulty formatting the XML response from a php curl xml api for infobip. My code below loops sms to mobile numbers. But i want to format the XML responses to show the messages successfully sent and those that were not successful using a conditional if else statement. … | |
Hi, I tried to get this code to work, and the gist is I am trying to allow the user to edit their inputs by allowsing them to edit past submissions. But even after I put "<?php echo ?>" tags in there, it still does not work. It worked perfectly … |
The End.