11,093 Topics
 | |
| | 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 , … |
 | |
 | 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 … |
| | Hello everyobody, I'm trying to do a presentation of MD5 algorithm in my class. I would like to give an example of md5 hash in every programming language. I found a useful website like http://md5-sha.com/ a with examples in all other languages, but i still want to present Java too … |
| | I inserted into user_name and user_password the values zach and sha1('zach'). I then tried to retrieve it with SELECT * FROM user_data WHERE user_name='zach' && user_password=SHA1('zach'); But it shows zero results. When I insert it it shows, but I can't retrieve it. Any ideas? |
 | "Can't connect to local MySQL server through socket '/tmp/mysqld.sock' (2)" Here's my code: <?php $dbhost=$_POST['dbhost']; // Host name $dbusername=$_POST['dbusername']; // Mysql username $dbpassword=$_POST['dbpassword']; // Mysql password $db_name=$_POST['database']; // Database name $tbl_name=$_POST['tablename']; // Table name $action=$_POST['action']; if($action == 'connect') { if(mysql_connect("$dbhost", "$dbusername", "$dbpassword") == true) { if(mysql_select_db("$db_name") == true) { echo('Connected …  |
 | my controller function public function destroy($id){ /* Deleting a product */ Product::destroy($id); // 1 way return redirect()->route('product.index'); } I tried using both the methods for deleting but it isn't deleting the records in MySQL although it does return with "true" Is there any configuration am missing? This is the form … |
| | Recently I saved boolean value by radio command button . Now I want to retrive that value to search form. Please help me ????  |
| | I have a form on our website that a user can fill out for custom product. I want the form data to be 1) stored into a mysql database AND after storing said data, 2) email the same data to our sales department. 1) The form data DOES get stored … |
| | I making application using vb.net and mysql database(mysql query broweser). In my programm there is two date time pickers (dtpisf & dtpist). I want to run this application like this, when I select two dates from date time pickers and click button it will show total of column in text … |
| | I'm trying to automatically populate a navigation menu based on available categories in the database. As follows is my code: <?php $sidenav = query("SELECT cat_id, cat_name FROM prod_cat ORDER By cat_name LIMIT 20"); if ($sidenav != false) { $sidenav->execute(); while($result = $sidenav->fetch(PDO::FETCH_BOTH)) { echo "<div class='left_button'><a href='/customcms/products/index.php?page=list-product&category={$result['cat_id']}'>{$result['cat_name']}</a></div>"; } } ?> … |
| | I used mysql query broweser to create database and tables. but when I run this code it doesn't show results. But there is no error SELECT * FROM expenses WHERE datee BETWEEN 01/01/2016 and 01/09/2016; can anyone help me ? |
 | Hello the same issue has troubled me in the past. I have a autocomplete script that the user chooses people to send them something. I use to store multiple values in one row. That is the id of the selected people that the user chooses. Thats not the proper thing … |
| | Hi everyone, am trying to import excel file to 2 tables using php but unable to do so. The 1st table is Kra (kraid,kra) and 2nd table Kpi (kpiid,kpi,kraid). The foreign key for Kpi is kraid. When i import the file the following message appears "Invalid File:Please upload CSV file.", … |
 | Hi Guys, Do you have any ideas on how to create and read barcodes in PHP? Ive been researching it but still I did'nt get answers. Thank You!  |
| | Hi In my table , I have date of birth value like 1991/10/21, I want to display that date of birth like: 21/10/1991(Twentynineth October One thousand Nine Hundred Ninety Nine) date of birth in numbers and in Characters also. How to do that, it has to do dynamically? |
| | In this pseudo example I have a table called **carsales** which contains 2 columns called **date** and **make** Every time a salesperson sells a car they enter the date in the **date** column and model of the car for example Ford, Honda, Audi in the **make** column. The required output … |
| | hi i have a script created for me and im attempting to add user_id so it it gets the userid from the users table so far i have done CREATE TABLE IF NOT EXISTS `checkbox` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(50) NOT NULL, `male` varchar(10) COLLATE utf8_unicode_ci NOT … |
| | Ok so im looking to create a simple booking system as part of my Final Year Project. I have a locally hosted mySQL database created and linked to using php. I have created a databse called reservations with 3 tablels (Available, reserves and confirms). Basically what I am looking to … |
| | Hello i want to make notification when new message is received, i have a row `seen` with values `0` and `1` if is 0 then its unread else is seen i got this code but when it displays the output shows the number of rows but for example i have … |
| | Please help me how to do click button to display select box. at the same time add and remove select box  |
| | I'm new to vb.net :rolleyes: I have form and it contain two date time pickers(dtpfrom & dtpto) and lable (lbltotal) and button (btnview) I want to pick data between two dates from mysql table. mysql table name is 'daily_income' can anyone help me ?  |
| | It could be a dumb question, and tried to search for it and found nothing. I been using mysql for years(not that to long) but i never had tried mysql transactions. Now my question is, what would happen if i issue an insert or delete statement from multiple clients using … |
 | My php file connnects to my sql database , following code works <?php $servername = "globalxxx.com.mysql"; $username = "globalxxx_com"; $password = "YS4xxx"; $conn = new mysqli($servername, $username, $password); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } echo "Connected successfully" $sql = "SELECT Id, FirstName, LastName FROM … |
| | Hello, I keep having this error whenever I try to post a reply on my forum website. Here is my code: <?php session_start(); include ('dbconn.php'); $comment = nl2br(addslashes($_POST['comment'])); $cid = $_GET['cid']; $scid = $_GET['scid']; $tid = $_GET['tid']; $insert = mysqli_query($con, "INSERT INTO replies (`category_id`, `subcategory_id`, `topic_id`, `author`, `comment`, `date_posted`) VALUES … |
 | i have an echo statement. which am looping columns. and i want to use this onerror command <img src="http://subinsb.com/to-an-image" onerror="this.src='img/delogo.jpg';"/> but not working. how do i do this. thanks echo ' <div class="col-lg-5 col-md-5 col-xs-12"> <h4 class="font_head_check">' . $title . '<span class="box_type_unik">For Sale</span></h4> <p class="font_check">' . $town . '</p> <span … |
| | Hi , I need a calculation method to calculate multiple marks for an Individual students. Based on standard id and section id I showed list of students, and subjects dynamically, so that, for each student n number of subjects will display. When entering marks, for each student and for all … |
| | I have a custom function called "query" with PDO statement in the functions.php file: /** * Executes SQL statement, possibly with parameters, returning * an array of all rows in result set or false on (non-fatal) error. */ function query(/* $sql [, ... ] */) { // SQL statement $sql … |
| | Hi all, I'm facing this error while following a tutorial. Warning: mysqli_result::fetch_array() expects parameter 1 to be integer, string given in C:\xampp\htdocs\client\login.php on line 12 [] Here is my php <?PHP include_once("connection.php"); if( isset($_GET['format']) && $_GET['format'] == "json" ) { $query = "SELECT * FROM tbl_client " ; $result = … |
| | hi im attempting to get all selected checkboxes to show in a database column. But ive tried adding a sql string for database to the code below to add the selected to database but nothing is coming up. where is it best to add the string <?php $aDoor = $_POST['formDoor']; …  |
| | Could you answer? I've a table in mysql database the structure is like: table name: img_tbl (id, image, size, format, etc..) image defined as blob datatype inside the table. i can retrieve single image from mysql database by using the following code. [CODE] $sql = "SELECT image,size,format FROM img_tbl"; // … |
| | hi all i have duplicated a script i had created and adapted it to something else i want and now im getting a Fatal error: Call to undefined function get_interests_data_from_post() in /home/jktempla/public_html/checkboxes/check.php on line 8 can someone help with this heres the coding for that section <?php include("connection.php"); $interests = … |
| | Hi In a form, I have two divs like in left and right but only one submit button . I don`t know how to save in submit action. Submit button has to come in center. Here I included my code . Check and tell me <form action="usersave.php"> <!-- class="form-horizontal form-label-left"--> … |
| | when ever i am inserting any of the symbols like cosec^2Ɵ (cosec power 2) it will display inline. i won't that to be displayed with raise to 2 or subscript or superscript of it. How to get Displayed that using utf-8 unicode characset ? |
The End.