The facts: We are talking about a small company (5 persons) with many clients that making real money (we don't) . We provide our own software that has unique features against the e-commerce completion. The problem: the first glimpse of the problem arose around 2012 and made clear around 2014 with web sockets. Some clients didn't want a simple chat with their client but instead a full live eShop where they could negotiate the prices of a product or even start a discussion with a visitor. The solution would be implementing web sockets in to our framework and that worked …

Member Avatar
Member Avatar
+1 forum 6

Hi, i need urgent help.. iam working on leave management system(LMS).if the employee apply for the leaves means,one message go to HR inbox (internal application inbox). iam designing inbox for this..it has two parts(2 coloums).in the first coloumn iam displaying messages with employe name,id nd subject(just like preview of the message)..iam retriving employee name and id,and subject from the database.if the HR click on the particular messages,that message whole content should display in the second coloumn.it should be dynamic. any idea,any help?how to achive this??

Member Avatar
Member Avatar
+0 forum 4

Hi, I have a scenario like XYZ company is creating a User management System , which allows to purchase for different company , so based on the package the system provides options to save last three or five user password to check and the max is ten . XYZ---| Total password count 10 Company1--------|-----Company 2 company 1 takes with 5 retrivals where the other takes 2 retrivals, please let me know how can I design the DB for the same. My present deisgn what i have done i have master table with following fields Master table => Company ID , …

Member Avatar
Member Avatar
+0 forum 2

Hi, I am working in a company that utilises many systems with their own databases. For example, the cafe has its own CAFE system with its own database (it could be postgresql). The Health Care system has its own database system (it could be MS SQL). The Transport booking has its own database system. And another system uses No-SQL database. I am faced with a task of producing web-based management reports to allow managers to see key performance indicators on screen. What would be the best way of accomplishing this? I would perform cross database queries of the key performance …

Member Avatar
Member Avatar
+0 forum 4

A simple Data Layer for OOP PHP Applications Hello, first of all to understand this tutorial would be best if you have some knowledges about OOP ( https://www.daniweb.com/programming/web-development/tutorials/437592/introduction-to-phps-object-orientation by priteas ) and DB usage (MySQL in this case) with PHP https://www.daniweb.com/programming/web-development/threads/499320/common-issues-with-mysql-and-php by diafol ). What we will try to achieve is a consistent usage of the DB (we will use MySQL but you can use what ever DB you like). We will not map query results in objects / lists of objects in this tutorial (there will be another one that will contain that) , but just retrieve the results …

Member Avatar
Member Avatar
+4 forum 1

Hello everybody. There is a row in my db table I have set it's type as "TIMESTAMP". How should I fill in? Should get the current timestamp in php and send it to that row, correct? So how can I do that?

Member Avatar
Member Avatar
+0 forum 5

Hello everybody! There is a problem with my db table. For example i send 6 posts (with title, author and content) to the db table one after an other, so their post's id would be 1-2-3-4-5-6. Then if i delete the post number 6 and then write a new post (which it's id must be 7), after that when i echo all posts on the page to see them, i see posts with ids 1-2-3-4-5-7 !! How can i solve this problem? When i delete the post with id 6, the next post should be set there into id 6.

Member Avatar
Member Avatar
+0 forum 5

Hi everyone i need some help down here. i am trying to connect multiple db and at the same time i want to sum the value of the column. what i have right now is this SELECT SUM(total) as branch1sales FROM icm.sales UNION SELECT sum(total) as branch2sales FROM hism.sales its computing correctly but the problem is the branch2 alias is being invoke. what am i doing wrong? see attached image for the output ![Untitled.jpg](/attachments/small/3/2380191a296b9b064ffa52c969a268a3.jpg "align-left") thanks

Member Avatar
Member Avatar
+0 forum 2

I have a code: <body> <?php global $wpdb; $sql = ""; $sql = "SELECT * FROM emgAdmin"; $sql = "$sql INNER JOIN wp_posts ON wp_posts.ID = emgAdmin.ID_OfPost "; $ArrResult = $wpdb->get_results($sql); while ($emgAdminResult = mysql_fetch_object($ArrResult)) { echo($emgAdminResult->post_date); } ?> </body> and I'm getting an error that says,"Call to a member function get_results() on null" ... I have tested the sql and it did worked, rendering all that data that I wanted. I dont know why I'm getting the error with the get_results() function of wordpress when I have already defined the global $wpdb

Member Avatar
Member Avatar
+0 forum 6

Hello everybody! Me again with an other question :) I have a file with a list and 3 functions in it; view, sort, append. I used pickle to save data changes in to an other file (films.db). Imagine you want to use this programe for the first time on your system so there is no db file correct? You should type python favemoviese.py view or favemovies.py append.... At this time the script must creat the db file immidiately beacuse there was no primary db file, right? And then you should be able to append your word to the list because …

Member Avatar
Member Avatar
+0 forum 14

Hi all, I am trying to compare output from DB The code below works on 1 check, but I require to do this on multiple products like so `if rowProduct("GRPCODE") <> "Cross Hire" or rowProduct("GRPCODE") <> "Boiler Ancillaries" then` etc but the above line does not work as I have coded it? What is the problem with the code. Thanks in advance if rowProduct("GRPCODE") <> "Cross Hire" then ' Elimination unwanted code if not rowStock.eof then ' stock found do while not rowStock.eof ' loop through stocl if instr(RemoveItems, "," & rowStock("ITEMNO") & ",") = 0 then ' item not …

Member Avatar
Member Avatar
+0 forum 1

Hi All, Having a few issues with some DB functions in my code at the moment. This code was developed by another user who kindly helped me out, and I know for sure it was working. The difference being that after having some compatability issues when upgrading to a new version of VS, I decided to create a new project from scratch and basically type the whole lot out again. Whilst this fixed the issues I was having previously, it seemed to introduce some issues on the DB side. As far as I can see (and my eyes are now …

Member Avatar
Member Avatar
+0 forum 12

Hi, I need to save the inserted password on MSSQL as md5 encrypted one. Basicaly when the user inserts the password on the textbox, it must be encrypted before storing it on the MSSQL Database. How can I do that? This was made from DreamWeaver CS6. Thank you the code: <%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%> <!--#include file="Connections/conn.asp" --> <% Dim MM_editAction MM_editAction = CStr(Request.ServerVariables("SCRIPT_NAME")) If (Request.QueryString <> "") Then MM_editAction = MM_editAction & "?" & Server.HTMLEncode(Request.QueryString) End If ' boolean to abort record edit Dim MM_abortEdit MM_abortEdit = false %> <% If (CStr(Request("MM_insert")) = "form1") Then If (Not MM_abortEdit) Then ' execute the …

Member Avatar
Member Avatar
+0 forum 2

Here is online demo - http://cs-bg.info/news/archive/ I want to show my news like that. (like archive for each year) I want to work with epoch time. Thanks for any help.

Member Avatar
Member Avatar
+0 forum 3

Ok so i an very new to this site and am trying my luck with PHP. Got a great idee to make some cash but now to implement it is a whole new game for me. I want to keep the selceted value of the select box after the form has been submited with dynamic data from my db(mysql). i had a look at http://www.daniweb.com/web-development/php/threads/360284/php-keep-dropdown-box-data-after-posting-fails but can't get it to work with my db and site. my code : <form action="#" method="post"> <select id="prov" name="prov"> <?php $sql = "SELECT distinct province from escorts ORDER BY province ASC"; $query = mysql_query( …

Member Avatar
Member Avatar
+0 forum 3

hello everybody.. I have a table which contains all the info about a file i.e its id, name, size, createddt and modifieddt. now i need to copy all the files(file content) to a local drive. Gotta do this in c# console application. Can anybody help me?

Member Avatar
Member Avatar
+0 forum 3

Dear Sirs, I would like to ask you, if you know any solution, for querying a servers mysql database without phpmyadmin rights, for example, querying it from the website itself with a server side solution. To be a bit more specific, here is what I would like to query on my website with some PHP script. ![b1f16ae351bf5ba92c417f0008b79410](/attachments/large/3/b1f16ae351bf5ba92c417f0008b79410.png "b1f16ae351bf5ba92c417f0008b79410") Thanks in advance, Tibor

Member Avatar
Member Avatar
+0 forum 2

Dear friends, I am using Wordpress 3.6 for my current development . But my client need a system which has independent layers i.e 3 layers such as * Service Layer * DB Layer * View Layer from my analysis I can found that Wordpress has a **Theme ---- View+DB layer ** and **cannot Identify a service layer**. Please advise me with a solution. Thanks, Anes

Member Avatar
Member Avatar
+0 forum 7

Hi, Having some issues connecting to MS Access Database. I think its ot connecting to the database. Below are the source codes: import javax.swing.*; import java.awt.*; import java.awt.event.*; public class DB extends DBDriver implements ActionListener { JFrame f; JLabel Fname = new JLabel("First Name: "); JLabel Lname = new JLabel("Last Name: "); JLabel Snum = new JLabel("Student Number: "); JLabel Sec = new JLabel("Cys: "); JLabel Age = new JLabel("Age: "); JLabel Gen = new JLabel("Gender: "); JTextField t1 = new JTextField(20); JTextField t2= new JTextField(20); JTextField t3= new JTextField(20); JTextField t4= new JTextField(20); JTextField t5= new JTextField(20); JTextField t6= …

Member Avatar
Member Avatar
+0 forum 2

Hi,everyone.. I was wondering.. Is it possible to carry out other tasks in a php application while data is being uploaded(by that application) into a MySQL database?

Member Avatar
Member Avatar
+0 forum 2

# Creating a register and login page, by creating a mysql database and all php files. # ## I was reading a [thread that is dead](http://www.daniweb.com/web-development/web-design-html-and-css/threads/97183/to-create-a-registration-page-and-login-page) now, so i started this one: ## **Simple PHP login:** Create a database (mysqladmin) Name the table "dbUsers." It will need 4 fields: Name Type Addition id int(10) Primary Key, AUTO_INCREMENT username varchar(16) Unique password char(16) email varchar(25) **Create a new file and name it dbConfig.php** This will file will connect to the database <? // Replace the variable values below // with your specific database information. $host = "localhost"; $user = "UserName"; $pass …

Member Avatar
Member Avatar
+0 forum 7

Any thoughts will be most welcome. In PhpMyAdmin and Dreamweaver cs6. I would like the user of my site to be able to select a category from a list that is populated by PhpMyAdmin and then, his or her selection to reveal all of the items on the database in that category. The selector is working fine using “selectmenu” and I have the form setup which shows the data using bindings. How do I connect the two?

Member Avatar
Member Avatar
+0 forum 7

how to import the sql file in an exist database connection.. Regards

Member Avatar
Member Avatar
+0 forum 2

I want to synchronize the data on my machine with that held on a server using PhpMyAdmin. Can anyone tell me exactly what information is required on the synchronization page? I've tried loads of combinations and the, not helpful, response is always "Could not connect to the source". Any thoughts will most welcome.

Member Avatar
Member Avatar
+0 forum 2

hi..The problem is that the data is not saved in the database Knowing he was not shown to me any errors in the code, but does not store data in the database <? class myclass{ function __construct(){ $conn=mysql_connect("localhost","root","1"); mysql_select_db("society",$conn); } function validlogin($t1,$t2) { $res = mysql_query("select * from admin where username = '$t1' and pass = '$t2'"); $count = mysql_num_rows($res); if($count== 0) return false; else return true; } function addnews($t2,$t1,$f1,$date){ mysql_query("insert into news(title,content,pic,date) values('$t1','$t2','$f1','$time') "); } } ?> $t1,$date,$newimg); } ?> Knowing that he enters the database when they connect and check the user name and password ////////////////////////// <? session_start(); …

Member Avatar
Member Avatar
+0 forum 7

i'm having a problem with my project where i should read the inputs from the status port of a DB-25... Input = Inp(&H379S).... whenever i trigger one of the sensor the value of INPUT will be 135 regardless of which sensor i trigger or even if i simultaneously trigger multiple sensors... the problem is i cant distinguish which sensor has been triggered... i'm using one of the output pin as my power supply for the circuit.. are there individual port addresses for each of the status pins??

Member Avatar
Member Avatar
+0 forum 2

I've installed mysql 5.5 to work with php.From the workbench I tried to connect first time, impossible.I've allowed the program through the firewall,nothing.I read all the tutorials on the subject, still I don't understand one thing. How do I set admin privileges if I cannot connect? If I run the scripts on the command prompt I get error. Some tutorials talk about installing Wamp or other software, why do I need more junk on my pc to have the damn mysql working? And when they talk about the shell, where is the damn shell on the workbench?If I go to …

Member Avatar
Member Avatar
+0 forum 2

Hello everyone, I have a PHP form that connects to an oracle DB and should send data to the database when the form is submitted, but I can't figure out why it's not loading any of the data into the database, everything seems to be correct (though this is my first time attempting something like this, so I am likely wrong). Is there something wrong with the way in which I've structured this page, or something wrong with the way I'm binding variables? Why isn't this properly working? Note: I changed the connect string to a fake one for security. …

Member Avatar
Member Avatar
+0 forum 7

I'm working on a database project. I avve to build a DB for medical record (hospital) but I'm not too familiar with hospital stuff. I have to come up with entity sets with their attributes, build an ER diagram and then do a Query with GUI included. What I need from you guys is ideas about entity sets for medical records. I don't need anybody to build the ER or anything. I just need ideas of Entity sets. Specify if it's weak entity. I don't need attributes or relationships either. I can come up with those myself. Righ now, the …

Member Avatar
Member Avatar
+0 forum 4

Hi all. Im wondering if it is common practice to encrypt the database contents. or is it normally left in plain text. for example, in a databse I have, the contents is stored in plain text: a select query would bring up "hello world", but should it be an encrypted form of "hello world" when stored? your opinions are most welcome. In my opinion, which im not sure about, It makes it easier to transform / transport / work with while coding etc but also creates a security issue. Then again, if you encrypt thousands of records and lose the …

Member Avatar
Member Avatar
+0 forum 2

The End.