2,070 Topics
| |
Hello again Please your support with the next statement in vb.net and access database this is part of the code can you help me the error code is missing operator in query expression str = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\MXDTBTZ3XC1\Users\MXDTBTZ3XC1\Desktop\refacciones web\surtido.accdb" con = New OleDbConnection(str) sql = "select * from material where IDDOS … | |
So I am working on a messanger, and I am having problems automatically fetching new messages from the database. If anyone can fix me up with a peice of code which can fetch new information from the database after every 2 seconds or so. I am very new to working … | |
My project uses local sql database. I tried the app on a non development machine for first time. Got a message saying it was downloading required files, sql 2008 express, at a whopping 600MB+ file. Please tell me I've done something wrong, and any user of my app will not … | |
In local my program is automatically showing the data from database when i Add some records. But when my website is online the data won't show in my website. i need to refresh my website to show the new records. .PLease help Thanks.. | |
Hi Guys, I am a novice at coding, firstly I knowthe functions in my code are deprecated in future versions of PHP, I'm running 5.5. I have a few days to get my current code working with this desired functionality which is a throw away prototype, so for now I'm … | |
Hi everyone, I am trying to make a user login page. The user is required to fill username and password in textFields and when he clicks the Submit button, all details are needed to be written in the database. import javax.swing.*; import java.sql.*; import java.awt.*; import java.awt.event.*; public class register … | |
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 have a base64-encoded string on database row. How to create a .pdf file from this encoded string using codeigniter and mpdf ? foreach($report as $files) /* send email confirmation*/ $this->data['email'] = TRUE; require_once APPPATH.'third_party/MPDF561/mpdf.php'; $mpdf=new mPDF('c','A4','','',10,10,20,20,10,10); $mpdf->SetDisplayMode('fullpage'); $this->load->helper('custom_email'); $emailTo ="email@address.here"; $emailFrom =$this->config->item('email'); $emailSubject ='Subject Here'; $emailMessage ='Your PDF files … | |
Hello, Im just a student learning how to code. I want to know how to compute age using the value from <input type="date"> then send the computed value to a textbox? Thanks for the help :) | |
I am working on a web app in Python (*using the Flask framework*). I have a post and photo table connected via ForeignKey, my problems: 1. **how can i return an empty image if image is empty**, and if not empty 2. **how do i select just one image from … | |
My database have this record: timer_id = 1 time = 498 utc = 16:46:21 I'm retrieving the record the time column in the database but it won't retrieve the current record. I have this code for retrieving it: function start(){ div = "<?php $select = mysql_query('SELECT COUNT(*) AS num FROM … | |
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'); } … | |
Am working on an online examination system. I have ordered the question output with "ORDER BY 1 ASC" and it follows as its appears in the database. But I want the output to be randomly generated so that each time the examinee logs in, different question number comes first. | |
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 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 … | |
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 … | |
Hi I am trying to send a reminder mail with the HTML Table format. But the details is not getting displayed. Please help me to fix. i am using class file to send the email. include ('config.php'); date_default_timezone_set('Asia/Calcutta'); require "classemail.php"; $mail = new EMail; $mail->Username = 'emailid'; $mail->Password = 'password'; … | |
I have two table : buy_temp & buy_detail, i need transfer data from buy_temp to buy_detail . For the first step i will get data from buy_temp like this : $sid = $db->data("email", $user_session); $sql = mysql_query("SELECT * FROM buy_temp WHERE id_session='$sid'"); while ($r=mysql_fetch_array($sql)) { $cart[] = $r; } $j … | |
<h2><i>Top Rated</i></h2> <center> <table> <tr> <? foreach($top_ratings as $key => $image) : ?> <td valign="top"><img src="images/<?=$image->filename?>" width="70" /></td> <? endforeach ?> </tr> <? <tr> <? foreach($top_ratings as $key => $image) : ?> <td valign="top">Score: <?=$image->score?></td> <? endforeach ?> </tr> <tr> <? foreach($top_ratings as $key => $image) : ?> <td valign="top">Performance: … | |
Hi Guys Im trying to search in a textbox on my form and its value will load on the table. But I cannot get how, and also what should I use, I only know PHP and simple Javascript, Please help me. I only want to know on how can I … | |
When I tried to start MongoDB with the `mongod` command I got the following. garrett@mint-desktop ~ $ mongod mongod --help for help and startup options Sun Jan 10 14:50:55.049 [initandlisten] MongoDB starting : pid=23327 port=27017 dbpath=/data/db/ 64-bit host=mint-desktop Sun Jan 10 14:50:55.050 [initandlisten] db version v2.4.9 Sun Jan 10 14:50:55.050 … | |
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 … | |
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 … | |
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 … | |
I received a database I need to restore on my local machine. The database is MySQL off a Linux box, is it possible to mount these files similar to how you would a .mdb file on a MSSQL Server? I am looking to mount them on my Windows based version … | |
<?php if (isset ($_POST['submit'])) { try { $picture = "../images/default-picsss.png"; $sql = " INSERT INTO user (username, password, fullname, address, mobile, email, picture) VALUES (:username, :password, :fullname, :address, :mobile, :email, :picture ); INSERT INTO user_balance (username) VALUE (:username); "; $stmt = $PDO->prepare($sql); $stmt->bindParam(':username', $_POST['username'], PDO::PARAM_STR); $stmt->bindParam(':password', $_POST['password'], PDO::PARAM_STR); $stmt->bindParam(':fullname', $_POST['fullname'], … | |
i need help in adding a new record to the database using adodc in vb6.. i've a command button named add in my form... | |
hello, i need your help i have problem with my code php. i want to call and display data from database but this coding cannot working. this's my code php. **searchform.php** <?php mysql_connect('localhost','root','') or die("Connection Failed"); mysql_select_db("profil")or die("Connection Failed"); $query = "SELECT * FROM tblreport"; $result = mysql_query($query); ?> <select … | |
Hi guys. I have already installed fullcalendar successfully onto my webpage home.php <script type="text/javascript" src="js/fullcalendar.js"></script> <script type="text/javascript" src="js/fullcalendar.min.js"></script> <script> $(document).ready(function() { var date = new Date(); var d = date.getDate(); var m = date.getMonth(); var y = date.getFullYear(); $('#calendar').fullCalendar( { header: { left: 'prev,next today', center: 'title', right: 'month,basicWeek,basicDay' }, … | |
Hi, Ive been follow the tutorial in the youtube . I need to upload images to my webpage but the code seem not working. It also doesnt not appear any errors from the code. Can someone please have a look at my code, please? <!-- dbase.php to connect between php … |
The End.