2,570 Topics
 | |
| | I'm making money lending system. On that I use mysql database. I want to find customer's who skipped their daily instalment. I try this code. But It has error. ***Prveious code:*** SELECT l.loan_id, l.custormer_id,custormer_name FROM loan l JOIN income i ON l.loan_id = l.loan_id WHERE l.loan_id NOT IN (SELECT loan_id … |
 | Hi all I have a system that im working on the the code works fine it, but theres a part thats giving me issues below is the code that loops through the number of records in the table and generates the same number of update queries with the random numbers … |
 | Hello to all! I am using Sql server express 2008. Now I want to use Integtation services such as creating and executing packages. But I could not find any interface to create and execute packages in version of server which i am using. When I go to start menu > …  |
| | hi..... i am searching for the query for retrieving the deleted data from the table.From the web i got "flashback" method to get the dropped table.Any one has any idea pls,help me thanks in advance |
| | Hi Guys! im making a small website based around a very simple and basic mvc pattern (in this case just seperating files into different folders) Im currently stuck on selecting data from the database and displaying it. My model looks like this: <?php require_once('../Controller/config.php'); class Readings { public $dbconn; public … |
 | I m in the process of creating a sql table which acts as a stafflist that has several columns like name , number , email and delete. One webpage on the website gives out the rows of this table and i would like to have a clickable link in the … |
| | 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'] … |
 | 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 … |
| | i need help. my teacher told me to create a program on java gui that can send everything you input to notepad. then when you input another info in java gui. another notepad file should be made.. |
| | 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. … |
| | Hello, currently on one of my development servers I have SQL Server 2014 installed, the problem I HAD was that when I executed any of my PHP sites connected to various databases I was getting `SQLSTATE[HY2000][2002] Connection was activily refused...` I fixed that error by forwarding the port through the … |
 | 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 … |
| | i try to use phpoffice/phpexcel to do this but i haven't an idea of do it... i have this form in html <body> <div align="center">ELENCA TABELLE PRESENTI NEL DB</div> <form action="index.php" method="post" enctype="multipart/form-data"> <table> <tr> <td> Filename: </td> <td> <input type="file" name="file" id="file"> </td> </tr> <tr> <td colspan="2" align="right"> <input …  |
 | Hello I have VB.NET System ; I wanna to make setup (.exe) for the program. The Program depend on SQL Server Database. How I can make it exe file with the database, and to install all the configuration on any PC. What I shall do according to the connection string …  |
| | 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 … |
| | Hi, I hope I've posted this in the right place, please just tell me if not. I've been having an issue with connecting to a database from a website and have recieved this as an error message: *Array ( [0] => Array ( [0] => IMSSP [SQLSTATE] => IMSSP [1] … |
 | 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']; …  |
| | hi i have followed a online tutorial to replace photo system on my site and all went well till i attempt to upload photo i get no file selected even if i have just gone on the page but after pressing submit i get a success message and the photo … |
| | hi i got another syntax error in a script that i am fixing to add onto my main site can someone take a look to see whats going off this error is You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version … |
| | hi i managed to change my site from mysql to mysqli with all your help although i have one line thats causing me problems in inbox.php can someone check this out and see whats wrong the error im getting is Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given … |
 | Hello Community, I was wondering if there is a way to get a posts comments within a Facebook group? I have tried using https://graph.facebook.com/{POST_ID}/comments?access_token={ACCESS_TOKEN} but all it returns is Array ( [data] => Array ( ) ) even though there are comments on my post. |
| | Hy there! I have a strange error to my prestashop. If I deactivate the module block contact without container the whole theme for mobile is ruined....Please see photo https://www.dropbox.com/s/1pst1w9ivuw4v3a/2016_01_03_12.25.10.png?dl=0 The error appears only to mobile and tablets. For desktop everything is okay. The same problem I get if I activate … |
 | I try to make a query and it works well, but when i put it in a stored procedure.I can't figure out whats wrong with my code. It says **Procedure or function has too many arguments specified** Stored procedure code ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- … |
| | I have a working search database and it's query code says $criteria = $_POST['criteria']; $query = "SELECT * FROM table WHERE field LIKE '%".$criteria."%' Order by Appeared asc"; but I want it to omit results that contain the word but are more then the word example the criteria might be … |
| | Hi, I was hoping I can get some help. I've been searching and searching for a lightbox that works with SrcSet so I can display different images based on viewport width. Most to which I have found; don't support SrcSet but presentation wise, are exactly what I want, somewhat a … |
| | this is my code $sql = "SELECT * FROM `sale_history` WHERE `date` BETWEEN :fromdate AND :todate"; $stmt = $PDO->prepare($sql); $stmt->bindParam(':fromdate', $_POST['fromdate'], PDO::PARAM_STR); $stmt->bindParam(':todate', $_POST['todate'], PDO::PARAM_STR); $stmt->execute(); $total = $stmt->rowCount(); while ($row = $stmt->fetchObject()) { echo "$row->date"; echo "$row->product"; echo "$row->username"; echo "$row->quantity"; } but its not working, where is the … |
 | Greetings, I have a database creation script. I've run the script after changed the path within the 'FILENAME' option to create the database on an external hard disk and I was able to see and select data from tables as the script run with no errors. However, when I tried …  |
| | When I login same script works for first user but for other user, it gives error in connection. More over i want to fetch data from database Main File is <?php include_once("../init.php"); validation_check($_SESSION['SID'],MEM_HOME_ADMIN); $msg=''; $dir ='../'.USER_PIC; $sId = $_SESSION['SID']; $query = mysql_query("select * from user WHERE user = ".$sId) or …  |
| | Hello. I have created a filter result using php but it is not properly working for me when i filter result it is not showing me up with any products <form method="POST" action="product.php?cat=<?php echo $cat; ?>"> <div class="price-box"> <h5>Price</h5> <input type="hidden" name='price_range' class="range-slider" min="0" max="600" value="23" /> </div> <div id="filters"> … |
| | this code doesnt save data in db as 1 when i click on yes button.. <table id="main" class="display" cellspacing="0" width="100%"> <thead> <tr> <th>Date</th> <th>Amount</th> <th>Approve</th> </tr> </thead> <tbody> <?php $i= 0; foreach($purchaseorder as $tdata): $i++; ?> <tr> <td><?php echo $tdata['pay_date']; ?></td> <td><?php echo $tdata['amount']; ?></td> <td><td><?php if ($tdata['approve']=='1') { ?> … |
The End.