2,070 Topics

Member Avatar for
Member Avatar for pezzinae

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 …

Member Avatar for pezzinae
0
484
Member Avatar for Shattered

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 …

Member Avatar for Shattered
0
237
Member Avatar for Suzie999

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 …

Member Avatar for Suzie999
0
346
Member Avatar for kENTUi

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..

Member Avatar for diafol
0
224
Member Avatar for scubbastevie

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 …

Member Avatar for scubbastevie
0
2K
Member Avatar for adikimicky

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 …

Member Avatar for Lakhveer
0
7K
Member Avatar for mexabet

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 …

Member Avatar for mexabet
0
651
Member Avatar for prieku

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 …

Member Avatar for gabrielcastillo
0
2K
Member Avatar for Henry_8

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 :)

Member Avatar for diafol
0
63
Member Avatar for kindo

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 …

0
183
Member Avatar for Sheila Mae

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 …

Member Avatar for stultuske
0
174
Member Avatar for Bas_1

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'); } …

Member Avatar for diafol
0
356
Member Avatar for SAMUEL_8

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.

Member Avatar for jj.dcruz
0
106
Member Avatar for Rudi_2

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.

Member Avatar for diafol
0
231
Member Avatar for اشرف_1

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 …

Member Avatar for basit_3
0
2K
Member Avatar for Daudi_1

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 …

Member Avatar for cereal
0
1K
Member Avatar for rpv_sen

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'; …

Member Avatar for rpv_sen
0
665
Member Avatar for prieku

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 …

Member Avatar for diafol
0
272
Member Avatar for Gautam_2

<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: …

Member Avatar for pritaeas
0
325
Member Avatar for bLuEmEzzy

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 …

Member Avatar for bLuEmEzzy
0
224
Member Avatar for lewashby

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 …

Member Avatar for cereal
0
388
Member Avatar for wikit

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 …

Member Avatar for drjohn
0
201
Member Avatar for Shabbir_1

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 …

Member Avatar for diafol
0
3K
Member Avatar for Jatinder_1

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 …

Member Avatar for pritaeas
0
184
Member Avatar for jaime.bentez

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 …

Member Avatar for jaime.bentez
1
831
Member Avatar for Shabbir_1

<?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'], …

Member Avatar for diafol
0
196
Member Avatar for jaai

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...

Member Avatar for md riyaz
0
14K
Member Avatar for dizy

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 …

Member Avatar for dizy
0
342
Member Avatar for nadiam

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' }, …

Member Avatar for Shilpi_1
0
13K
Member Avatar for Izzah_2

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 …

Member Avatar for Izzah_2
0
4K

The End.